SAP table TF180 (Consolidation Groups)

SAP table TF180 has 3 primary key fields being MANDT,DIMEN,CONGR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
DIMEN Dimension CHAR 2 0 TF150 FC_DIMEN
CONGR Consolidation Group CHAR 18 0 FC_CONGR
HLEVL Hierarchy level CHAR 2 0 TF195 FC_HLEVL
SCOPE Consolidation Group as List of Consolidation Units CHAR 1 0 FC_SCOPE
No
M Migrated
X Yes

TF180 foreign key relationships

Table Field Check Table Check Field
0 TF180 DIMEN TF150 Dimensions DIMEN
1 TF180 HLEVL TF195 Hierarchy Levels MANDT
1 TF180 HLEVL TF195 Hierarchy Levels DIMEN