I_WorkPackage

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_WorkPackage.
-- 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_WorkPackage AS
SELECT
  WorkPackage.plan_item_id AS WorkPackage,
  cast( WorkPackage.db_key as /cpd/wp_db_key preserving type ) AS WorkPackageUUID,
  cast(WorkPackage.parent_key as /cpd/eng_pfp_db_key preserving type ) AS EngagementProjFinPlanUUID,
  WorkPackage.plan_item_name AS WorkPackageName,
  WorkPackage.start_date AS WorkPackageStartDate,
  WorkPackage.end_date AS WorkPackageEndDate,
  WorkPackage.mapped_item_id AS WBSElementObject,
  WorkPackage.mapped_item_desc AS WBSDescription,
  WorkPackage.sales_order_hdr AS SalesOrder,
  WorkPackage.so_item_id AS SalesOrderItem,
  WorkPackage.changed_by AS LastChangedByUser,
  cast(WorkPackage.changed_on as /cpd/cpm_changedon) AS LastChangeDateTime,
  WorkPackage.created_by AS CreatedByUser,
  cast(WorkPackage.created_on as /cpd/cpm_createdon) AS CreationDateTime,
  WorkPackage.plan_item_type AS WorkPackageType
FROM /cpd/d_pfp_ps AS WorkPackage
LEFT OUTER JOIN I_EngagementProjFinancialPlan AS _EngagementProjFinancialPlan ON EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID  -- association [1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementObject = _WBSElement.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrderItem = _SalesOrderItem.SalesOrderItem AND SalesOrder = _SalesOrderItem.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectPlanData AS _EngagementProjectPlanData ON EngagementProjFinPlanUUID = _EngagementProjectPlanData.EngagementProjFinPlanUUID AND WorkPackage = _EngagementProjectPlanData.WorkPackage  -- association [0..*]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkPackageWorkItem ON WorkPackage = _WorkPackageWorkItem.WorkPackage AND EngagementProjFinPlanUUID = _WorkPackageWorkItem.EngagementProjFinPlanUUID  -- association [0..*]
LEFT OUTER JOIN E_Workpackage AS _Extension ON WorkPackage.db_key = _Extension.WorkPackageUUID  -- association [0..1]
LEFT OUTER JOIN I_ExtSrvcWrkPckgPlnByPerd AS _ExtSrvcWrkPckgPlnByPerd ON EngagementProjFinPlanUUID = _ExtSrvcWrkPckgPlnByPerd.EngagementProjFinPlanUUID AND WorkPackage = _ExtSrvcWrkPckgPlnByPerd.WorkPackage  -- association [0..*]
LEFT OUTER JOIN I_WorkPackageWithFunctionValue AS _WorkPackageFunction ON WorkPackage = _WorkPackageFunction.WorkPackage  -- association [1..*]
;