SAP table TF540 (Consolidation Tasks)

SAP table TF540 has 3 primary key fields being MANDT,DIMEN,CACTI.

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
CACTI Task CHAR 10 0 FC_CACTI
CACTT Task category CHAR 2 0 FC_CACTT
01 Balance Carryforward
02 Data Collection
03 Reported Data Validation
04 Manual Posting
05 Currency Translation
06 Standardized Data Validation
07 Item Substitution/Retained Earnings
08 Preparation for Consolidation Group Changes
09 Consolidated Data Validation
0A Apportionment
0B Validation of Universal Documents
0C Copy Task
0D Release of Universal Documents
0E Realignment Function
0U Custom Task, Data Monitor
10 Interunit Elimination
16 External Documents Consolidation Monitor
20 Elimination of IU Profit/Loss in Inventory
30 Elimination of IU Profit/Loss in Transferred Assets
40 Consolidation of Investments
45 Posting of Group Shares
50 Reclassification
60 Rollup of Consolidated Values
70 Validation of Consolidated Values
80 Integration in Consolidation Group
9U Custom Task, Consolidation Monitor
CACTE Task Origin CHAR 1 0 FC_CACTE
Internal Task
1 Validation in SAP S/4HANA

TF540 foreign key relationships

Table Field Check Table Check Field
0 TF540 DIMEN TF150 Dimensions DIMEN