SAP table T854 (Financial statement items for consolidation)

SAP table T854 has 2 primary key fields being MANDT,ITEM.

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 * MANDT
ITEM Consolidation item CHAR 10 0 RITEM
SPLIN Indicator: partial breakdown CHAR 1 0 KZSPLIN
FIXIN Indicator: Selected FS item CHAR 1 0 KZFIXIN
CONIN Ind.: Item used only during consolidation CHAR 1 0 KZCONIN
AMOIN Indicator: quantity CHAR 1 0 KZMENGE
ITSUM Indicator: totals item CHAR 1 0 KZITSUM
SIGN Debit/credit sign for consolidation item CHAR 1 0 SHKZVZ
+ Debit
- Credit
ITTYP Asset/Liability/IncSt/Other CHAR 1 0 ITTYP
A Assets
G P&L
P Liabilities & Equity
S Other
CHAIN Indicator: contra item CHAR 1 0 KZCHAIN
TTYIN Indicator: breakdown by transaction types CHAR 1 0 KZTTYIN
YOAIN Indicator: breakdown by years of acquisition CHAR 1 0 KZYOAIN
ASCIN Indicator: Breakdown by trading partners (affiliates) CHAR 1 0 KZASCIN
CURIN Indicator: breakdown by currency CHAR 1 0 KZCURIN
ADFIN Breakdown by additional field CHAR 1 0 FK_ADFIN
No breakdown
1 Breakdown of additional field 1
2 Breakdown of additional fields 1 and 2
3 Breakdown of additional fields 1, 2, and 3
SETS Definition of totals item CHAR 60 0 DEFSUMPOS
ITCON Contra item CHAR 10 0 T854 RITEM_CON
NEWIT New financial statement item number CHAR 10 0 * RITEM_NEW
ALTIT Reference item CHAR 10 0 * RITEM_ALT
KZEIS Indicator: Totals item for EIS reporting CHAR 1 0 KZEIS

T854 foreign key relationships

Table Field Check Table Check Field
0 T854 ITCON T854 Financial statement items for consolidation MANDT