T869 SAP table for – Consolidation methods

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

SAP T869 table

Table T869 technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • METH : Consolidation method
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • TYPE : Consolidation of investments method
    Its data type is CHAR (Character String) with field length 1
  • VARI : Valuation basis
    Its data type is CHAR (Character String) with field length 1
  • DEPLG : Goodwill amortization: Duration in years
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PERID : Goodwill amortization: Duration in months
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FDEP : Amortization of new goodwill over remaining life
    Its data type is CHAR (Character String) with field length 1
  • DITC : Differential: Debit item
    Its data type is CHAR (Character String) with field length 10
  • DITD : Differential: Credit item
    Its data type is CHAR (Character String) with field length 10
  • MVT1C : Transaction type: Investments on credits side
    Its data type is CHAR (Character String) with field length 3
  • MVT1D : Transaction type: Investments on debits side
    Its data type is CHAR (Character String) with field length 3
  • MVT2C : Transaction type: Equity on credits side
    Its data type is CHAR (Character String) with field length 3
  • MVT2D : Transaction type: Equity on debits side
    Its data type is CHAR (Character String) with field length 3
  • MVT3C : Transaction type: Debit difference
    Its data type is CHAR (Character String) with field length 3
  • MVT3D : Transaction type: Credit difference
    Its data type is CHAR (Character String) with field length 3
  • MVT4C : Transaction type: Amortization
    Its data type is CHAR (Character String) with field length 3
  • MVT4D : Transaction type: Write-ups
    Its data type is CHAR (Character String) with field length 3
  • DEPC : Amortization item
    Its data type is CHAR (Character String) with field length 10
  • DEPD : Write-up item
    Its data type is CHAR (Character String) with field length 10
  • RLEVL : Posting level for inclusion in consolidation of investments
    Its data type is CHAR (Character String) with field length 1
  • EQNEG : Indicator: negative NBV of investment
    Its data type is CHAR (Character String) with field length 1
  • NOGVW : Indicator: No posting to appropriation of retained earnings
    Its data type is CHAR (Character String) with field length 1
  • URES : Reverse hidden reserves (fair value adjustments)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RDEPRT : Depreciation method
    Its data type is CHAR (Character String) with field length 1
  • BGWAM : Start of goodwill amortization with step acquisition
    Its data type is CHAR (Character String) with field length 1
  • SETIN : Set ID for investment items
    Its data type is CHAR (Character String) with field length 12
  • SETEQ : Equity: FS item set for subsequent consolidation
    Its data type is CHAR (Character String) with field length 12
  • ASORT : Seqiemce of consolidation of investments activities
    Its data type is CHAR (Character String) with field length 7
  • GWAMT : Financial statement item for amortization of goodwill
    Its data type is CHAR (Character String) with field length 10
  • ACTIVE : Method is activated
    Its data type is CHAR (Character String) with field length 1
  • CHECKED : Check indicator
    Its data type is CHAR (Character String) with field length 1
  • DAT_CHECK : Creation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • USER_CHECK : Created By
    Its data type is CHAR (Character String) with field length 12
  • MVT5A : TTy: Acquisition of hidden reserves/debts
    Its data type is CHAR (Character String) with field length 3
  • MVT5B : Transaction type: Amortization of hidden reserves/debts
    Its data type is CHAR (Character String) with field length 3
  • MVT5C : Transaction type: Write-up of hidden reserves/debts
    Its data type is CHAR (Character String) with field length 3
  • GWB : Handling of goodwill
    Its data type is CHAR (Character String) with field length 1
  • SETEQ2 : Equity: FS item set for first consolidation
    Its data type is CHAR (Character String) with field length 12
  • MSETEQ1 : Equity: Transaction type set for subsequent consolidation
    Its data type is CHAR (Character String) with field length 12
  • MSETEQ2 : Equity: Transaction type set for first consolidation
    Its data type is CHAR (Character String) with field length 12
  • VALDB : Indicator: Always read values from database
    Its data type is CHAR (Character String) with field length 1
  • MVT6A : Transaction type: Proporational elimination
    Its data type is CHAR (Character String) with field length 3
  • NGAFLG : Ind.: Amortization of negative goodwill
    Its data type is CHAR (Character String) with field length 1
  • SETEQI1 : Set of earnings items
    Its data type is CHAR (Character String) with field length 12
  • SETEQI2 : Set of items for distribution of dividends
    Its data type is CHAR (Character String) with field length 12
  • SETEQI3 : Set of items for translation differences
    Its data type is CHAR (Character String) with field length 12
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.