A_CnsldtnProjectHierDir

DDL: A_CNSLDTNPROJECTHIERDIR SQL: ACSPROJECTHDIR Type: view BASIC
7 Fields 1 Data Sources

Combined Project Hierarchy Directory

A_CnsldtnProjectHierDir is a Basic CDS View that provides data about "Combined Project Hierarchy Directory" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnProjectHierDir) and exposes 7 fields with key fields AdditionalMasterDataHierarchy, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnProjectHierDir _Source from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ACSPROJECTHDIR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Combined Project Hierarchy Directory view
VDM.viewType #BASIC view
ObjectModel.representativeKey AdditionalMasterDataHierarchy view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMasterDataHierarchy I_CnsldtnProjectHierDir AdditionalMasterDataHierarchy
KEY ValidityEndDate I_CnsldtnProjectHierDir ValidityEndDate ValidTo
ValidityStartDate I_CnsldtnProjectHierDir ValidityStartDate Validity Start Date
LastChangedByUser I_CnsldtnProjectHierDir LastChangedByUser User Name
LastChangeDateTime I_CnsldtnProjectHierDir LastChangeDateTime Timestamp
MDHierType
HierarchyType

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 A_CnsldtnProjectHierDir.
-- 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: ACSPROJECTHDIR

CREATE VIEW A_CnsldtnProjectHierDir AS
SELECT
  _Source.AdditionalMasterDataHierarchy AS AdditionalMasterDataHierarchy,
  _Source.ValidityEndDate AS ValidityEndDate,
  _Source.ValidityStartDate AS ValidityStartDate,
  _Source.LastChangedByUser AS LastChangedByUser,
  _Source.LastChangeDateTime AS LastChangeDateTime,
  cast ( 'CS10' as hrytype ) AS MDHierType,
  cast ( 'CS10' as hrytype ) AS HierarchyType
FROM I_CnsldtnProjectHierDir AS _Source
;

Learn More