C_ConsolidationGroupRpt90Q

Query for Data Visualization | view: CCSBSPLRPT90Q | Extraction: Not supported | Component: Embedded Analytics
Tables used: ACDOCU
Column Name Description
Column Name Description
💲 Currency key of the ledger currency (GroupCurrency):
YearToDateAmountInGrpCrcy Cumulative Value in Group Currency
Column Name Description
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
Column Name Description Domain name
ConsolidationChartOfAccounts null
FiscalYear Fiscal Year
FiscalPeriod Posting period
ConsolidationDocumentNumber Document Number of an Accounting Document
ConsolidationPostingItem Six-Character Posting Item for Ledger
DebitCreditCode Debit/Credit Indicator
PostingLevel Posting Level
ConsolidationApportionment Apportionment
CurrencyConversionsDiffType Currency Translation
ConsolidationAcquisitionYear Year of Acquisition
ConsolidationAcquisitionPeriod Period of Acquisition
DocumentItemText Item Text
ConsolidationPostgItemAutoFlag Indicator: Automatic posting lines
BusinessTransactionType Business Transaction
RefConsolidationDocumentNumber Document Number of an Accounting Document
ReferenceFiscalYear Original Fiscal Year
RefConsolidationPostingItem Six-figure number of line item
RefConsolidationDocumentType Document Category
RefBusinessTransactionType Business Transaction
ReverseDocument Reverse Document Number
ReversedDocument Number of Reversed Document
InvestmentActivityType Consolidation of Investments Activity
InvestmentActivity Consolidation of Investments Activity Number
ConsolidationDocReversalYear Year of reversal document or reversed document
ReferenceDocumentType Reference procedure
ReferenceDocumentContext Reference Organizational Units
LogicalSystem Logical system
AssignmentReference Assignment number
WBSElement Work Breakdown Structure Element (WBS Element)
Project Project definition
ConsolidationRecordNumber Record number of the line item record
CustomerSupplierCorporateGroup Group key
FinancialStatementItemHier null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.BASEUNIT == T006.MSEHI
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.BILLTOPARTY == KNA1.KUNNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.BUSINESSAREA == TGSB.GSBER
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.CHARTOFACCOUNTS == T004.KTOPL
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T004.MANDT
Company
  • Company
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.COMPANY == T880.RCOMP
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T880.MANDT
Original company code
  • Client
  • Original company code
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T001.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.COMPANYCODE == T001.BUKRS
Dimension
  • Client
  • Dimension
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF150.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONDIMENSION == TF150.DIMEN
Document Type
  • Document Type
  • Client
  • Dimension
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF500.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONDIMENSION == TF500.DIMEN
Consolidation Group
  • Client
  • Consolidation Group
  • Dimension
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF180.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONGROUP == TF180.CONGR
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONDIMENSION == TF180.DIMEN
Ledger
  • Client
  • Ledger
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T881.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONLEDGER == T881.RLDNR
Consolidation Unit
  • Consolidation Unit
  • Client
  • Dimension
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONUNIT == TF160.BUNIT
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF160.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONDIMENSION == TF160.DIMEN
Consolidation Version
  • Consolidation Version
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONVERSION == TF200.RVERS
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF200.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.CONTROLLINGAREA == TKA01.KOKRS
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.COSTCENTER == CSKS.KOSTL
  • C_CONSOLIDATIONGROUPRPT90Q.[column in domain "DATBI"] == CSKS.DATBI
  • C_CONSOLIDATIONGROUPRPT90Q.CONTROLLINGAREA == CSKS.KOKRS
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.CUSTOMER == KNA1.KUNNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.CUSTOMERGROUP == T151.KDGRP
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T151.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TVTW.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Financial Statement Item
  • ?
  • Client
  • Financial Statement Item
  • C_CONSOLIDATIONGROUPRPT90Q.[column in domain "FC_ITCLG"] == TF100.ITCLG
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF100.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.FINANCIALSTATEMENTITEM == TF100.ITEM
Transaction type
  • Client
  • Transaction type
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T856.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Functional Area
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.FUNCTIONALAREA == TFKB.FKBER
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TFKB.MANDT
Account Number
  • Account Number
  • Client
  • Original company code
  • C_CONSOLIDATIONGROUPRPT90Q.GLACCOUNT == SKB1.SAKNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == SKB1.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.COMPANYCODE == SKB1.BUKRS
Investee Unit
  • Investee Unit
  • Client
  • Dimension
  • C_CONSOLIDATIONGROUPRPT90Q.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF160.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONDIMENSION == TF160.DIMEN
Material Number
  • Material Number
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.MATERIAL == MARA.MATNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.MATERIALGROUP == T023.MATKL
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T023.MANDT
Order Number
  • Order Number
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.ORDERID == AUFK.AUFNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.ORGANIZATIONDIVISION == TSPA.SPART
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TSPA.MANDT
Trading partner's business area
  • Client
  • Trading partner's business area
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TGSB.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.PARTNERCOMPANY == T880.RCOMP
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T880.MANDT
Partner Unit
  • Partner Unit
  • Client
  • Dimension
  • C_CONSOLIDATIONGROUPRPT90Q.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF160.MANDT
  • C_CONSOLIDATIONGROUPRPT90Q.CONSOLIDATIONDIMENSION == TF160.DIMEN
Sender cost center
  • ?
  • Controlling Area
  • Sender cost center
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.[column in domain "DATBI"] == CSKS.DATBI
  • C_CONSOLIDATIONGROUPRPT90Q.CONTROLLINGAREA == CSKS.KOKRS
  • C_CONSOLIDATIONGROUPRPT90Q.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == CSKS.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TFKB.MANDT
Partner Profit Center
  • Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_CONSOLIDATIONGROUPRPT90Q.[column in domain "DATBI"] == CEPC.DATBI
  • C_CONSOLIDATIONGROUPRPT90Q.CONTROLLINGAREA == CEPC.KOKRS
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.PLANT == T001W.WERKS
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T001W.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.[column in domain "DATBI"] == CEPC.DATBI
  • C_CONSOLIDATIONGROUPRPT90Q.CONTROLLINGAREA == CEPC.KOKRS
  • C_CONSOLIDATIONGROUPRPT90Q.PROFITCENTER == CEPC.PRCTR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SALESDISTRICT == T171.BZIRK
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SALESORGANIZATION == TVKO.VKORG
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SEGMENT == FAGL_SEGM.SEGMENT
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SHIPTOPARTY == KNA1.KUNNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SOLDPRODUCT == MARA.MATNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SOLDPRODUCTGROUP == T023.MATKL
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == T023.MANDT
Subitem
  • Subitem
  • Subitem Category
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SUBITEM == TF115.SITEM
  • C_CONSOLIDATIONGROUPRPT90Q.SUBITEMCATEGORY == TF115.SITYP
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF115.MANDT
Subitem Category
  • Subitem Category
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SUBITEMCATEGORY == TF110.SITYP
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TF110.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.SUPPLIER == LFA1.LIFNR
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == LFA1.MANDT
Currency Key
  • Currency Key
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == TCURC.MANDT
User Name
  • User Name
  • Client
  • C_CONSOLIDATIONGROUPRPT90Q.USERID == USR02.BNAME
  • C_CONSOLIDATIONGROUPRPT90Q.MANDT == USR02.MANDT