I_DevProjRoleStaffing_2

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_2.
-- 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_DevProjRoleStaffing_2 AS
SELECT
  _Role.project_guid AS ProjectUUID,
  cast(_Role.guid as /s4ppm/tv_entity_guid preserving type ) AS ProjectRoleUUID,
  cast(I_FMEANodeHierarchy.FMEANodeUUID as /s4ppm/tv_entity_guid preserving type ) AS DevProjRoleStfngShadowRoleUUID,
  _BupaLink.bupa_guid AS BusinessPartnerUUID,
  _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 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_DevelopmentProjectRole AS _ProjectRole ON ProjectRoleUUID = _ProjectRole.ProjectRoleUUID  -- association [1..1]
LEFT OUTER JOIN I_DevelopmentProject AS _Project ON ProjectUUID = _Project.ProjectUUID  -- association [1..1]
;