C_CnsldtnGrpActlComprn20Q

Actual & Budget Comparison – Periodic GC Value | view: CCGAC20Q | Extraction: Not supported | Component: Embedded Analytics
Tables used: ACDOCUACDOCUACDOCUACDOCU
Column Name Description
Column Name Description
💲 Currency key of the ledger currency (GroupCurrency):
ActualYTDAmountInGroupCrcy1 Cumulative Value in Group Currency
ActualYTDAmountInGroupCrcy2 Cumulative Value in Group Currency
BudgetYTDAmountInGrpCurrency1 Cumulative Value in Group Currency
BudgetYTDAmountInGrpCurrency2 Cumulative Value in Group Currency
BdgtExchRateAmtInGrpCurrency1 Cumulative Value in Group Currency
BdgtExchRateAmtInGrpCurrency2 Cumulative Value in Group Currency
Column Name Description
Column Name Description
Column Name Description
PostingLevel Posting Level Show values
CurrencyConversionsDiffType Currency Translation Show values
Column Name Description Domain name
ActualAmountInGroupCrcy null
BudgetAmountInGroupCurrency null
BdgtExchRateAmtInGroupCurrency null
OverAllVarianceAmountInGrpCrcy null
OverAllVarianceRate null
ExchRateDrivenVarcAmtInGrpCrcy null
ExchangeRateDrivenVarianceRate null
OperationalVarcAmtInGrpCrcy null
OperationalVarianceRate null
FiscalYear null
FiscalPeriod null
PreviousPeriodBackShift1 null
ConsolidationVersion null
ConsolidationChartOfAccounts null
FinancialStatementItemHier null
Master Data Relations Join Conditions
Dimension
  • Dimension
  • Client
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF150.MANDT
Document Type
  • Dimension
  • Document Type
  • Client
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONDIMENSION == TF500.DIMEN
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF500.MANDT
Consolidation Group
  • Dimension
  • Client
  • Consolidation Group
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONDIMENSION == TF180.DIMEN
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF180.MANDT
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONGROUP == TF180.CONGR
Consolidation Unit
  • Dimension
  • Consolidation Unit
  • Client
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONUNIT == TF160.BUNIT
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF160.MANDT
Financial Statement Item
  • ?
  • Client
  • Financial Statement Item
  • C_CNSLDTNGRPACTLCOMPRN20Q.[column in domain "FC_ITCLG"] == TF100.ITCLG
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF100.MANDT
  • C_CNSLDTNGRPACTLCOMPRN20Q.FINANCIALSTATEMENTITEM == TF100.ITEM
Partner Unit
  • Dimension
  • Partner Unit
  • Client
  • C_CNSLDTNGRPACTLCOMPRN20Q.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • C_CNSLDTNGRPACTLCOMPRN20Q.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF160.MANDT
Subitem
  • Subitem
  • Subitem Category
  • Client
  • C_CNSLDTNGRPACTLCOMPRN20Q.SUBITEM == TF115.SITEM
  • C_CNSLDTNGRPACTLCOMPRN20Q.SUBITEMCATEGORY == TF115.SITYP
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF115.MANDT
Subitem Category
  • Subitem Category
  • Client
  • C_CNSLDTNGRPACTLCOMPRN20Q.SUBITEMCATEGORY == TF110.SITYP
  • C_CNSLDTNGRPACTLCOMPRN20Q.MANDT == TF110.MANDT