C_CnsldtnGroupUIParameter

DDL: C_CNSLDTNGROUPUIPARAMETER Type: view_entity CONSUMPTION Package: FIN_CS_MD_GROUP
9 Fields 1 Data Sources 2 Associations 4 OData Services 1 Fiori Apps

Consolidation Group UI Parameter

C_CnsldtnGroupUIParameter is a Consumption CDS View that provides data about "Consolidation Group UI Parameter" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnGlobalParameter) and exposes 9 fields with key field ConsolidationDimension. It has 2 associations to related views. It is exposed through 4 OData services (ASQL_F7959, ASQL_F8339, UI_FINCS_CNSLDTN_POSTING_RULE, ...). It is used in 1 Fiori application: Define Consolidation Groups. Part of development package FIN_CS_MD_GROUP.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnGlobalParameter _Source from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CnsldtnGlobalSetting _CnsldtnGlobalSetting _CnsldtnGlobalSetting.SequenceNumber = '1'
[0..1] I_CnsldtnDimension _CnsldtnDimension $projection.ConsolidationDimension = _CnsldtnDimension.ConsolidationDimension

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view
EndUserText.label Consolidation Group UI Parameter view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F7959 ASQL_F7959 C2 NOT_RELEASED
ASQL_F8339 ASQL_F8339 C2 NOT_RELEASED
UI_FINCS_CNSLDTN_POSTING_RULE UI_FINCS_CNSLDTN_POSTING_RULE V4 C1 NOT_RELEASED
UI_FINCS_CONSGROUP_DEFINE UI_FINCS_CONSGROUP_DEFINE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F7959 Define Consolidation Groups Transactional An application used to create / change / display consolidation groups master data.

Define Consolidation Groups

Business Role: Administrator - Group Reporting

With this new Fiori app, you can maintain consolidation group master data.

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationDimension I_CnsldtnGlobalParameter ConsolidationDimension Dimension
ConsolidationGroup I_CnsldtnGlobalParameter ConsolidationGroup Cons. Group
ConsolidationVersion I_CnsldtnGlobalParameter ConsolidationVersion Version
FiscalYear I_CnsldtnGlobalParameter FiscalYear G/L Fiscal Year
FiscalPeriod I_CnsldtnGlobalParameter FiscalPeriod Tax period
FiscalYearPeriod
CnsldtnGrpMaxNmbrOfCharacters _CnsldtnDimension CnsldtnGrpMaxNmbrOfCharacters
CnsldtnCreateIsAuthorized
CnsldtnDeleteIsAuthorized

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_CnsldtnGroupUIParameter.
-- 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.

CREATE VIEW C_CnsldtnGroupUIParameter AS
SELECT
  _Source.ConsolidationDimension AS ConsolidationDimension,
  _Source.ConsolidationGroup AS ConsolidationGroup,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  _Source.FiscalYear AS FiscalYear,
  _Source.FiscalPeriod AS FiscalPeriod,
  cast( concat( _Source.FiscalYear, _Source.FiscalPeriod) as fins_fyearperiod) AS FiscalYearPeriod,
  _CnsldtnDimension.CnsldtnGrpMaxNmbrOfCharacters AS CnsldtnGrpMaxNmbrOfCharacters,
  cast( '' as fincs_createisauthorized) AS CnsldtnCreateIsAuthorized,
  cast( '' as fincs_deleteisauthorized) AS CnsldtnDeleteIsAuthorized
FROM I_CnsldtnGlobalParameter AS _Source
LEFT OUTER JOIN I_CnsldtnGlobalSetting AS _CnsldtnGlobalSetting ON _CnsldtnGlobalSetting.SequenceNumber = '1'  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDimension AS _CnsldtnDimension ON ConsolidationDimension = _CnsldtnDimension.ConsolidationDimension  -- association [0..1]
;

Learn More