C_CnsldtdTotals11Q

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