P_CNSLDTNINTEGRPTDFINDATA_02

Fill curreny fields (TAI) | view: PINTFINDATA_02 | 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
Column Name Description
AmountInGroupCurrency Amount in Freely Defined Currency 8
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInTransactionCurrency Amount in Balance Transaction Currency
💲 Functional Currency (ConsolidationUnitLocalCurrency):
AmountInLocalCurrency Amount in Functional Currency
Column Name Description
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
BaseUnit null
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
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
  • Balance Transaction Currency
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TCURC.MANDT
Billing Type
  • Billing Type
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.BILLTOPARTY == KNA1.KUNNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.BUSINESSAREA == TGSB.GSBER
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.CHARTOFACCOUNTS == T004.KTOPL
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T004.MANDT
Company
  • Company
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.COMPANY == T880.RCOMP
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T880.MANDT
Company Code
  • Company Code
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.COMPANYCODE == T001.BUKRS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T001.MANDT
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TF120.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
Dimension
  • Client
  • Dimension
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TF150.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • ?
  • Consolidation Unit
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.[column in domain "FC_DIMEN"] == FINCS_BUNIT.DIMEN
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONSOLIDATIONUNIT == FINCS_BUNIT.BUNIT
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == FINCS_BUNIT.MANDT
Functional Currency
  • Functional Currency
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONTROLLINGAREA == TKA01.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_CNSLDTNINTEGRPTDFINDATA_02.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONTROLLINGAREA == CSKS.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == CSKS.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_02.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.CUSTOMER == KNA1.KUNNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.CUSTOMERGROUP == T151.KDGRP
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TVTW.MANDT
Consolidation Financial Statement Item
  • Consolidation Financial Statement Item
  • Client
  • Consolidation Chart of Accounts
  • P_CNSLDTNINTEGRPTDFINDATA_02.FINANCIALSTATEMENTITEM == FINCS_FSITEM.ITEM
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == FINCS_FSITEM.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONSOLIDATIONCHARTOFACCOUNTS == FINCS_FSITEM.ITCLG
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T856.MANDT
FS Item Mapping Version
  • FS Item Mapping Version
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.FSITEMMAPPINGVERSION == TF23A.IMPVS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TF23A.MANDT
Functional Area
  • Functional Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.FUNCTIONALAREA == TFKB.FKBER
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.GLACCOUNT == SKB1.SAKNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.COMPANYCODE == SKB1.BUKRS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == SKB1.MANDT
Group Currency of Consolidation Version
  • Client
  • Group Currency of Consolidation Version
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TCURC.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_02.GROUPCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Material Number
  • Material Number
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.MATERIAL == MARA.MATNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.MATERIALGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_02.SOLDPRODUCTGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T023.MANDT
Order ID
  • Order ID
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.ORDERID == AUFK.AUFNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.ORGANIZATIONDIVISION == TSPA.SPART
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TSPA.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.PARTNERBUSINESSAREA == TGSB.GSBER
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.PARTNERCOMPANY == T880.RCOMP
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T880.MANDT
Partner Consolidation Unit
  • Partner Consolidation Unit
  • ?
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.PARTNERCONSOLIDATIONUNIT == FINCS_BUNIT.BUNIT
  • P_CNSLDTNINTEGRPTDFINDATA_02.[column in domain "FC_DIMEN"] == FINCS_BUNIT.DIMEN
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == FINCS_BUNIT.MANDT
Partner Cost Center
  • ?
  • Partner Cost Center
  • Controlling Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_02.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONTROLLINGAREA == CSKS.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == CSKS.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TFKB.MANDT
Partner Profit Center
  • ?
  • Partner Profit Center
  • Controlling Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_02.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONTROLLINGAREA == CEPC.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T001W.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_02.PLANT == T001W.WERKS
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_02.PROFITCENTER == CEPC.PRCTR
  • P_CNSLDTNINTEGRPTDFINDATA_02.CONTROLLINGAREA == CEPC.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.SALESDISTRICT == T171.BZIRK
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.SALESORGANIZATION == TVKO.VKORG
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.SEGMENT == FAGL_SEGM.SEGMENT
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.SHIPTOPARTY == KNA1.KUNNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.SOLDPRODUCT == MARA.MATNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.MATERIALGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_02.SOLDPRODUCTGROUP == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == T023.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Consolidation Subitem
  • Consolidation Subitem Category
  • Client
  • Consolidation Subitem
  • P_CNSLDTNINTEGRPTDFINDATA_02.SUBITEMCATEGORY == TF115.SITYP
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TF115.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_02.SUBITEM == TF115.SITEM
Consolidation Subitem Category
  • Consolidation Subitem Category
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.SUBITEMCATEGORY == TF110.SITYP
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == TF110.MANDT
Supplier
  • Supplier
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_02.SUPPLIER == LFA1.LIFNR
  • P_CNSLDTNINTEGRPTDFINDATA_02.MANDT == LFA1.MANDT