I_ProjectByProjMgrVH

DDL: I_PROJECTBYPROJMGRVH SQL: IPPROJVH Type: view COMPOSITE
14 Fields 1 Data Sources 1 Associations

Project Definition Value Help

I_ProjectByProjMgrVH is a Composite CDS View that provides data about "Project Definition Value Help" in SAP S/4HANA. It reads from 1 data source (I_ProjectBasicData) and exposes 14 fields with key field Project. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBasicData _Project from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PPM_ProjectSummaryTask _ProjectSummary _ProjectSummary.ProjectInternalID = $projection.ProjectInternalID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPPROJVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Definition Value Help view
ObjectModel.representativeKey Project view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Project I_ProjectBasicData Project WBS Element
ProjectUUID _ProjectSummary ProjectUUID Project UUID
ProjectDescription I_ProjectBasicData ProjectDescription Project Name
ProjectInternalID ProjectInternalID Project Def.
ProjectObject ProjectObject Object number
ProjectProfileCode ProjectProfileCode Project Profile
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ProjectSummaryTaskUUID _ProjectSummary ProjectSummaryTaskUUID Entity GUID
ProjectCategory _ProjectSummary ProjectCategory Proj. Category
CompanyCode I_ProjectBasicData CompanyCode Receiver Company Code
ProfitCenter I_ProjectBasicData ProfitCenter Profit Center
ControllingArea I_ProjectBasicData ControllingArea Controlling Area
ProjectProcessingStatus _ProjectSummary ProjectProcessingStatus

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 I_ProjectByProjMgrVH.
-- 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: IPPROJVH

CREATE VIEW I_ProjectByProjMgrVH AS
SELECT
  _Project.Project AS Project,
  _ProjectSummary.ProjectUUID AS ProjectUUID,
  _Project.ProjectDescription AS ProjectDescription,
  ProjectInternalID,
  ProjectObject,
  ProjectProfileCode,
  PlannedStartDate,
  PlannedEndDate,
  _ProjectSummary.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _ProjectSummary.ProjectCategory AS ProjectCategory,
  _Project.CompanyCode AS CompanyCode,
  _Project.ProfitCenter AS ProfitCenter,
  _Project.ControllingArea AS ControllingArea,
  _ProjectSummary.ProjectProcessingStatus AS ProjectProcessingStatus
FROM I_ProjectBasicData AS _Project
LEFT OUTER JOIN I_PPM_ProjectSummaryTask AS _ProjectSummary ON _ProjectSummary.ProjectInternalID = ProjectInternalID  -- association [0..1]
;

Learn More