I_EnterpriseProjectRole

DDL: I_ENTERPRISEPROJECTROLE Type: view BASIC
12 Fields 1 Data Sources 3 Associations

Enterprise Project Role

I_EnterpriseProjectRole (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

R&D Engineering

I_EnterpriseProjectRole is a Basic CDS View that provides data about "Enterprise Project Role" in SAP S/4HANA. It reads from 1 data source (/s4ppm/role) and exposes 12 fields with key field ProjectRoleUUID. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Enterprise Projects
StatusReleased
Purpose
This CDS view can only be used to retrieve project roles of enterprise projects with the project category 6 ( Enterprise project ) or 7 ( Enterprise project – Professional Services ) in SAP S/4HANA Cloud Public Edition . It is not intended for use in SAP S/4HANA .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPPM-VDM
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view can only be used to retrieve project roles of enterprise projects with the project category 6 (Enterprise project) or 7 (Enterprise project – Professional Services) in SAP S/4HANA Cloud Public Edition. It is not intended for use in SAP S/4HANA.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
/s4ppm/role role from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_EnterpriseProject _Project $projection.ProjectUUID = _Project.ProjectUUID
[1..1] I_EnterpriseProjectRoleType _ProjectRoleType $projection.ProjectRoleType = _ProjectRoleType.ProjectRoleType
[1..1] I_EntProjectRoleCategory _ProjectRoleTypeCategory $projection.ProjectRoleCategory = _ProjectRoleTypeCategory.ProjectRoleCategory

Annotations (17)

NameValueLevelField
VDM.viewType #BASIC view
EndUserText.label Enterprise Project Role view
AbapCatalog.sqlViewName IIENTERPROJROLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ProjectRoleUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProjectRoleUUID /s4ppm/role guid UUID 22 char.
ProjectUUID /s4ppm/role project_guid Project GUID
ProjectRoleType /s4ppm/role role_type Role Type
ProjectRoleCategory /s4ppm/role role_category Role Category
ProjectRoleName /s4ppm/role role_name Role Name
CreatedByUser /s4ppm/role created_by Name of Person Who Created Object
CreationDateTime /s4ppm/role created_on Timestamp of Object Creation
LastChangedByUser /s4ppm/role changed_by Name of Person Who Changed Object
LastChangeDateTime /s4ppm/role changed_on Timestamp of Last Object Change
_Project _Project
_ProjectRoleType _ProjectRoleType
_ProjectRoleTypeCategory _ProjectRoleTypeCategory

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_EnterpriseProjectRole.
-- 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 I_EnterpriseProjectRole AS
SELECT
  role.guid AS ProjectRoleUUID,
  role.project_guid AS ProjectUUID,
  role.role_type AS ProjectRoleType,
  role.role_category AS ProjectRoleCategory,
  role.role_name AS ProjectRoleName,
  role.created_by AS CreatedByUser,
  role.created_on AS CreationDateTime,
  role.changed_by AS LastChangedByUser,
  role.changed_on AS LastChangeDateTime
FROM /s4ppm/role AS role
LEFT OUTER JOIN I_EnterpriseProject AS _Project ON ProjectUUID = _Project.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProjectRoleType AS _ProjectRoleType ON ProjectRoleType = _ProjectRoleType.ProjectRoleType  -- association [1..1]
LEFT OUTER JOIN I_EntProjectRoleCategory AS _ProjectRoleTypeCategory ON ProjectRoleCategory = _ProjectRoleTypeCategory.ProjectRoleCategory  -- association [1..1]
;

Learn More