SAP Table

TF150 Dimensions

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

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

/ Fields

TF150 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyDIMEN 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
INDGB Business area consolidation active CHAR 1 0 GSBK
INDPC Profit center consolidation activated CHAR 1 0 PCK
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
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
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
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
/ Relationships

TF150 foreign keys.

Table Field Check Table Description Check Field
TF150 DOCTY_ACS TF500 Document Types MANDT
TF150 DOCTY_ACS TF500 Document Types DIMEN
TF150 DOCTY_ACS TF500 Document Types DOCTY
TF150 HRFSCAT TF240 Consolidation Frequencies MANDT
TF150 ITCLG_FI TF120 Consolidation Charts of Accounts MANDT
TF150 ITCLG_FI TF120 Consolidation Charts of Accounts ITCLG
TF150 SITYP_FI TF110 Subitem Categories MANDT
TF150 SITYP_FI TF110 Subitem Categories SITYP
Back to SAP tables