I_MatrixCnsldtnFndnPeriodic

Matrix Consolidation Foundation | view: IMCFNDNP | Extraction: Not supported | Component: Embedded Analytics
Tables used: ACDOCU, ACDOCU, FINCS_GRPSTR, TF200
Column Name Description
ConsolidationLedger FK Ledger
ConsolidationDimension FK Dimension
FiscalYear Fiscal Year
ConsolidationDocumentNumber Group Journal Entry
ConsolidationPostingItem Group Journal Entry Item
ConsolidationGroup FK Consolidation Group
FiscalPeriod Fiscal Period
PeriodMode Period Mode Show values
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency Amount in Local Currency
💲 Group Currency (GroupCurrency):
AmountInGroupCurrency Amount in Group Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity
CnsldtnQuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
CurrencyTranslationDate Value Date for Currency Translation
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
Column Name Description
PeriodMode Period Mode Show values
GLRecordType Record Type Show values
DebitCreditCode Debit/Credit Indicator Show values
PostingLevel Posting Level Show values
ConsolidationApportionment Apportionment Show values
CurrencyConversionsDiffType Currency Translation Show values
RefConsolidationDocumentType Document Category Show values
InvestmentActivityType Consolidation of Investments Activity Show values
Column Name Description Domain name
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
PostingFiscalPeriod Fiscal Period POPER
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
DocumentItemText Item Text TEXT50
ConsolidationPostgItemAutoFlag Indicator: Automatic posting lines TEXT1
BusinessTransactionType Business Transaction CHAR4
RefConsolidationDocumentNumber Document Number of an Accounting Document BELNR
ReferenceFiscalYear Original Fiscal Year GJAHR
RefConsolidationPostingItem Six-figure number of line item BUZEI6
RefBusinessTransactionType Business Transaction CHAR4
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ReverseDocument Reverse Document Number BELNR
ReversedDocument Number of Reversed Document BELNR
InvestmentActivity Consolidation of Investments Activity Number BELNR
ConsolidationDocReversalYear Year of reversal document or reversed document GJAHR
ReferenceDocumentType Reference procedure AWTYP
ReferenceDocumentContext Reference Organizational Units AWORG
LogicalSystem Logical system LOGSYS
AssignmentReference Assignment number ZUONR
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Project Project Number (External) Edited PS_PSPID_EDIT
CustomerSupplierCorporateGroup Group key KONZS
OriginReference Origin Reference FINCS_ORIG_REF
CnsldtnGroupJrnlEntryBundle Document Bundle Number FINCS_BUNNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T006.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.BASEUNIT == T006.MSEHI
Billing Type
  • Client
  • Billing Type
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TVFK.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == KNA1.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Client
  • Business Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TGSB.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_MATRIXCNSLDTNFNDNPERIODIC.CHARTOFACCOUNTS == T004.KTOPL
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T004.MANDT
Ad Hoc Item
  • Client
  • ?
  • Ad Hoc Item
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == FINCS_ADHITM.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.[column in domain "FC_ITCLG"] == FINCS_ADHITM.ITCLG
  • I_MATRIXCNSLDTNFNDNPERIODIC.CNSLDTNADHOCITEM == FINCS_ADHITM.ADHOCITEM
Ad Hoc Set
  • Client
  • Ad Hoc Set
  • ?
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == FINCS_ADHSET.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CNSLDTNADHOCSET == FINCS_ADHSET.ADHOCSET
  • I_MATRIXCNSLDTNFNDNPERIODIC.[column in domain "FC_ITCLG"] == FINCS_ADHSET.ITCLG
Ad Hoc Set Item
  • Client
  • Ad Hoc Set
  • Ad Hoc Set Item
  • ?
Company
  • Client
  • Company
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T880.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.COMPANY == T880.RCOMP
Original company code
  • Client
  • Original company code
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T001.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.COMPANYCODE == T001.BUKRS
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF120.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
Dimension
  • Client
  • Dimension
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF150.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDIMENSION == TF150.DIMEN
Document Type
  • Client
  • Dimension
  • Document Type
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF500.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDIMENSION == TF500.DIMEN
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
Consolidation Group
  • Client
  • Consolidation Group
  • Dimension
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF180.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONGROUP == TF180.CONGR
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDIMENSION == TF180.DIMEN
Ledger
  • Client
  • Ledger
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T881.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONLEDGER == T881.RLDNR
Consolidation Unit
  • Client
  • Consolidation Unit
  • Dimension
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF160.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONUNIT == TF160.BUNIT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDIMENSION == TF160.DIMEN
Consolidation Version
  • Client
  • Consolidation Version
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF200.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONVERSIONELEMENT == TF200.RVERS
Controlling Area
  • Client
  • Controlling Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TKA01.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == CSKS.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.COSTCENTER == CSKS.KOSTL
  • I_MATRIXCNSLDTNFNDNPERIODIC.[column in domain "DATBI"] == CSKS.DATBI
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Client
  • Customer Number
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == KNA1.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T151.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CUSTOMERGROUP == T151.KDGRP
Country/Region Key
  • Client
  • Country/Region Key
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T005.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Industry key
  • Client
  • Industry key
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T016.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TVTW.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Financial Statement Item
  • Client
  • Financial Statement Item
  • Consolidation Chart of Accounts
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF100.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.FINANCIALSTATEMENTITEM == TF100.ITEM
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG
Transaction type
  • Client
  • Transaction type
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T856.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TFKB.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.FUNCTIONALAREA == TFKB.FKBER
Account Number
  • Client
  • Original company code
  • Account Number
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == SKB1.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.COMPANYCODE == SKB1.BUKRS
  • I_MATRIXCNSLDTNFNDNPERIODIC.GLACCOUNT == SKB1.SAKNR
