P_MatrixCnsldtnFoundation

Matrix Consolidation Foundation | view: PMCFNDN | Extraction: Not supported | Component: Embedded Analytics
Tables used: SCAL_TT_YEAR, ACDOCU, FINCS_REF_VERS_R, ACDOCA, ACDOCP, RTC_PULL_REQ, TF500, FINCS_FSITEM, FINCS_GRPSTR, TF110, TF160, TF162, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, HRRP_NODE, T881, TF165, TF168, TF103A, TF001, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, TFIN010
Column Name Description
ConsolidationLedger Ledger
ConsolidationDimension Dimension
FiscalYear Fiscal Year
ConsolidationDocumentNumber Document Number of an Accounting Document
ConsolidationPostingItem Six-Character Posting Item for Ledger
ConsolidationGroup Consolidation Group
FiscalPeriod Reporting Period
PeriodMode Period Mode Show values
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Value in Transaction Currency
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency Value in Local Currency
💲 Currency key of the ledger currency (GroupCurrency):
AmountInGroupCurrency Value in Group Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit 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
DocumentCategory Document Category 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
CnsldtnJrnlEntryItemOrigin Consolidation Journal Entry Item Origin Show values
Column Name Description Domain name
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
FiscalYearVariant Fiscal Year Variant PERIV
PostingFiscalPeriod Posting period POPER
ConsolidationVersionElement Version RVERS
ConsolidationVersion Consolidation Version FC_RVERS
ConsolidationDocumentType Document Type FC_DOCTY
Company Company RCOMP
ConsolidationUnit Consolidation Unit FC_BUNIT
ConsolidationUnitForElim Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
FinancialStatementItem Financial Statement Item FC_ITEM
PartnerConsolidationUnit Partner Unit FC_BUNIT
CompanyCode Original company code BUKRS
SubItemCategory Subitem Category FC_SITYP
SubItem Subitem FC_SITEM
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
InvesteeConsolidationUnit Investee Unit FC_BUNIT
DocumentItemText Item Text TEXT50
ConsolidationPostgItemAutoFlag Indicator: Automatic posting lines TEXT1
BusinessTransactionType Business Transaction CHAR4
RefConsolidationDocumentNumber Document Number of an Accounting Document BELNR
ReferenceFiscalYear Fiscal Year GJAHR
RefConsolidationPostingItem Six-figure number of line item BUZEI6
RefBusinessTransactionType Business Transaction CHAR4
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
UserID User Name XUBNAME
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
GLAccount Account Number SAKNR
AssignmentReference Assignment number ZUONR
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
ConsolidationPrftCtrForElim Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
FunctionalArea Functional Area FKBER
BusinessArea Business Area GSBER
Segment Segment for Segmental Reporting FB_SEGMENT
ConsolidationSegmentForElim Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
FinancialTransactionType Transaction type RMVCT
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
CustomerSupplierCorporateGroup Group key KONZS
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number FIS_RSPM_TSN
FinancialPlanningDataPacket Financial Planning Data Packet Number NUM6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
Ledger Ledger in General Ledger Accounting FINS_LEDGER
CnsldtnAdhocItem Ad Hoc Item FINCS_ADHOCITEM
CnsldtnAdhocSet Ad Hoc Set FINCS_ADHOCSET
CnsldtnAdhocSetItem Ad Hoc Set Item FINCS_ADHOCSETITEM
MatchingReasonCode Reason Code ICA_RCODE
OriginType Origin Type FINCS_ORIG_TYPE
OriginReference Origin Reference FINCS_ORIG_REF
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.BILLTOPARTY == KNA1.KUNNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == KNA1.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.CHARTOFACCOUNTS == T004.KTOPL
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T004.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.CONTROLLINGAREA == TKA01.KOKRS
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == TKA01.MANDT
Customer Number
  • Customer Number
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.CUSTOMER == KNA1.KUNNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.CUSTOMERGROUP == T151.KDGRP
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T151.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == TVTW.MANDT
Material Number
  • Material Number
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.MATERIAL == MARA.MATNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.MATERIALGROUP == T023.MATKL
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T023.MANDT
Order Number
  • Order Number
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.ORDERID == AUFK.AUFNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.ORGANIZATIONDIVISION == TSPA.SPART
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == TSPA.MANDT
Trading partner's business area
  • Client
  • Trading partner's business area
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == TGSB.MANDT
  • P_MATRIXCNSLDTNFOUNDATION.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.PARTNERCOMPANY == T880.RCOMP
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T880.MANDT
Sender cost center
  • ?
  • Controlling Area
  • Sender cost center
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.[column in domain "DATBI"] == CSKS.DATBI
  • P_MATRIXCNSLDTNFOUNDATION.CONTROLLINGAREA == CSKS.KOKRS
  • P_MATRIXCNSLDTNFOUNDATION.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == CSKS.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == TFKB.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.[column in domain "DATBI"] == CEPC.DATBI
  • P_MATRIXCNSLDTNFOUNDATION.CONTROLLINGAREA == CEPC.KOKRS
  • P_MATRIXCNSLDTNFOUNDATION.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.PLANT == T001W.WERKS
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T001W.MANDT
Sales District
  • Sales District
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.SALESDISTRICT == T171.BZIRK
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == TVKO.MANDT
  • P_MATRIXCNSLDTNFOUNDATION.SALESORGANIZATION == TVKO.VKORG
Ship-to Party
  • Ship-to Party
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.SHIPTOPARTY == KNA1.KUNNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Product Sold
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.SOLDMATERIAL == MARA.MATNR
  • P_MATRIXCNSLDTNFOUNDATION.SOLDPRODUCT == MARA.MATNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Product Sold
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.SOLDMATERIAL == MARA.MATNR
  • P_MATRIXCNSLDTNFOUNDATION.SOLDPRODUCT == MARA.MATNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.SOLDPRODUCTGROUP == T023.MATKL
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == T023.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_MATRIXCNSLDTNFOUNDATION.SUPPLIER == LFA1.LIFNR
  • P_MATRIXCNSLDTNFOUNDATION.MANDT == LFA1.MANDT