P_CnsldtnUnitHierarchyVH

DDL: P_CNSLDTNUNITHIERARCHYVH Type: view_entity COMPOSITE Package: FIN_CS_MD_UNIT
4 Fields

Consolidation Unit Hierarchy

P_CnsldtnUnitHierarchyVH is a Composite CDS View that provides data about "Consolidation Unit Hierarchy" in SAP S/4HANA. Part of development package FIN_CS_MD_UNIT.

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationUnitHierarchy
KEY ValidityEndDate _Source ValidityEndDate ValidTo
ValidityStartDate _Source ValidityStartDate Validity Start Date
ConsolidationUnitHierarchyText

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 P_CnsldtnUnitHierarchyVH.
-- 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 P_CnsldtnUnitHierarchyVH AS
SELECT
  cast ( _Source.ConsolidationUnitHierarchy as fincs_consolidationunithier ) AS ConsolidationUnitHierarchy,
  _Source.ValidityEndDate AS ValidityEndDate,
  _Source.ValidityStartDate AS ValidityStartDate,
  cast ( _Source._Text[1: Language=$session.system_language].ConsolidationUnitHierarchyText as fincs_hierarchytext preserving type ) AS ConsolidationUnitHierarchyText
;

Learn More