P_EnterpriseProject_F7479

DDL: P_ENTERPRISEPROJECT_F7479 Type: view_entity COMPOSITE Package: FINS_COPA_REPORTING
11 Fields 1 Data Sources 2 Associations

Enterprise Project for App F7479

P_EnterpriseProject_F7479 is a Composite CDS View that provides data about "Enterprise Project for App F7479" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProject) and exposes 11 fields with key field ProjectUUID. It has 2 associations to related views. Part of development package FINS_COPA_REPORTING.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProject EnterpriseProject from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PPM_ProjectManager _PPMProjectManager _PPMProjectManager.ProjectUUID = $projection.ProjectUUID
[0..1] I_BusinessUser _ProjectManager _ProjectManager.BusinessPartnerUUID = $projection.ProjectManagerUUID

Annotations (7)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_EnterpriseProject ProjectUUID Project UUID
Project I_EnterpriseProject Project WBS Element
ProjectInternalID I_EnterpriseProject ProjectInternalID Project Def.
CompanyCode I_EnterpriseProject CompanyCode Receiver Company Code
ProjectProfileCode I_EnterpriseProject ProjectProfileCode Project Profile
AvailabilityControlProfile I_EnterpriseProject AvailabilityControlProfile Budget Availability Control Profile
AvailabilityControlIsActive I_EnterpriseProject AvailabilityControlIsActive Budget Availability Control is Active
ProjectManagerUUID _PPMProjectManager ProjectManagerUUID
ProcessingStatus ProcessingStatus Worklist Status
_PPMProjectManager _PPMProjectManager
_ProjectManager _ProjectManager

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_EnterpriseProject_F7479.
-- 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_EnterpriseProject_F7479 AS
SELECT
  EnterpriseProject.ProjectUUID AS ProjectUUID,
  EnterpriseProject.Project AS Project,
  EnterpriseProject.ProjectInternalID AS ProjectInternalID,
  EnterpriseProject.CompanyCode AS CompanyCode,
  EnterpriseProject.ProjectProfileCode AS ProjectProfileCode,
  EnterpriseProject.AvailabilityControlProfile AS AvailabilityControlProfile,
  EnterpriseProject.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _PPMProjectManager.ProjectManagerUUID AS ProjectManagerUUID,
  ProcessingStatus
FROM I_EnterpriseProject AS EnterpriseProject
LEFT OUTER JOIN I_PPM_ProjectManager AS _PPMProjectManager ON _PPMProjectManager.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUser AS _ProjectManager ON _ProjectManager.BusinessPartnerUUID = ProjectManagerUUID  -- association [0..1]
;

Learn More