C_CnsldtnIntegRptdFinData

FINCS Realtime Reported Data TAI | view: CINTFINDATA | 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
ReferenceDocumentNumber Character field, length 32 CHAR32
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
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TVFK.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Bill-to Party
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.BILLTOPARTY == KNA1.KUNNR
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.BUSINESSAREA == TGSB.GSBER
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T004.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T001.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.COMPANYCODE == T001.BUKRS
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TF120.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
Dimension
  • Client
  • Dimension
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TF150.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • Client
  • ?
  • Consolidation Unit
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == FINCS_BUNIT.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.[column in domain "FC_DIMEN"] == FINCS_BUNIT.DIMEN
  • C_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONUNIT == FINCS_BUNIT.BUNIT
Controlling Area
  • Client
  • Controlling Area
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TKA01.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == CSKS.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.COSTCENTER == CSKS.KOSTL
  • C_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CSKS.DATBI
  • C_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Client
  • Customer Number
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == KNA1.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T151.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T005.MANDT
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T016.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TVTW.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Consolidation Financial Statement Item
  • Client
  • Consolidation Chart of Accounts
  • Consolidation Financial Statement Item
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == FINCS_FSITEM.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.CONSOLIDATIONCHARTOFACCOUNTS == FINCS_FSITEM.ITCLG
  • C_CNSLDTNINTEGRPTDFINDATA.FINANCIALSTATEMENTITEM == FINCS_FSITEM.ITEM
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T856.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TFKB.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • Company Code
  • G/L Account
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == SKB1.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.COMPANYCODE == SKB1.BUKRS
  • C_CNSLDTNINTEGRPTDFINDATA.GLACCOUNT == SKB1.SAKNR
Currency key of the ledger currency
  • Currency key of the ledger currency
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.GROUPCURRENCY == TCURC.WAERS
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TCURC.MANDT
Currency key of the local currency
  • Client
  • Currency key of the local currency
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TCURC.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.LOCALCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == MARA.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.MATERIAL == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • Product Sold Group
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T023.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.MATERIALGROUP == T023.MATKL
  • C_CNSLDTNINTEGRPTDFINDATA.SOLDPRODUCTGROUP == T023.MATKL
Order ID
  • Order ID
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.ORDERID == AUFK.AUFNR
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TSPA.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Partner Business Area
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.PARTNERBUSINESSAREA == TGSB.GSBER
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.PARTNERCOMPANY == T880.RCOMP
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T880.MANDT
Partner Cost Center
  • Partner Cost Center
  • Client
  • ?
  • Controlling Area
  • C_CNSLDTNINTEGRPTDFINDATA.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == CSKS.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CSKS.DATBI
  • C_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CSKS.KOKRS
Partner Functional Area
  • Partner Functional Area
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TFKB.MANDT
Partner Profit Center
  • Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • C_CNSLDTNINTEGRPTDFINDATA.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == CEPC.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CEPC.DATBI
  • C_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T001W.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.PLANT == T001W.WERKS
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == CEPC.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.[column in domain "DATBI"] == CEPC.DATBI
  • C_CNSLDTNINTEGRPTDFINDATA.CONTROLLINGAREA == CEPC.KOKRS
  • C_CNSLDTNINTEGRPTDFINDATA.PROFITCENTER == CEPC.PRCTR
Sales District
  • Sales District
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.SALESDISTRICT == T171.BZIRK
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TVKO.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == FAGL_SEGM.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Ship-to Party
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.SHIPTOPARTY == KNA1.KUNNR
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.SOLDPRODUCT == MARA.MATNR
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == MARA.MANDT
Product Sold Group
  • Client
  • Product Sold Group
  • Product Sold Group
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == T023.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.MATERIALGROUP == T023.MATKL
  • C_CNSLDTNINTEGRPTDFINDATA.SOLDPRODUCTGROUP == T023.MATKL
Subitem
  • Subitem Category
  • Client
  • Subitem
  • C_CNSLDTNINTEGRPTDFINDATA.SUBITEMCATEGORY == TF115.SITYP
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TF115.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.SUBITEM == TF115.SITEM
Subitem Category
  • Subitem Category
  • Client
  • C_CNSLDTNINTEGRPTDFINDATA.SUBITEMCATEGORY == TF110.SITYP
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TF110.MANDT
Supplier
  • Client
  • Supplier
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == LFA1.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.SUPPLIER == LFA1.LIFNR
Currency Key
  • Client
  • Currency Key
  • C_CNSLDTNINTEGRPTDFINDATA.MANDT == TCURC.MANDT
  • C_CNSLDTNINTEGRPTDFINDATA.TRANSACTIONCURRENCY == TCURC.WAERS