C_CnsldtnGroupStructureTP

DDL: C_CNSLDTNGROUPSTRUCTURETP Type: view_entity CONSUMPTION Package: FIN_CS_MD_GROUPSTRUCTURE
10 Fields 1 Data Sources 4 OData Services 2 Fiori Apps

Consolidation Group Structure - TP

C_CnsldtnGroupStructureTP is a Consumption CDS View that provides data about "Consolidation Group Structure - TP" in SAP S/4HANA. It reads from 1 data source (R_CnsldtnGroupStructureTP) and exposes 10 fields with key fields ConsolidationGroup, ConsolidationUnit, ConsolidationVersion, GroupStrucFromFiscalYearPeriod. It is exposed through 4 OData services (ASQL_F3733, ASQL_F3766, ASQL_F8967, ...). It is used in 2 Fiori applications: Manage Consolidation Group Structure - Group View, Manage Consolidation Group Structure - Unit View. Part of development package FIN_CS_MD_GROUPSTRUCTURE.

Data Sources (1)

SourceAliasJoin Type
R_CnsldtnGroupStructureTP R_CnsldtnGroupStructureTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view
EndUserText.label Consolidation Group Structure - TP view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F3733 ASQL_F3733 C2 NOT_RELEASED
ASQL_F3766 ASQL_F3766 C2 NOT_RELEASED
ASQL_F8967 ASQL_F8967 C2 NOT_RELEASED
UI_FINCS_GRPSTR_MANAGE UI_FINCS_GRPSTR_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F3733 Manage Consolidation Group Structure - Group View Transactional An application to manage assignments of consolidation units to a consolidation group, including maintenance of consolidation group specific settings of consolidation units (such as period of first consolidation, period of divestiture, consolidation method).
F3766 Manage Consolidation Group Structure - Unit View Transactional An application to manage assignments of a consolidation unit to one or several consolidation groups, including maintenance of consolidation group specific settings of the consolidation unit (such as period of first consolidation, period of divestiture, consolidation method).

Manage Consolidation Group Structure - Group View

Business Role: Administrator - Group Reporting

With this app, you manage the assignments of consolidation units to consolidation groups and make consolidation relevant settings for these assignments, such as the period of the first consolidation, the period of the divestiture, and the consolidation method.

Manage Consolidation Group Structure - Unit View

Business Role: Administrator - Group Reporting

With this app, you manage the assignments of consolidation units to consolidation groups and make consolidation relevant settings for these assignments, such as the period of the first consolidation, the period of the divestiture, and the consolidation method.

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationGroup _Source ConsolidationGroup Cons. Group
KEY ConsolidationUnit _Source ConsolidationUnit Consolidation Unit
KEY ConsolidationVersion _Source ConsolidationVersion Version
KEY GroupStrucFromFiscalYearPeriod _Source GroupStrucFromFiscalYearPeriod
GroupStrucToFiscalYearPeriod _Source GroupStrucToFiscalYearPeriod
FirstCnsldtnFiscalYearPeriod _Source FirstCnsldtnFiscalYearPeriod
FirstCnsldtnIsAtEndOfPeriod _Source FirstCnsldtnIsAtEndOfPeriod
DivestitureFiscalYearPeriod _Source DivestitureFiscalYearPeriod
DivestitureIsAtBeginOfPeriod _Source DivestitureIsAtBeginOfPeriod
DivestitureIsDueToMerger _Source DivestitureIsDueToMerger

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_CnsldtnGroupStructureTP.
-- 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_CnsldtnGroupStructureTP AS
SELECT
  _Source.ConsolidationGroup AS ConsolidationGroup,
  _Source.ConsolidationUnit AS ConsolidationUnit,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  _Source.GroupStrucFromFiscalYearPeriod AS GroupStrucFromFiscalYearPeriod,
  _Source.GroupStrucToFiscalYearPeriod AS GroupStrucToFiscalYearPeriod,
  _Source.FirstCnsldtnFiscalYearPeriod AS FirstCnsldtnFiscalYearPeriod,
  _Source.FirstCnsldtnIsAtEndOfPeriod AS FirstCnsldtnIsAtEndOfPeriod,
  _Source.DivestitureFiscalYearPeriod AS DivestitureFiscalYearPeriod,
  _Source.DivestitureIsAtBeginOfPeriod AS DivestitureIsAtBeginOfPeriod,
  _Source.DivestitureIsDueToMerger AS DivestitureIsDueToMerger
FROM R_CnsldtnGroupStructureTP
;

Learn More