C_CnsldtnTotals12Q

Balance Sheet - Year Comparison | view: CCSTOTALS12Q | Extraction: Not supported | Component: Embedded Analytics

Tables used: ACDOCU, ACDOCU, ACDOCU, ACDOCU

🔑 Keys
💰 Amounts (4)
∑ Quantities
📅 Dates
☰ Categorical (4)
Other (10)
🔗 Relations (41)

Column Name	Description

Column Name	Description
💲 Currency key of the ledger currency (GroupCurrency):
YTDAmtInCnsldtnGroupCrcy	Cumulative Value in Group Currency
YTDAmtInGrpCrcyInPrevYr	Cumulative Value in Group Currency
💲 Currency key of the local currency (LocalCurrency):
YTDAmtInCnsldtnLocalCrcy	Cumulative Value in Local Currency
YTDAmtInLoclCrcyInPrevYr	Cumulative Value in Local Currency

Column Name	Description

Column Name	Description

Column Name	Description
PostingLevel	Posting Level	Show values
ConsolidationReportingLevel	Reporting 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
PreviousFiscalYear	null
ConsolidationChartOfAccounts	null
FinancialStatementItemHier	null
ConsolidationLedger	null
ConsolidationDimension	null

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