Investee Unit
  • Client
  • Investee Unit
  • Dimension
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF160.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDIMENSION == TF160.DIMEN
Investor Unit
  • Client
  • Investor Unit
  • Dimension
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF160.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.INVESTORCONSOLIDATIONUNIT == TF160.BUNIT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDIMENSION == TF160.DIMEN
Reason Code
  • Client
  • Reason Code
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == ICA_RC.RCLNT
  • I_MATRIXCNSLDTNFNDNPERIODIC.MATCHINGREASONCODE == ICA_RC.RCODE
Material Number
  • Client
  • Material Number
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == MARA.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T023.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.MATERIALGROUP == T023.MATKL
Order Number
  • Client
  • Order Number
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == AUFK.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TSPA.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.ORGANIZATIONDIVISION == TSPA.SPART
Trading partner's business area
  • Client
  • Trading partner's business area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TGSB.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T880.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.PARTNERCOMPANY == T880.RCOMP
Partner Unit
  • Partner Unit
  • Client
  • Dimension
  • I_MATRIXCNSLDTNFNDNPERIODIC.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF160.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONSOLIDATIONDIMENSION == TF160.DIMEN
Sender cost center
  • Client
  • Sender cost center
  • ?
  • Controlling Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == CSKS.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_MATRIXCNSLDTNFNDNPERIODIC.[column in domain "DATBI"] == CSKS.DATBI
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONTROLLINGAREA == CSKS.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TFKB.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Client
  • Partner Profit Center
  • ?
  • Controlling Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == CEPC.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_MATRIXCNSLDTNFNDNPERIODIC.[column in domain "DATBI"] == CEPC.DATBI
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_MATRIXCNSLDTNFNDNPERIODIC.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T001W.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.PLANT == T001W.WERKS
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • I_MATRIXCNSLDTNFNDNPERIODIC.PROFITCENTER == CEPC.PRCTR
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == CEPC.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.[column in domain "DATBI"] == CEPC.DATBI
  • I_MATRIXCNSLDTNFNDNPERIODIC.CONTROLLINGAREA == CEPC.KOKRS
Sales District
  • Client
  • Sales District
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T171.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TVKO.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == FAGL_SEGM.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Ship-to Party
  • Client
  • I_MATRIXCNSLDTNFNDNPERIODIC.SHIPTOPARTY == KNA1.KUNNR
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == KNA1.MANDT
Product Sold
  • Client
  • Product Sold
  • Product Sold
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == MARA.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SOLDMATERIAL == MARA.MATNR
  • I_MATRIXCNSLDTNFNDNPERIODIC.SOLDPRODUCT == MARA.MATNR
Product Sold
  • Client
  • Product Sold
  • Product Sold
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == MARA.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SOLDMATERIAL == MARA.MATNR
  • I_MATRIXCNSLDTNFNDNPERIODIC.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == T023.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SOLDPRODUCTGROUP == T023.MATKL
Subitem
  • Client
  • Subitem Category
  • Subitem
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF115.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SUBITEMCATEGORY == TF115.SITYP
  • I_MATRIXCNSLDTNFNDNPERIODIC.SUBITEM == TF115.SITEM
Subitem Category
  • Client
  • Subitem Category
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TF110.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SUBITEMCATEGORY == TF110.SITYP
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == LFA1.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.SUPPLIER == LFA1.LIFNR
Currency Key
  • Client
  • Currency Key
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == TCURC.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.TRANSACTIONCURRENCY == TCURC.WAERS
User Name
  • Client
  • User Name
  • I_MATRIXCNSLDTNFNDNPERIODIC.MANDT == USR02.MANDT
  • I_MATRIXCNSLDTNFNDNPERIODIC.USERID == USR02.BNAME
Other Relations | to Master Data Relations ↑ Join Conditions
Origin Type I_MATRIXCNSLDTNFNDNPERIODIC.ORIGINTYPE == FINCS_ORIGTYPE.ORIG_TYPE