P_EngagementProjectRole

DDL: P_ENGAGEMENTPROJECTROLE SQL: PENGMNTPROJROLE Type: view COMPOSITE
10 Fields 1 Data Sources

P_EngagementProjectRole is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngagementProjectRole) and exposes 10 fields.

Data Sources (1)

SourceAliasJoin Type
I_EngagementProjectRole EnagementProjectRole from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PENGMNTPROJROLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
EngagementProject I_EngagementProjectRole EngagementProject Engmnt Project ID
BusinessUserendasProjectManager
PersonFullNameendasProjectManagerName
BusinessUserendasProjectAccountant
PersonFullNameendasProjectAccountantName
BusinessUserendasProjectController
PersonFullNameendasProjectControllerName
BusinessUserendasProjectPartner
PersonFullNameendasProjectPartnerName
EngagementProjectTeamRole I_EngagementProjectRole EngagementProjectTeamRole

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_EngagementProjectRole.
-- 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: PENGMNTPROJROLE

CREATE VIEW P_EngagementProjectRole AS
SELECT
  EnagementProjectRole.EngagementProject AS EngagementProject,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P001' then EnagementProjectRole.BusinessUser end as ProjectManager AS BusinessUserendasProjectManager,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P001' then EnagementProjectRole.PersonFullName end as ProjectManagerName AS PersonFullNameendasProjectManagerName,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P002' then EnagementProjectRole.BusinessUser end as ProjectAccountant AS BusinessUserendasProjectAccountant,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P002' then EnagementProjectRole.PersonFullName end as ProjectAccountantName AS PersonFullNameendasProjectAccountantName,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P003' then EnagementProjectRole.BusinessUser end as ProjectController AS BusinessUserendasProjectController,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P003' then EnagementProjectRole.PersonFullName end as ProjectControllerName AS PersonFullNameendasProjectControllerName,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P004' then EnagementProjectRole.BusinessUser end as ProjectPartner AS BusinessUserendasProjectPartner,
  case when EnagementProjectRole.EngagementProjectTeamRole = 'P004' then EnagementProjectRole.PersonFullName end as ProjectPartnerName AS PersonFullNameendasProjectPartnerName,
  EnagementProjectRole.EngagementProjectTeamRole AS EngagementProjectTeamRole
FROM I_EngagementProjectRole AS EnagementProjectRole
;

Learn More