I_MatrixConsolidationReportC

Group Data Analysis - Cube | view: IMCRPTC | TRAN | Extraction: Not supported | Component: Embedded Analytics
Tables used: ACDOCU, FINCS_REF_VERS_R, ACDOCU, FINCS_GRPSTR, TF200, HRRP_NODE, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ConsolidationLedger FK Ledger
ConsolidationDimension FK Dimension
FiscalYear Fiscal Year
ConsolidationDocumentNumber Group Journal Entry
ConsolidationPostingItem Group Journal Entry Item
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 Value 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
KeyDate null
Column Name Description
GLRecordType Record Type Show values
PeriodMode Period Mode 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
ConsolidationVersion Consolidation Version FC_RVERS
FiscalPeriod Reporting Period POPER
FiscalYearPeriod Fiscal Year Period JAHRPER
FiscalYearVariant Fiscal Year Variant PERIV
ConsolidationUnitForElim Consolidation Unit for Elimination FINCS_ELIMINATION_MEMBER
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
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
ConsolidationPrftCtrForElim Profit Center for Elimination FINCS_ELIMINATION_MEMBER
ConsolidationSegmentForElim Segment for Elimination FINCS_ELIMINATION_MEMBER
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
CustomerSupplierCorporateGroup Group key KONZS
OriginReference Origin Reference FINCS_ORIG_REF
CnsldtnGroupJrnlEntryBundle Document Bundle Number FINCS_BUNNR
ConsolidationUnitHierarchy null
ConsolidationSegmentHierarchy null
ConsolidationPrftCtrHierarchy null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T006.MANDT
  • I_MATRIXCONSOLIDATIONREPORTC.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.BILLTOPARTY == KNA1.KUNNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.BUSINESSAREA == TGSB.GSBER
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CHARTOFACCOUNTS == T004.KTOPL
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T004.MANDT
Ad Hoc Item
  • Ad Hoc Item
  • ?
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CNSLDTNADHOCITEM == FINCS_ADHITM.ADHOCITEM
  • I_MATRIXCONSOLIDATIONREPORTC.[column in domain "FC_ITCLG"] == FINCS_ADHITM.ITCLG
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == FINCS_ADHITM.MANDT
Ad Hoc Set
  • ?
  • Ad Hoc Set
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.[column in domain "FC_ITCLG"] == FINCS_ADHSET.ITCLG
  • I_MATRIXCONSOLIDATIONREPORTC.CNSLDTNADHOCSET == FINCS_ADHSET.ADHOCSET
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == FINCS_ADHSET.MANDT
Ad Hoc Set Item
  • Ad Hoc Set Item
  • ?
  • Ad Hoc Set
  • Client
