T854 SAP table for – Financial statement items for consolidation

Here we would like to draw your attention to T854 table in SAP. As we know it is being mainly used with the SAP FI-LC (Consolidation in FI) component which is coming under FI module (Financial Accounting). T854 is a SAP standard transp table used for storing Financial statement items for consolidation related data in SAP. It comes under the package FKUC.

SAP T854 table

Table T854 technical data

TableT854
Data storingFinancial statement items for consolidation
ModuleFI
Sub ModuleFI-LC-LC
SAP PackageFKUC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_FIN
Table CategoryTRANSP

SAP T854 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T854 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ITEM : Consolidation item
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SPLIN : Indicator: partial breakdown
    Its data type is CHAR (Character String) with field length 1
  • FIXIN : Indicator: Selected FS item
    Its data type is CHAR (Character String) with field length 1
  • CONIN : Ind.: Item used only during consolidation
    Its data type is CHAR (Character String) with field length 1
  • AMOIN : Indicator: quantity
    Its data type is CHAR (Character String) with field length 1
  • ITSUM : Indicator: totals item
    Its data type is CHAR (Character String) with field length 1
  • SIGN : Debit/credit sign for consolidation item
    Its data type is CHAR (Character String) with field length 1
  • ITTYP : Asset/Liability/IncSt/Other
    Its data type is CHAR (Character String) with field length 1
  • CHAIN : Indicator: contra item
    Its data type is CHAR (Character String) with field length 1
  • TTYIN : Indicator: breakdown by transaction types
    Its data type is CHAR (Character String) with field length 1
  • YOAIN : Indicator: breakdown by years of acquisition
    Its data type is CHAR (Character String) with field length 1
  • ASCIN : Indicator: Breakdown by trading partners (affiliates)
    Its data type is CHAR (Character String) with field length 1
  • CURIN : Indicator: breakdown by currency
    Its data type is CHAR (Character String) with field length 1
  • ADFIN : Breakdown by additional field
    Its data type is CHAR (Character String) with field length 1
  • SETS : Definition of totals item
    Its data type is CHAR (Character String) with field length 60
  • ITCON : Contra item
    Its data type is CHAR (Character String) with field length 10
  • NEWIT : New financial statement item number
    Its data type is CHAR (Character String) with field length 10
  • ALTIT : Reference item
    Its data type is CHAR (Character String) with field length 10
  • KZEIS : Indicator: Totals item for EIS reporting
    Its data type is CHAR (Character String) with field length 1