PROFIT CENTER HIERARCHY Table
Structure for creating reports which rollup by Profit Center or Profit Center Node. Taken from SAP's Profit Center Hierarchy.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LEVEL1_ID |
The code assigned to this Profit Center Group hierarchy node in SAP. |
VARCHAR2 |
10 |
LEVEL1_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL2_ID |
The code assigned to this Profit Center Group hierarchy node in SAP. |
VARCHAR2 |
10 |
LEVEL2_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL3_ID |
The code assigned to this Profit Center Group hierarchy node in SAP. |
VARCHAR2 |
10 |
LEVEL3_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL4_ID |
The code assigned to this Profit Center Group hierarchy node in SAP. |
VARCHAR2 |
10 |
LEVEL4_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL5_ID |
The code assigned to this Profit Center Group hierarchy node in SAP. |
VARCHAR2 |
10 |
LEVEL5_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL6_ID |
The code assigned to this Profit Center Group hierarchy node in SAP. |
VARCHAR2 |
10 |
LEVEL6_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL7_ID |
The code assigned to this Profit Center Group hierarchy node in SAP. |
VARCHAR2 |
10 |
LEVEL7_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
PROFIT_CENTER_KEY |
Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
11 |
SEARCH_ID |
Profit Center Node list used to limit when using the Profit Center Hierarchy table. This field should be used to limit only. |
VARCHAR2 |
11 |
SEARCH_NAME |
Profit Center Node name used to limit when using the Profit Center Hierarchy table. This field should be used to limit only. |
VARCHAR2 |
40 |