Company
  • Company
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.COMPANY == T880.RCOMP
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T880.MANDT
Original company code
  • Original company code
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.COMPANYCODE == T001.BUKRS
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T001.MANDT
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF120.MANDT
Dimension
  • Dimension
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF150.MANDT
Document Type
  • Document Type
  • Dimension
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONDIMENSION == TF500.DIMEN
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF500.MANDT
Consolidation Group
  • Consolidation Group
  • Dimension
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONGROUP == TF180.CONGR
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONDIMENSION == TF180.DIMEN
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF180.MANDT
Ledger
  • Ledger
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONLEDGER == T881.RLDNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T881.MANDT
Consolidation Unit
  • Dimension
  • Consolidation Unit
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONUNIT == TF160.BUNIT
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF160.MANDT
Consolidation Version
  • Client
  • Consolidation Version
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF200.MANDT
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONVERSIONELEMENT == TF200.RVERS
Controlling Area
  • Controlling Area
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONTROLLINGAREA == TKA01.KOKRS
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Controlling Area
  • ?
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.COSTCENTER == CSKS.KOSTL
  • I_MATRIXCONSOLIDATIONREPORTC.CONTROLLINGAREA == CSKS.KOKRS
  • I_MATRIXCONSOLIDATIONREPORTC.[column in domain "DATBI"] == CSKS.DATBI
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CUSTOMER == KNA1.KUNNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CUSTOMERGROUP == T151.KDGRP
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T151.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TVTW.MANDT
Financial Statement Item
  • Financial Statement Item
  • Consolidation Chart of Accounts
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.FINANCIALSTATEMENTITEM == TF100.ITEM
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF100.MANDT
Transaction type
  • Transaction type
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T856.MANDT
Functional Area
  • Functional Area
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.FUNCTIONALAREA == TFKB.FKBER
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TFKB.MANDT
Account Number
  • Account Number
  • Original company code
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.GLACCOUNT == SKB1.SAKNR
  • I_MATRIXCONSOLIDATIONREPORTC.COMPANYCODE == SKB1.BUKRS
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == SKB1.MANDT
Investee Unit
  • Investee Unit
  • Dimension
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF160.MANDT
Reason Code
  • Reason Code
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.MATCHINGREASONCODE == ICA_RC.RCODE
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == ICA_RC.RCLNT
Material Number
  • Material Number
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.MATERIAL == MARA.MATNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.MATERIALGROUP == T023.MATKL
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T023.MANDT
Order Number
  • Order Number
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.ORDERID == AUFK.AUFNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.ORGANIZATIONDIVISION == TSPA.SPART
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TSPA.MANDT
Trading partner's business area
  • Trading partner's business area
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.PARTNERBUSINESSAREA == TGSB.GSBER
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.PARTNERCOMPANY == T880.RCOMP
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T880.MANDT
Partner Unit
  • Dimension
  • Partner Unit
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • I_MATRIXCONSOLIDATIONREPORTC.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF160.MANDT
Sender cost center
  • Controlling Area
  • ?
  • Client
  • Sender cost center
  • I_MATRIXCONSOLIDATIONREPORTC.CONTROLLINGAREA == CSKS.KOKRS
  • I_MATRIXCONSOLIDATIONREPORTC.[column in domain "DATBI"] == CSKS.DATBI
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == CSKS.MANDT
  • I_MATRIXCONSOLIDATIONREPORTC.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TFKB.MANDT
Partner Profit Center
  • Partner Profit Center
  • Controlling Area
  • ?
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_MATRIXCONSOLIDATIONREPORTC.CONTROLLINGAREA == CEPC.KOKRS
  • I_MATRIXCONSOLIDATIONREPORTC.[column in domain "DATBI"] == CEPC.DATBI
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.PLANT == T001W.WERKS
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T001W.MANDT
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.CONTROLLINGAREA == CEPC.KOKRS
  • I_MATRIXCONSOLIDATIONREPORTC.[column in domain "DATBI"] == CEPC.DATBI
  • I_MATRIXCONSOLIDATIONREPORTC.PROFITCENTER == CEPC.PRCTR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SALESDISTRICT == T171.BZIRK
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SALESORGANIZATION == TVKO.VKORG
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SEGMENT == FAGL_SEGM.SEGMENT
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SHIPTOPARTY == KNA1.KUNNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SOLDPRODUCT == MARA.MATNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SOLDPRODUCTGROUP == T023.MATKL
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == T023.MANDT
Subitem
  • Subitem Category
  • Subitem
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SUBITEMCATEGORY == TF115.SITYP
  • I_MATRIXCONSOLIDATIONREPORTC.SUBITEM == TF115.SITEM
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF115.MANDT
Subitem Category
  • Subitem Category
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SUBITEMCATEGORY == TF110.SITYP
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TF110.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.SUPPLIER == LFA1.LIFNR
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == LFA1.MANDT
Currency Key
  • Currency Key
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == TCURC.MANDT
User Name
  • User Name
  • Client
  • I_MATRIXCONSOLIDATIONREPORTC.USERID == USR02.BNAME
  • I_MATRIXCONSOLIDATIONREPORTC.MANDT == USR02.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Origin Type I_MATRIXCONSOLIDATIONREPORTC.ORIGINTYPE == FINCS_ORIGTYPE.ORIG_TYPE