C_ConsolidationMatrixRpt10Q

Local/Group Data Analysis Query | view: CCSMATRIXRPT10Q | Extraction: Not supported | Component: Embedded Analytics
Column Name Description
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
CnsldtnSignAdjdAmtInTransCrcy Sign-Adjusted Amount in Transaction Currency
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency Amount in Local Currency
CnsldtnSignAdjdAmtInLocalCrcy Sign-Adjusted Amount in Local Currency
💲 Group Currency (GroupCurrency):
AmountInGroupCurrency Value in Group Currency
CnsldtnSignAdjdAmtInGroupCrcy Sign-Adjusted Amount in Group Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity
CnsldtnQuantityInBaseUnit Quantity
CnsldtnSignAdjdQtyInBaseUnit Sign-Adjusted 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
PeriodMode Period Mode Show values
PostingLevel Posting Level Show values
CurrencyConversionsDiffType Currency Translation Show values
GLRecordType Record Type Show values
DebitCreditCode Debit/Credit Indicator Show values
ConsolidationApportionment Apportionment Show values
RefConsolidationDocumentType Document Category Show values
InvestmentActivityType Consolidation of Investments Activity Show values
Column Name Description Domain name
ConsolidationVersion Consolidation Version FC_RVERS
ConsolidationVersionElement Consolidation Version FC_RVERS
FiscalYear Fiscal Year GJAHR
FiscalPeriod Reporting Period POPER
FiscalYearPeriod Fiscal Year Period JAHRPER
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
FinancialStatementItem Financial Statement Item FC_ITEM
ConsolidationGroup Consolidation Group FC_CONGR
ConsolidationUnit Consolidation Unit FC_BUNIT
ConsolidationUnitForElim Consolidation Unit for Elimination FINCS_ELIMINATION_MEMBER
ProfitCenter Profit Center PRCTR
ConsolidationPrftCtrForElim Profit Center for Elimination FINCS_ELIMINATION_MEMBER
Segment Segment for Segmental Reporting FB_SEGMENT
ConsolidationSegmentForElim Segment for Elimination FINCS_ELIMINATION_MEMBER
ConsolidationLedger Ledger RLDNR
SubItemCategory Subitem Category FC_SITYP
SubItem Subitem FC_SITEM
ConsolidationDocumentType Document Type FC_DOCTY
PartnerConsolidationUnit Partner Unit FC_BUNIT
PartnerProfitCenter Partner Profit Center PRCTR
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
ControllingArea Controlling Area CACCD
CostCenter Cost Center KOSTL
FinancialTransactionType Transaction type RMVCT
FunctionalArea Functional Area FKBER
ConsolidationDocumentNumber Group Journal Entry BELNR
ConsolidationPostingItem Group Journal Entry Item DOCLN6
FiscalYearVariant Fiscal Year Variant PERIV
Company Company RCOMP
CompanyCode Original company code BUKRS
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 Original Fiscal Year GJAHR
RefConsolidationPostingItem Six-figure number of line item BUZEI6
RefBusinessTransactionType Business Transaction CHAR4
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
ChartOfAccounts Chart of Accounts KTOPL
GLAccount Account Number SAKNR
AssignmentReference Assignment number ZUONR
BusinessArea Business Area GSBER
PartnerCostCenter Sender cost center KOSTL
PartnerFunctionalArea Partner Functional Area FKBER
PartnerBusinessArea Trading partner's business area GSBER
PartnerCompany Company ID of Trading Partner RCOMP
OrderID Order Number AUFNR
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
Material Material Number MATNR
Plant Plant WERKS
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
MaterialGroup Material Group MATKL
SoldProduct Product Sold MATNR
SoldProductGroup Product Sold Group MATKL
CustomerGroup Customer Group KDGRP
CustomerSupplierCountry Country/Region Key LAND1
CustomerSupplierIndustry Industry key BRSCH
SalesDistrict Sales District BZIRK
BillToParty Bill-to Party KUNNR
ShipToParty Ship-to Party KUNNR
CustomerSupplierCorporateGroup Group key KONZS
CnsldtnAdhocItem Ad Hoc Item FINCS_ADHOCITEM
CnsldtnAdhocSet Ad Hoc Set FINCS_ADHOCSET
CnsldtnAdhocSetItem Ad Hoc Set Item FINCS_ADHOCSETITEM
ConsolidationDimension Dimension FC_DIMEN
MatchingReasonCode Reason Code ICA_RCODE
OriginType Origin Type FINCS_ORIG_TYPE
OriginReference Origin Reference FINCS_ORIG_REF
CnsldtnGroupJrnlEntryBundle Document Bundle Number FINCS_BUNNR
FinancialStatementItemHier null
ConsolidationUnitHierarchy null
ConsolidationSegmentHierarchy null
ConsolidationPrftCtrHierarchy null