I_EngagementProjectRole

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_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: IENGMTPROJROLE

CREATE VIEW I_EngagementProjectRole AS
SELECT
  EngagementProject.EngagementProject AS EngagementProject,
  EngagementProjectTeamRole.EngagementProjectTeamRole AS EngagementProjectTeamRole,
  EngagementProject.ProjectStartDate AS ProjectStartDate,
  cast( EngagementProjectTeam.EngagementProjectUUID as /cpd/eng_db_key preserving type ) AS EngagementProjectUUID,
  cast(EngagementProjectTeam.EngagementProjectTeamUUID as /cpd/team_db_key preserving type ) AS EngagementProjectTeamUUID,
  cast(EngagementProjectTeamRole.EngagementProjectTeamRoleUUID as /cpd/eng_team_role_db_key preserving type ) AS EngagementProjectTeamRoleUUID,
  cast(EngmtProjTeamMember.EngmtProjTeamMemberUUID as /cpd/eng_team_member_db_key preserving type ) AS EngmtProjTeamMemberUUID,
  cast(EngmtProjTeamMember.EngagementProjectMemberUUID as /cpd/eng_proj_member_db_key preserving type ) AS EngagementProjectMemberUUID,
  EngagementProjectMember.EmploymentInternalID AS EmploymentInternalID,
  EngagementProjectMember.BusinessPartnerType AS BusinessPartnerType,
  EngagementProjectMember.BusinessPartnerType AS BusinessPartnerMemberType,
  _PersonWorkAgreement._WorkforcePerson.UserID AS BusinessUser,
  _PersonWorkAgreement._WorkforcePerson.PersonFullName AS PersonFullName,
  _PersonWorkAgreement._WorkforcePerson.PersonExternalID AS PersonExternalID
FROM I_EngagementProject AS EngagementProject
INNER JOIN I_EngagementProjectTeam AS EngagementProjectTeam ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngagementProjectTeamRole AS EngagementProjectTeamRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngmtProjTeamMember AS EngmtProjTeamMember ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngagementProjectMember AS EngagementProjectMember ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreement ON EmploymentInternalID = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..*]
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN I_EngmtProjectRoleText AS _Text ON EngagementProjectTeamRole = _Text.EngagementProjectRole  -- association [0..*]
;