P_CNSLDTNINTEGRPTDFINDATA_01

Select from ACDOCA (TAI) | view: PINTFINDATA_01 | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing
Tables used: ACDOCA, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSITEM, FINSC_LEDGER_REP
Column Name Description
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInTransactionCurrency Amount in Balance Transaction Currency
AmountInGroupCurrency Amount in Global Currency
osl Amount in Freely Defined Currency 1
vsl Amount in Freely Defined Currency 2
bsl Amount in Freely Defined Currency 3
csl Amount in Freely Defined Currency 4
dsl Amount in Freely Defined Currency 5
esl Amount in Freely Defined Currency 6
fsl Amount in Freely Defined Currency 7
gsl Amount in Freely Defined Currency 8
💲 Functional Currency (ConsolidationUnitLocalCurrency):
AmountInLocalCurrency Amount in Functional Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
CnsldtnVersionGroupCrcySource Source for Group Currency Key Figure Show values
Column Name Description Domain name
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
BreakdownCategory Breakdown Category FC_ITGRP
AssignmentReference Assignment Reference ZUONR
WBSElementExternalID WBS Element FIS_WBS
Project Project FIS_PROJECT
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
CreationDateTime Time Stamp of Creation TZNTSTMPS
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
AccountingDocument Journal Entry BELNR
ReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TCURC.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T006.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.BASEUNIT == T006.MSEHI
Billing Type
  • Client
  • Billing Type
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TVFK.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == KNA1.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Client
  • Business Area
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TGSB.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.CHARTOFACCOUNTS == T004.KTOPL
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T004.MANDT
Company
  • Client
  • Company
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T880.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.COMPANY == T880.RCOMP
Company Code
  • Client
  • Company Code
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T001.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.COMPANYCODE == T001.BUKRS
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TF120.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
Dimension
  • Dimension
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TF150.MANDT
Consolidation Unit
  • Client
  • ?
  • Consolidation Unit
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == FINCS_BUNIT.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.[column in domain "FC_DIMEN"] == FINCS_BUNIT.DIMEN
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONSOLIDATIONUNIT == FINCS_BUNIT.BUNIT
Functional Currency
  • Client
  • Functional Currency
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TCURC.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TKA01.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == CSKS.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONTROLLINGAREA == CSKS.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_01.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.CUSTOMER == KNA1.KUNNR
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T151.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TVTW.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Consolidation Financial Statement Item
  • Client
  • Consolidation Chart of Accounts
  • Consolidation Financial Statement Item
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == FINCS_FSITEM.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONSOLIDATIONCHARTOFACCOUNTS == FINCS_FSITEM.ITCLG
  • P_CNSLDTNINTEGRPTDFINDATA_01.FINANCIALSTATEMENTITEM == FINCS_FSITEM.ITEM
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T856.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.FINANCIALTRANSACTIONTYPE == T856.TRTYP
FS Item Mapping Version
  • FS Item Mapping Version
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.FSITEMMAPPINGVERSION == TF23A.IMPVS
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TF23A.MANDT
Functional Area
  • Client
  • Functional Area
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TFKB.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == SKB1.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.GLACCOUNT == SKB1.SAKNR
  • P_CNSLDTNINTEGRPTDFINDATA_01.COMPANYCODE == SKB1.BUKRS
Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.GROUPCURRENCY == TCURC.WAERS
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Material Number
  • Client
  • Material Number
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == MARA.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.MATERIAL == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.SOLDPRODUCTGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_01.MATERIALGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T023.MANDT
Order ID
  • Order ID
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.ORDERID == AUFK.AUFNR
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TSPA.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TGSB.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T880.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.PARTNERCOMPANY == T880.RCOMP
Partner Consolidation Unit
  • Client
  • ?
  • Partner Consolidation Unit
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == FINCS_BUNIT.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.[column in domain "FC_DIMEN"] == FINCS_BUNIT.DIMEN
  • P_CNSLDTNINTEGRPTDFINDATA_01.PARTNERCONSOLIDATIONUNIT == FINCS_BUNIT.BUNIT
Partner Cost Center
  • Client
  • ?
  • Controlling Area
  • Partner Cost Center
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == CSKS.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONTROLLINGAREA == CSKS.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_01.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TFKB.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • P_CNSLDTNINTEGRPTDFINDATA_01.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == CEPC.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == FAGL_SEGM.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T001W.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.PLANT == T001W.WERKS
Profit Center
  • Client
  • ?
  • Profit Center
  • Controlling Area
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == CEPC.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_01.PROFITCENTER == CEPC.PRCTR
  • P_CNSLDTNINTEGRPTDFINDATA_01.CONTROLLINGAREA == CEPC.KOKRS
Sales District
  • Client
  • Sales District
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T171.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TVKO.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == FAGL_SEGM.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Client
  • Ship-to Party
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == KNA1.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Client
  • Product Sold
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == MARA.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.SOLDPRODUCTGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_01.MATERIALGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == T023.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Consolidation Subitem
  • Client
  • Consolidation Subitem Category
  • Consolidation Subitem
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TF115.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.SUBITEMCATEGORY == TF115.SITYP
  • P_CNSLDTNINTEGRPTDFINDATA_01.SUBITEM == TF115.SITEM
Consolidation Subitem Category
  • Client
  • Consolidation Subitem Category
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == TF110.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_01.SUBITEMCATEGORY == TF110.SITYP
Supplier
  • Supplier
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_01.SUPPLIER == LFA1.LIFNR
  • P_CNSLDTNINTEGRPTDFINDATA_01.MANDT == LFA1.MANDT