C_CnsldtdTotals23Q

Consolidated P&L by Nature - By Subgroups | view: CCSTOTALSRR23Q | Extraction: Not supported | Component: Embedded Analytics

Tables used: ACDOCU, ACDOCU, ACDOCU, ACDOCU

🔑 Keys
💰 Amounts (2)
∑ Quantities
📅 Dates
☰ Categorical (3)
Other (9)
🔗 Relations (41)

Column Name	Description

Column Name	Description
💲 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

Column Name	Description

Column Name	Description
PostingLevel	Posting Level	Show values
CurrencyConversionsDiffType	Currency Translation	Show values
GLRecordType	Record Type	Show values

Column Name	Description	Domain name
FiscalYear	Fiscal Year	GJAHR
FiscalPeriod	Posting period	POPER
AssignmentReference	Assignment number	ZUONR
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
Project	Project definition	PS_PSPID
ConsolidationChartOfAccounts	null
FinancialStatementItemHier	null
ConsolidationLedger	null
ConsolidationDimension	null

Master Data Relations	Join Conditions
Billing Type Client Billing Type	`C_CNSLDTDTOTALS23Q.MANDT == TVFK.MANDT` `C_CNSLDTDTOTALS23Q.BILLINGDOCUMENTTYPE == TVFK.FKART`
Bill-to Party Bill-to Party Client	`C_CNSLDTDTOTALS23Q.BILLTOPARTY == KNA1.KUNNR` `C_CNSLDTDTOTALS23Q.MANDT == KNA1.MANDT`
Business Area Client Business Area	`C_CNSLDTDTOTALS23Q.MANDT == TGSB.MANDT` `C_CNSLDTDTOTALS23Q.BUSINESSAREA == TGSB.GSBER`
Chart of Accounts Client Chart of Accounts	`C_CNSLDTDTOTALS23Q.MANDT == T004.MANDT` `C_CNSLDTDTOTALS23Q.CHARTOFACCOUNTS == T004.KTOPL`
Document Type Document Type Client ?	`C_CNSLDTDTOTALS23Q.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY` `C_CNSLDTDTOTALS23Q.MANDT == TF500.MANDT` `C_CNSLDTDTOTALS23Q.[column in domain "FC_DIMEN"] == TF500.DIMEN`
Consolidation Group Client Consolidation Group ?	`C_CNSLDTDTOTALS23Q.MANDT == TF180.MANDT` `C_CNSLDTDTOTALS23Q.CONSOLIDATIONGROUP == TF180.CONGR` `C_CNSLDTDTOTALS23Q.[column in domain "FC_DIMEN"] == TF180.DIMEN`
Consolidation Unit Client Consolidation Unit ?	`C_CNSLDTDTOTALS23Q.MANDT == TF160.MANDT` `C_CNSLDTDTOTALS23Q.CONSOLIDATIONUNIT == TF160.BUNIT` `C_CNSLDTDTOTALS23Q.[column in domain "FC_DIMEN"] == TF160.DIMEN`
Consolidation Version Client Consolidation Version	`C_CNSLDTDTOTALS23Q.MANDT == TF200.MANDT` `C_CNSLDTDTOTALS23Q.CONSOLIDATIONVERSION == TF200.RVERS`
Controlling Area Client Controlling Area	`C_CNSLDTDTOTALS23Q.MANDT == TKA01.MANDT` `C_CNSLDTDTOTALS23Q.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Client Controlling Area ? Cost Center	`C_CNSLDTDTOTALS23Q.MANDT == CSKS.MANDT` `C_CNSLDTDTOTALS23Q.CONTROLLINGAREA == CSKS.KOKRS` `C_CNSLDTDTOTALS23Q.[column in domain "DATBI"] == CSKS.DATBI` `C_CNSLDTDTOTALS23Q.COSTCENTER == CSKS.KOSTL`
Customer Number Client Customer Number	`C_CNSLDTDTOTALS23Q.MANDT == KNA1.MANDT` `C_CNSLDTDTOTALS23Q.CUSTOMER == KNA1.KUNNR`
Customer Group Client Customer Group	`C_CNSLDTDTOTALS23Q.MANDT == T151.MANDT` `C_CNSLDTDTOTALS23Q.CUSTOMERGROUP == T151.KDGRP`
Country/Region Key Country/Region Key Client	`C_CNSLDTDTOTALS23Q.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `C_CNSLDTDTOTALS23Q.MANDT == T005.MANDT`
Industry key Client Industry key	`C_CNSLDTDTOTALS23Q.MANDT == T016.MANDT` `C_CNSLDTDTOTALS23Q.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Client Distribution Channel	`C_CNSLDTDTOTALS23Q.MANDT == TVTW.MANDT` `C_CNSLDTDTOTALS23Q.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Financial Statement Item Client ? Financial Statement Item	`C_CNSLDTDTOTALS23Q.MANDT == TF100.MANDT` `C_CNSLDTDTOTALS23Q.[column in domain "FC_ITCLG"] == TF100.ITCLG` `C_CNSLDTDTOTALS23Q.FINANCIALSTATEMENTITEM == TF100.ITEM`
Transaction type Client Transaction type	`C_CNSLDTDTOTALS23Q.MANDT == T856.MANDT` `C_CNSLDTDTOTALS23Q.FINANCIALTRANSACTIONTYPE == T856.TRTYP`
Functional Area Client Functional Area	`C_CNSLDTDTOTALS23Q.MANDT == TFKB.MANDT` `C_CNSLDTDTOTALS23Q.FUNCTIONALAREA == TFKB.FKBER`
Account Number Client Account Number ?	`C_CNSLDTDTOTALS23Q.MANDT == SKB1.MANDT` `C_CNSLDTDTOTALS23Q.GLACCOUNT == SKB1.SAKNR` `C_CNSLDTDTOTALS23Q.[column in domain "BUKRS"] == SKB1.BUKRS`
Material Number Client Material Number	`C_CNSLDTDTOTALS23Q.MANDT == MARA.MANDT` `C_CNSLDTDTOTALS23Q.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`C_CNSLDTDTOTALS23Q.MATERIALGROUP == T023.MATKL` `C_CNSLDTDTOTALS23Q.MANDT == T023.MANDT`
Order Number Client Order Number	`C_CNSLDTDTOTALS23Q.MANDT == AUFK.MANDT` `C_CNSLDTDTOTALS23Q.ORDERID == AUFK.AUFNR`
Division Client Division	`C_CNSLDTDTOTALS23Q.MANDT == TSPA.MANDT` `C_CNSLDTDTOTALS23Q.ORGANIZATIONDIVISION == TSPA.SPART`
Trading partner's business area Client Trading partner's business area	`C_CNSLDTDTOTALS23Q.MANDT == TGSB.MANDT` `C_CNSLDTDTOTALS23Q.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Client Company ID of Trading Partner	`C_CNSLDTDTOTALS23Q.MANDT == T880.MANDT` `C_CNSLDTDTOTALS23Q.PARTNERCOMPANY == T880.RCOMP`
Partner Unit Client ? Partner Unit	`C_CNSLDTDTOTALS23Q.MANDT == TF160.MANDT` `C_CNSLDTDTOTALS23Q.[column in domain "FC_DIMEN"] == TF160.DIMEN` `C_CNSLDTDTOTALS23Q.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT`
Sender cost center Client Sender cost center Controlling Area ?	`C_CNSLDTDTOTALS23Q.MANDT == CSKS.MANDT` `C_CNSLDTDTOTALS23Q.PARTNERCOSTCENTER == CSKS.KOSTL` `C_CNSLDTDTOTALS23Q.CONTROLLINGAREA == CSKS.KOKRS` `C_CNSLDTDTOTALS23Q.[column in domain "DATBI"] == CSKS.DATBI`
Partner Functional Area Client Partner Functional Area	`C_CNSLDTDTOTALS23Q.MANDT == TFKB.MANDT` `C_CNSLDTDTOTALS23Q.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Profit Center Client Controlling Area ? Partner Profit Center	`C_CNSLDTDTOTALS23Q.MANDT == CEPC.MANDT` `C_CNSLDTDTOTALS23Q.CONTROLLINGAREA == CEPC.KOKRS` `C_CNSLDTDTOTALS23Q.[column in domain "DATBI"] == CEPC.DATBI` `C_CNSLDTDTOTALS23Q.PARTNERPROFITCENTER == CEPC.PRCTR`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`C_CNSLDTDTOTALS23Q.MANDT == FAGL_SEGM.MANDT` `C_CNSLDTDTOTALS23Q.PARTNERSEGMENT == FAGL_SEGM.SEGMENT`
Plant Client Plant	`C_CNSLDTDTOTALS23Q.MANDT == T001W.MANDT` `C_CNSLDTDTOTALS23Q.PLANT == T001W.WERKS`
Profit Center Client Controlling Area ? Profit Center	`C_CNSLDTDTOTALS23Q.MANDT == CEPC.MANDT` `C_CNSLDTDTOTALS23Q.CONTROLLINGAREA == CEPC.KOKRS` `C_CNSLDTDTOTALS23Q.[column in domain "DATBI"] == CEPC.DATBI` `C_CNSLDTDTOTALS23Q.PROFITCENTER == CEPC.PRCTR`
Sales District Client Sales District	`C_CNSLDTDTOTALS23Q.MANDT == T171.MANDT` `C_CNSLDTDTOTALS23Q.SALESDISTRICT == T171.BZIRK`
Sales Organization Client Sales Organization	`C_CNSLDTDTOTALS23Q.MANDT == TVKO.MANDT` `C_CNSLDTDTOTALS23Q.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`C_CNSLDTDTOTALS23Q.MANDT == FAGL_SEGM.MANDT` `C_CNSLDTDTOTALS23Q.SEGMENT == FAGL_SEGM.SEGMENT`
Ship-to Party Client Ship-to Party	`C_CNSLDTDTOTALS23Q.MANDT == KNA1.MANDT` `C_CNSLDTDTOTALS23Q.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Product Sold Client	`C_CNSLDTDTOTALS23Q.SOLDPRODUCT == MARA.MATNR` `C_CNSLDTDTOTALS23Q.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Client	`C_CNSLDTDTOTALS23Q.SOLDPRODUCTGROUP == T023.MATKL` `C_CNSLDTDTOTALS23Q.MANDT == T023.MANDT`
Subitem Client Subitem Subitem Category	`C_CNSLDTDTOTALS23Q.MANDT == TF115.MANDT` `C_CNSLDTDTOTALS23Q.SUBITEM == TF115.SITEM` `C_CNSLDTDTOTALS23Q.SUBITEMCATEGORY == TF115.SITYP`
Subitem Category Client Subitem Category	`C_CNSLDTDTOTALS23Q.MANDT == TF110.MANDT` `C_CNSLDTDTOTALS23Q.SUBITEMCATEGORY == TF110.SITYP`
Account Number of Supplier Client Account Number of Supplier	`C_CNSLDTDTOTALS23Q.MANDT == LFA1.MANDT` `C_CNSLDTDTOTALS23Q.SUPPLIER == LFA1.LIFNR`