I_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 I_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.

CREATE VIEW I_WorkPackageWorkItem AS
SELECT
  WorkPackageWorkItem.WorkItem AS WorkItem,
  WorkPackageWorkItem.WorkPackage AS WorkPackage,
  WorkPackageWorkItem.EngagementProject AS EngagementProject,
  WorkPackageWorkItem.WBSElementObject AS WBSElementObject,
  cast(WorkPackageWorkItem.WorkPackageUUID as /cpd/wp_db_key preserving type ) AS WorkPackageUUID,
  cast(WorkPackageWorkItem.WorkItemUUID as /cpd/wi_db_key preserving type ) AS WorkItemUUID,
  cast(WorkPackageWorkItem.EngagementProjFinPlanUUID as /cpd/eng_pfp_db_key preserving type ) AS EngagementProjFinPlanUUID,
  WorkPackageWorkItem.WorkItemName AS WorkItemName,
  WorkPackageWorkItem.WorkItemIsInactive AS WorkItemIsInactive
FROM P_WorkPackageWorkItem AS WorkPackageWorkItem
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjFinancialPlan AS _EngagementProjFinancialPlan ON EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectPlanData AS _EngagementProjectPlanData ON WorkPackage = _EngagementProjectPlanData.WorkPackage AND EngagementProjFinPlanUUID = _EngagementProjectPlanData.EngagementProjFinPlanUUID AND WorkItem = _EngagementProjectPlanData.WorkItem  -- association [0..*]
;