I_PPM_BPForObjectDirect

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_PPM_BPForObjectDirect.
-- 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: IPPMBP4OBJDRCT

CREATE VIEW I_PPM_BPForObjectDirect AS
SELECT
  elink.entity_guid AS ReferencedObjectUUID,
  blink.bupa_guid AS BusinessPartnerUUID,
  cast(cgplhier.up as /s4ppm/tv_entity_guid preserving type ) AS ProjectRoleUUID,
  elink.responsible AS IsBusinessPartnerResponsible,
  cast(blink.beg_tmstmp as /s4ppm/tv_constraint_time preserving type) AS StaffingPeriodStartDateTime,
  cast(blink.planstart as /s4ppm/tv_planstart preserving type) AS PlannedStartDateTime,
  cast(elink.end_tmstmp as /s4ppm/tv_constraint_time preserving type) AS StaffingPeriodFinishDateTime,
  cast(blink.planfinish as /s4ppm/tv_planfinish preserving type) AS PlannedEndDateTime
FROM dpr_entity_link AS elink
INNER JOIN dpr_bupa_link AS blink ON /* join condition not captured in parsed metadata */
INNER JOIN cgpl_hierarchy AS cgplhier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUser ON ( BusinessPartnerUUID = _BusinessUser.BusinessPartnerUUID )  -- association [0..1]
LEFT OUTER JOIN I_PPM_Text AS _ProjectRoleName ON ( ProjectRoleUUID = _ProjectRoleName.ReferencedObjectUUID )  -- association [0..*]
;