C_CnsldtnGrpFcstComprn20Q

DDL: C_CNSLDTNGRPFCSTCOMPRN20Q SQL: CCGFC20Q Type: view CONSUMPTION
21 Fields 1 Data Sources 1 Associations

Forecast Variance – Periodic GC Value

C_CnsldtnGrpFcstComprn20Q (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Group Reporting

C_CnsldtnGrpFcstComprn20Q is a Consumption CDS View that provides data about "Forecast Variance – Periodic GC Value" in SAP S/4HANA. It reads from 1 data source (I_ConsolidationGroupReportC) and exposes 21 fields. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryQuery
Corresponding DataSourceCCGFC20Q
Purpose
To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Parameters The parameters of the CDS view are as follows: P_FinancialStatementItem (Financial Statement Item) P_Consolidationledger (Consolidation Ledger) P_ConsolidationChartOfAccounts (Consolidation Chart of Accounts) P_FiscalYear (Fiscal Year) P_FiscalPeriod (Fiscal Period) P_PreviouslPeriod (Previous Period) P_ConsolidationVersion (Consolidation Version) P_ConsolidationVersionVariant1 (Consolidation Version Variant 1) P_ConsolidationVersionVariant2 (Consolidation Version Variant 2) P_ConsolidationGroup (Consolidation Group) Fields Used for Filtering The main filters are as follows: None of the following fields is mandatory: FinancialStatementItem (Financial Statement Item) ConsolidationDimension (Consolidation Dimension) ConsolidationUnit (Consolidation Unit) SubItemCategory (Sub Item Category) SubItem (Sub Item) PartnerConsolidationUnit (Partner Consolidation Unit) PostingLevel (Posting Level) CurrencyConversionsDiffType (Currency Conversions Difference Type) ConsolidationDocumentType (Consolidation Document Type) Further Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute OverAllVarianceAmountInGrpCrcy Overall Variance Attribute AmtInCnsldtnYrFcstGrpCrcy Annual Forecast Measure AmtInCnsldtnYrBdgtGrpCrcy Annual Budget Measure AnnualBasedVarcAmtInGrpCrcy Annual Variance Attribute GroupCurrency Group Currency Measure ActualYTDAmountInGroupCrcy1 Actuals-Current Period YTD Measure ActualYTDAmountInGroupCrcy2 Actuals-Previous Period YTD Measure ActualAmountInGroupCrcy Actuals Attribute BudgetYTDAmountInGrpCurrency1 Budget-Current Period Measure BudgetYTDAmountInGrpCurrency2 Budget-Previous Period Measure BudgetAmountInGroupCurrency Budget Attribute

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-EA
CapabilitiesAnalytical Query
PackageGroup Reporting for SAP S/4HANA Cloud Private Edition
Description <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ConsolidationGroupReportC I_ConsolidationGroupReportC from

Parameters (10)

NameTypeDefault
P_FinancialStatementItemHier fincs_ithry
P_ConsolidationLedger fincs_rldnr
P_ConsolidationChartOfAccounts fincs_itclg
P_FiscalYear gjahr
P_FiscalPeriod poper
P_PreviousPeriod poper
P_ConsolidationVersion fincs_rvers
P_ConsolidationVersionVariant1 fincs_rvers
P_ConsolidationVersionVariant2 fincs_rvers
P_ConsolidationGroup fincs_congr

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_FinStmntItmHierDir _FinStmntItmHierDir _FinStmntItmHierDir.ConsolidationChartOfAccounts = :P_ConsolidationChartOfAccounts and _FinStmntItmHierDir.FinancialStatementItemHier = :P_FinancialStatementItemHier

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCGFC20Q view
EndUserText.label Forecast Variance – Periodic GC Value view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view

Fields (21)

KeyFieldSource TableSource FieldDescription
selectionTypeHIERARCHY_NODE
multipleSelectionstrue
axisROWS
displayKEY_TEXT
displayHierarchyFILTER
multipleSelectionsfalse
hiddentrue
multipleSelectionstrue
axisFREE
totalsSHOW
displayKEYConsolidationUnit
multipleSelectionstrue
mandatoryfalseSubItemCategory
multipleSelectionstrue
mandatoryfalseSubItem
multipleSelectionstrue
mandatoryfalsePartnerConsolidationUnit
multipleSelectionstrue
mandatoryfalsePostingLevel
multipleSelectionstrue
multipleSelectionstrue

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CnsldtnGrpFcstComprn20Q.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCGFC20Q
-- Parameters: P_FinancialStatementItemHier : fincs_ithry, P_ConsolidationLedger : fincs_rldnr, P_ConsolidationChartOfAccounts : fincs_itclg, P_FiscalYear : gjahr, P_FiscalPeriod : poper, P_PreviousPeriod : poper, P_ConsolidationVersion : fincs_rvers, P_ConsolidationVersionVariant1 : fincs_rvers, P_ConsolidationVersionVariant2 : fincs_rvers, P_ConsolidationGroup : fincs_congr

CREATE VIEW C_CnsldtnGrpFcstComprn20Q AS
SELECT
  selectionType: #HIERARCHY_NODE AS selectionTypeHIERARCHY_NODE,
  multipleSelections: true AS multipleSelectionstrue,
  axis: #ROWS AS axisROWS,
  display: #KEY_TEXT AS displayKEY_TEXT,
  displayHierarchy: #FILTER AS displayHierarchyFILTER,
  multipleSelections: false AS multipleSelectionsfalse,
  hidden:true AS hiddentrue,
  axis: #FREE AS axisFREE,
  totals: #SHOW AS totalsSHOW,
  display: #KEY AS displayKEYConsolidationUnit,
  mandatory: false AS mandatoryfalseSubItemCategory,
  mandatory: false AS mandatoryfalseSubItem,
  mandatory: false AS mandatoryfalsePartnerConsolidationUnit,
  mandatory: false AS mandatoryfalsePostingLevel
FROM I_ConsolidationGroupReportC
LEFT OUTER JOIN I_FinStmntItmHierDir AS _FinStmntItmHierDir ON _FinStmntItmHierDir.ConsolidationChartOfAccounts = :P_ConsolidationChartOfAccounts AND _FinStmntItmHierDir.FinancialStatementItemHier = :P_FinancialStatementItemHier  -- association [1..1]
;

Learn More