I_CustomerProjectWorkPackage

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_CustomerProjectWorkPackage.
-- 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: ICPWORKPACKAGE

CREATE VIEW I_CustomerProjectWorkPackage AS
SELECT
  cast(CustomerProjectWorkpackage.WorkPackageUUID as /cpd/ss_cp_wp_uuid ) AS CustProjWorkPackageUUID,
  cast(CustomerProjectWorkpackage.EngagementProjFinPlanUUID as /cpd/cust_pfp_db_key preserving type) AS CustProjFinancialPlanUUID,
  cast(CustomerProjectWorkpackage.WorkPackage as /cpd/ss_cp_wp ) AS CustomerProjectWorkPackage,
  cast(CustomerProjectWorkpackage.WorkPackageName as /cpd/ss_cp_wp_name ) AS CustProjWorkPackageName,
  CustomerProjectWorkpackage.WorkPackageStartDate AS CustProjWorkPackageStartDate,
  CustomerProjectWorkpackage.WorkPackageEndDate AS CustProjWorkPackageEndDate,
  _CustomerProject.CustomerProject AS CustomerProject,
  _CustomerProject.CustomerProjectType AS CustomerProjectType,
  _CustomerProject.CustomerProjectServiceOrg AS CustomerProjectServiceOrg,
  _CustomerProject.Currency AS Currency,
  cast(_CustomerProject.CustomerProjectUUID as /cpd/ss_cp_uuid ) AS CustomerProjectUUID,
  cast(_CustomerProject.CustomerProjectName as /cpd/ss_cp_desc ) AS CustomerProjectName,
  CustomerProjectWorkpackage.WBSElementObject AS WBSElementObject,
  cast(CustomerProjectWorkpackage.SalesOrderItem as /cpd/so_item_id preserving type) AS SalesOrderItem,
  CustomerProjectWorkpackage.SalesOrder AS SalesOrder,
  CustomerProjectWorkpackage.WBSDescription AS WBSDescription,
  CustomerProjectWorkpackage.LastChangeDateTime AS LastChangeDateTime,
  CustomerProjectWorkpackage.LastChangedByUser AS LastChangedByUser
FROM I_WorkPackage AS CustomerProjectWorkpackage
LEFT OUTER JOIN I_CustomerProject AS _CustomerProject ON CustProjFinancialPlanUUID = _CustomerProject.CustProjFinancialPlanUUID  -- association [0..1]
LEFT OUTER JOIN E_CustomerProjectWorkPackage AS _Extension ON CustomerProjectWorkpackage.WorkPackageUUID = _Extension.CustProjWorkPackageUUID  -- association [1..1]
;