P_WorkPackageWorkItem

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 P_WorkPackageWorkItem.
-- 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: PWRKPCKGWITM

CREATE VIEW P_WorkPackageWorkItem AS
SELECT
  WorkItem.db_key AS WorkItemUUID,
  WorkItem.mp_id AS EngagementProject,
  WorkItem.wp_id AS WorkPackage,
  WorkPackage.mapped_item_id AS WBSElementObject,
  WorkItem.root_key AS EngagementProjFinPlanUUID,
  WorkItem.parent_key AS WorkPackageUUID,
  WorkItem.work_item_id AS WorkItem,
  case when WorkItem.work_item_is_standard = 'X' then _WorkItemText[1:Language=$session.system_language].WorkItemName else WorkItem.work_item_name end as WorkItemName AS work_item_nameendasWorkItemName,
  WorkItem.work_item_is_inactive AS WorkItemIsInactive,
  WorkItem.work_item_is_standard AS WorkItemIsStandard,
  WorkItem.created_by AS created_by,
  cast(WorkItem.created_on as /cpd/cpm_createdon) AS created_on,
  WorkItem.changed_by AS changed_by,
  cast(WorkItem.changed_on as /cpd/cpm_changedon) AS changed_on,
  WorkPackage.is_deleted AS is_deleted
FROM /cpd/d_work_item AS WorkItem
INNER JOIN /cpd/d_pfp_ps AS WorkPackage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkItemText AS _WorkItemText ON WorkItem = _WorkItemText.WorkItem  -- association [0..*]
;