1. SAP Tutorial
  2. FI Module

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

    • T869 related tables

    • T85CT : Third additional field: Texts
    • T879 : Standard texts
    • T857N : Validation groups
    • T863W : Valuations
    • T868L : Elimination of IC profit/loss: Vendor data
    • T85BT : Second additional field: Texts
    • T855 : Reasons for inclusion in consolidation
    • T884 : Currency translation
    • T854 : Financial statement items for consolidation
    • T857A : Column layout of data entry form
    • T877L : Consolidation activity groups: Texts
    • T852 : Subgroups
    • FILCO : FI-LC: Acct assign.fields (Object-TrPartner) for table FILCT
    • T857X : Line layout for data entry form: Name
    • EWULC01 : FI-LC: LC ledger
    • T850Z : Layout: FS chart of accounts
    • T850G : Upload Methods: Texts
    • T852O : Consolidation frequencies: Texts
    • GLT2 : Consolidation totals table
    • T863C : Report groups: Names

    Related References

    Related Tutorials

    T884M SAP table for – Currency translation methods used in Consolidation

    T884M table in SAP FI (Consolidation in FI) module. This table is used for storing data of Currency translation methods...

    T869T SAP table for – Consolidation of investments methods

    T869T table in SAP FI (Consolidation in FI) module. This table is used for storing data of Consolidation of investments...

    T858T SAP table for – Consolidation version texts

    T858T table in SAP FI (Consolidation in FI) module. This table is used for storing data of Consolidation version texts....

    T880G SAP table for – Consolidation companies

    T880G table in SAP FI (Consolidation in FI) module. This table is used for storing data of Consolidation companies. See...

    TKMGB SAP table for – Business area consolidation: SD assignments

    TKMGB table in SAP FI (Consolidation in FI) module. This table is used for storing data of Business area consolidation:...

    TLMGB SAP table for – Business area consolidation: MM assignments

    TLMGB table in SAP FI (Consolidation in FI) module. This table is used for storing data of Business area consolidation:...

    T850 SAP table for – Company data for Consolidation

    T850 table in SAP FI (Consolidation in FI) module. This table is used for storing data of Company data for...

    «
    »