P_EntProjSDM2522

DDL: P_ENTPROJSDM2522 Type: view_entity COMPOSITE Package: PPM_OBJECTS_MIGRATION_COMM
8 Fields 5 Data Sources

SDM: Private CDS View

P_EntProjSDM2522 is a Composite CDS View that provides data about "SDM: Private CDS View" in SAP S/4HANA. It reads from 5 data sources (R_AccessControlList, I_EnterpriseProject, I_EnterpriseProjectRole, I_EnterpriseProjectTeamMember, I_User) and exposes 8 fields with key field ProjectUUID. Part of development package PPM_OBJECTS_MIGRATION_COMM.

Data Sources (5)

SourceAliasJoin Type
R_AccessControlList acf left_outer
I_EnterpriseProject project inner
I_EnterpriseProjectRole role inner
I_EnterpriseProjectTeamMember teammbr inner
I_User user inner

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID entitlement ProjectUUID Project UUID
ProjectInternalID I_EnterpriseProject ProjectInternalID Project Def.
Project I_EnterpriseProject Project WBS Element
RoleUUID entitlement ProjectRoleUUID Role
RoleType
UserID I_User UserID User Name
ACFReferencedObjectUUID R_AccessControlList AccCtrlReferencedObjectUUID Root Key UUID
ProjectUUIDthen01else00endasSDMVersion

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_EntProjSDM2522.
-- 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_EntProjSDM2522 AS
SELECT
  entitlement.ProjectUUID AS ProjectUUID,
  project.ProjectInternalID AS ProjectInternalID,
  project.Project AS Project,
  entitlement.ProjectRoleUUID AS RoleUUID,
  role. ProjectRoleType AS RoleType,
  user.UserID AS UserID,
  acf.AccCtrlReferencedObjectUUID AS ACFReferencedObjectUUID,
  case when acf.AccCtrlReferencedObjectUUID = entitlement.ProjectUUID then '01' else '00' end as SDMVersion AS ProjectUUIDthen01else00endasSDMVersion
INNER JOIN I_EnterpriseProject AS project ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_AccessControlList AS acf ON /* join condition not captured in parsed metadata */
INNER JOIN I_EnterpriseProjectRole AS role ON /* join condition not captured in parsed metadata */
INNER JOIN I_EnterpriseProjectTeamMember AS teammbr ON /* join condition not captured in parsed metadata */
INNER JOIN I_User AS user ON /* join condition not captured in parsed metadata */
;

Learn More