I_DevProjRoleStaffing

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_DevProjRoleStaffing.
-- 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: IDEVPROJROLESTAF

CREATE VIEW I_DevProjRoleStaffing AS
SELECT
  cast(_Role.guid as /s4ppm/tv_entity_guid preserving type ) AS ProjectRoleUUID,
  _Role.project_guid AS ProjectUUID,
  _BupaLink.bupa_guid AS BusinessPartnerUUID,
  _EntityLink.DevProjElmntUUID AS DevProjElmntUUID,
  cast(_Hierarchy.FMEANodeUUID as /s4ppm/tv_entity_guid preserving type ) AS DevProjRoleStfngShadowRoleUUID,
  _BupaLink.guid AS StaffingUUID,
  tstmp_to_dats( _BupaLink.beg_tmstmp , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as DevProjRoleStfngBeginDate AS clientNULLasDevProjRoleStfngBeginDate,
  tstmp_to_dats( _BupaLink.end_tmstmp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as DevProjRoleStfngEndDate AS clientNULLasDevProjRoleStfngEndDate,
  _BupaLink.work_effort AS PlannedWorkQuantity,
  _BupaLink.work_unit AS PlannedWorkQuantityUnit,
  _BupaLink.booking_type AS DevProjRoleStfngBookingType,
  tstmp_to_dats( _BupaLink.planstart , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as PlannedStartDate AS clientNULLasPlannedStartDate
FROM /s4ppm/role AS _Role
INNER JOIN I_FMEANodeHierarchy AS _Hierarchy ON /* join condition not captured in parsed metadata */
INNER JOIN dpr_bupa_link AS _BupaLink ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DevProjRoleEntityLink AS _EntityLink ON _EntityLink.BusinessPartnerUUID = _Hierarchy.FMEANodeUUID AND _EntityLink.DevProjElmntObjectType = 'TTO' AND _EntityLink.IsBusinessPartnerResponsible <> 'X'  -- association [1..*]
;