T870 SAP table for – Consolidation method assignment

Here we would like to draw your attention to T870 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). T870 is a SAP standard transp table used for storing Consolidation method assignment related data in SAP. It comes under the package FKUC.

SAP T870 table

Table T870 technical data

TableT870
Data storingConsolidation method assignment
ModuleFI
Sub ModuleFI-LC-LC
SAP PackageFKUC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_FIN
Table CategoryTRANSP

SAP T870 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 T870 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RVERS : Version for consolidation of investments method
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RSUBD : Subgroup
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RCOMP : Company
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • RYEAR : “From” year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • METH : Consolidation method
    Its data type is CHAR (Character String) with field length 5
  • RATIO : Proportion
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FYEAR : Year of first consolidation
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FPERI : Period of first consolidation
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • GPERI : Period for the start of goodwill amortization
    Its data type is NUMC (Character String with Digits Only) with field length 3