SAP Table T854

Financial statement items for consolidation

T854 (Financial statement items for consolidation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T854 to other SAP tables.

T854 table fields

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

T854 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T854 ITCON T854 MANDT T854 Financial statement items for consolidation MANDT
T854 ITCON T854 ITCON T854 Financial statement items for consolidation ITEM