I_DevelopmentProjectRole

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_DevelopmentProjectRole.
-- 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: DEVPROJROLE

CREATE VIEW I_DevelopmentProjectRole AS
SELECT
  _Role.guid AS ProjectRoleUUID,
  _Role.project_guid AS ProjectUUID,
  _Role.role_type AS ProjectRoleType,
  _Role.role_name AS ProjectRoleName,
  _Part.sort_number AS SortingNumber,
  _Part.work_unit AS PlannedWorkQuantityUnit,
  _Part.work_effort AS PlannedWorkQuantity,
  _Part.vacant AS IsVacant,
  _Part.rate AS CostRevenueRateCode,
  _Part.currency AS ManualRevenueRateCurrency,
  _Part.revenue_rate AS ManualRevenueRate,
  _Part.act_wrk_unit_ext AS ActualWorkQuantityUnit,
  tstmp_to_dats( _Part.beg_tmstmp , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as PlannedStartDate AS clientNULLasPlannedStartDate,
  tstmp_to_dats( _Part.end_tmstmp , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as DevProjRolePlndFinishDate AS clientNULLasDevProjRolePlndFinishDate,
  _Part.participant_id AS ProjectRole,
  _Part.role_function_id AS DevProjRoleFunctionID,
  _Part.location AS LocationType
FROM /s4ppm/role AS _Role
INNER JOIN dpr_part AS _Part ON /* join condition not captured in parsed metadata */
INNER JOIN cgpl_task AS _Task ON /* join condition not captured in parsed metadata */
;