I_CnsldtnIntegRptdFinData

GR Realtime Reported Data TAI | view: IINTFINDATA | TRAN | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing
Tables used: ACDOCA, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSITEM, TF103A, FINSC_LEDGER_REP
Column Name Description
ConsolidationRecordNumber Record number of the line item record
Column Name Description
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency Value in Local Currency
💲 Currency key of the ledger currency (GroupCurrency):
AmountInGroupCurrency Value in Group Currency
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Value in Transaction Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
PartnerConsolidationUnit Partner Unit FC_BUNIT
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
AssignmentReference Assignment Reference ZUONR
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
Project Project FIS_PROJECT_NO_CONV
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
CreationDateTime Time Stamp of Creation TZNTSTMPS
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
AccountingDocument Document Number of an Accounting Document BELNR
ReferenceFiscalYear Fiscal Year GJAHR
ReferenceDocumentNumber Character field, length 32 CHAR32
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TVFK.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == KNA1.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Client
  • Business Area
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TGSB.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T004.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_CNSLDTNINTEGRPTDFINDATA.COMPANYCODE == T001.BUKRS
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T001.MANDT
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TF120.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
Dimension
  • Dimension
  • Client
  • I_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TF150.MANDT
Consolidation Unit
  • ?
  • Client
  • Consolidation Unit
  • I_CNSLDTNINTEGRPTDFINDATA.[column in domain "FC_DIMEN"] == FINCS_BUNIT.DIMEN
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == FINCS_BUNIT.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONUNIT == FINCS_BUNIT.BUNIT
Controlling Area
  • Client
  • Controlling Area
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TKA01.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • I_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == CSKS.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.COSTCENTER == CSKS.KOSTL
  • I_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Customer Number
  • Client
  • I_CNSLDTNINTEGRPTDFINDATA.CUSTOMER == KNA1.KUNNR
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_CNSLDTNINTEGRPTDFINDATA.CUSTOMERGROUP == T151.KDGRP
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Client
  • Customer or Supplier Country/Region
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T005.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T016.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TVTW.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Consolidation Financial Statement Item
  • Client
  • Consolidation Financial Statement Item
  • Consolidation Chart of Accounts
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == FINCS_FSITEM.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.FINANCIALSTATEMENTITEM == FINCS_FSITEM.ITEM
  • I_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONCHARTOFACCOUNTS == FINCS_FSITEM.ITCLG
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T856.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TFKB.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_CNSLDTNINTEGRPTDFINDATA.COMPANYCODE == SKB1.BUKRS
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == SKB1.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.GLACCOUNT == SKB1.SAKNR
Currency key of the ledger currency
  • Currency key of the ledger currency
  • Client
  • I_CNSLDTNINTEGRPTDFINDATA.GROUPCURRENCY == TCURC.WAERS
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Currency key of the local currency
  • Client
  • Currency key of the local currency
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TCURC.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.LOCALCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == MARA.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.MATERIAL == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • Product Sold Group
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T023.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.MATERIALGROUP == T023.MATKL
  • I_CNSLDTNINTEGRPTDFINDATA.SOLDPRODUCTGROUP == T023.MATKL
Order ID
  • Order ID
  • Client
  • I_CNSLDTNINTEGRPTDFINDATA.ORDERID == AUFK.AUFNR
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TSPA.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TGSB.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T880.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • ?
  • Client
  • Controlling Area
  • Partner Cost Center
  • I_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == CSKS.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_CNSLDTNINTEGRPTDFINDATA.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TFKB.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • ?
  • Client
  • Controlling Area
  • Partner Profit Center
  • I_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CEPC.DATBI
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == CEPC.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CEPC.KOKRS
  • I_CNSLDTNINTEGRPTDFINDATA.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_CNSLDTNINTEGRPTDFINDATA.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T001W.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.PLANT == T001W.WERKS
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • I_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CEPC.DATBI
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == CEPC.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CEPC.KOKRS
  • I_CNSLDTNINTEGRPTDFINDATA.PROFITCENTER == CEPC.PRCTR
Sales District
  • Client
  • Sales District
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T171.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TVKO.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == FAGL_SEGM.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Client
  • Ship-to Party
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == KNA1.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Client
  • Product Sold
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == MARA.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • Product Sold Group
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == T023.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.MATERIALGROUP == T023.MATKL
  • I_CNSLDTNINTEGRPTDFINDATA.SOLDPRODUCTGROUP == T023.MATKL
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Subitem
  • Client
  • Subitem Category
  • Subitem
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TF115.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SUBITEMCATEGORY == TF115.SITYP
  • I_CNSLDTNINTEGRPTDFINDATA.SUBITEM == TF115.SITEM
Subitem Category
  • Client
  • Subitem Category
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TF110.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SUBITEMCATEGORY == TF110.SITYP
Supplier
  • Client
  • Supplier
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == LFA1.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.SUPPLIER == LFA1.LIFNR
Currency Key
  • Client
  • Currency Key
  • I_CNSLDTNINTEGRPTDFINDATA.MANDT == TCURC.MANDT
  • I_CNSLDTNINTEGRPTDFINDATA.TRANSACTIONCURRENCY == TCURC.WAERS