SAP table TF150 (Dimensions)

SAP table TF150 has 2 primary key fields being MANDT,DIMEN.

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 FC_DIMEN
IAIND Status indicator CHAR 1 0 FC_IAIND_D
BULGH Length of the consolidation unit NUMC 2 0 FC_BULGH
CGLGH Length of consolidation group NUMC 2 0 FC_CGLGH
INDGS Company consolidation activated CHAR 1 0 GSNK
Company consolidation not activated
X Company consolidation activated
INDGB Business area consolidation active CHAR 1 0 GSBK
Business area consolidation inactive
X Business area consolidation active
INDPC Profit center consolidation activated CHAR 1 0 PCK
Profit center consolidation not activated
X Profit center consolidation activated
ITCLG_FI Consolidation chart of accounts for data transfer CHAR 2 0 TF120 FC_ITCLG_I
SITYP_FI Subitem category for data transfers CHAR 3 0 TF110 FC_SITYP_I
SIGNC_FI Delimiter for Companies & Business Areas CHAR 1 0 FC_SIGNCFI
IGSGB_FI Sequence for converting companies/business areas NUMC 1 0 FC_IGSGBFI
1 First companies, then business areas
2 First business areas, then companies
HLIND Use hierarchy levels CHAR 1 0 FC_HLIND
PCUIND Substitute the partner unit during the rollup CHAR 1 0 FC_PCUIND
REVIND Reverse documents CHAR 1 0 FC_REVIND
PROTYP Apportionment Procedure for Two-sided Eliminations NUMC 1 0 FC_PROTYP
0 Minimum
1 Product
CIINVCHECK Check Investment Against Equity CHAR 1 0 FC_CIINVCHECK
HRFSCAT Cons frequency of amortization of reported fair value adjs CHAR 1 0 TF240 FC_HRFSCAT
USTPFLG Universal Statistical Posting Logic CHAR 1 0 FC_USTPFLG
NEWLL_YEAR Fiscal Year from Which New Level Logic Is to Be Applied NUMC 4 0 FC_NEWLL_YEAR
SETGENMODE Options for automatic set generation NUMC 1 0 FC_SETGENMODE
0 Never
1 User-controlled
2 Prompt if changed
3 Automatic if changed
SETGENCGY Year or Period-dependent Sets for Cons Groups CHAR 1 0 FC_SETGENCGY
DOCTY_ACS Document Type for Standardizing Entries CHAR 2 0 TF500 FC_DOCTY_10
ASTHFS Assets Held for Sale CHAR 1 0 FC_ASTHFS
PERIV Fiscal Year Variant CHAR 2 0 FC_PERIV_GLOBAL
DIMEN_SOURCE_S4GR Source for Migration to SAP S/4HANA CHAR 1 0 FC_DIMEN_SOURCE_S4GR
INV_ITEM_SEP Separated Investment Items in Transition Phase CHAR 1 0 FC_INVESTMENT_ITEM_SEPARATED
DOCTY_ITEM_SUBST Document Type for Item Substitution in SAP S/4HANA CHAR 2 0 FC_DOCTY_ITEM_SUBST

TF150 foreign key relationships

Table Field Check Table Check Field
0 TF150 DOCTY_ACS TF500 Document Types MANDT
0 TF150 DOCTY_ACS TF500 Document Types DIMEN
0 TF150 DOCTY_ACS TF500 Document Types DOCTY
1 TF150 HRFSCAT TF240 Consolidation Frequencies MANDT
0 TF150 ITCLG_FI TF120 Consolidation Charts of Accounts MANDT
0 TF150 ITCLG_FI TF120 Consolidation Charts of Accounts ITCLG
1 TF150 SITYP_FI TF110 Subitem Categories MANDT
1 TF150 SITYP_FI TF110 Subitem Categories SITYP