I_EngmntProjectSupplyData

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_EngmntProjectSupplyData.
-- 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: IENGPRJSPLYDATA

CREATE VIEW I_EngmntProjectSupplyData AS
SELECT
  cast(EngagementProjectSupplyData.fp_key as /cpd/eng_pfp_db_key preserving type ) AS EngagementProjFinPlanUUID,
  cast(EngagementProjectSupplyData.wp_key as /cpd/wp_db_key preserving type ) AS WorkPackageUUID,
  EngagementProjectSupplyData.version AS EngmtProjFinPlanVersion,
  EngagementProjectSupplyData.res_type AS EngagementProjectResourceType,
  I_WorkPackage.WorkPackage AS WorkPackage,
  EngagementProjectSupplyData.period AS FiscalPeriod,
  EngagementProjectSupplyData.fc_year AS FiscalYear,
  EngagementProjectSupplyData.resource_id AS EngagementProjectResource,
  EngagementProjectSupplyData.employee AS EmploymentInternalID,
  EngagementProjectSupplyData.confirmed AS EngmtProjEmployeeIsStaffed,
  EngagementProjectSupplyData.workitem_id AS WorkItem,
  EngagementProjectSupplyData.demand_key AS ResourceDemandUUID,
  cast(I_EngagementProjFinancialPlan.EngagementProjectUUID as /cpd/eng_db_key preserving type ) AS EngagementProjectUUID,
  EngagementProjectSupplyData.billgctrlcat AS BillingControlCategory,
  EngagementProjectSupplyData.delvry_serv_org AS EngagementProjectServiceOrg,
  EngagementProjectSupplyData.currency AS Currency,
  EngagementProjectSupplyData.line_type AS EngmntProjPlanLineType,
  EngagementProjectSupplyData.resource_demand_id AS ResourceDemand,
  EngagementProjectSupplyData.resource_supply_id AS ResourceSupply,
  EngagementProjectSupplyData.source_of_supply AS SourceOfSupply,
  EngagementProjectSupplyData.source_of_supply AS SupplySource,
  EngagementProjectSupplyData.cost AS PlndCostAmt,
  EngagementProjectSupplyData.uom AS UnitOfMeasure,
  EngagementProjectSupplyData.effort AS PlndEffortQty,
  EngagementProjectSupplyData.revenue AS PlndRevnAmt,
  EngagementProjectSupplyData.cost_deviation AS ActualPlanDeviationCost,
  EngagementProjectSupplyData.effort_deviation AS ActualPlanDeviationEffort,
  EngagementProjectSupplyData.revenue_deviation AS ActualPlanDeviationRevenue,
  I_WorkPackage.SalesOrder AS SalesOrder,
  cast(I_WorkPackage.SalesOrderItem as /cpd/so_item_id preserving type ) AS SalesOrderItem,
  I_WorkPackage.WorkPackageStartDate AS WorkPackageStartDate,
  I_WorkPackage.WorkPackageEndDate AS WorkPackageEndDate
FROM /cpd/plandata AS EngagementProjectSupplyData
INNER JOIN I_WorkPackage ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngagementProjFinancialPlan ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProjectUUID = _EngagementProject.EngagementProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjFinancialPlan AS _EngagementProjFinancialPlan ON EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [1..1]
LEFT OUTER JOIN I_BillingControlCategory AS _BillingControlCategory ON BillingControlCategory = _BillingControlCategory.BillingControlCategory  -- association [0..1]
LEFT OUTER JOIN I_EngmtProjFinPlanVersion AS _EngmtProjFinPlanVersion ON EngagementProjFinPlanUUID = _EngmtProjFinPlanVersion.EngagementProjFinPlanUUID AND EngmtProjFinPlanVersion = _EngmtProjFinPlanVersion.EngmtProjFinPlanVersion  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjResourceType AS _EngmntProjResourceType ON EngagementProjectResourceType = _EngmntProjResourceType.EngagementProjectResourceType  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectResource AS _EngagementProjectResource ON EngagementProjectResource = _EngagementProjectResource.EngagementProjectResource  -- association [0..*]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem AND WorkPackage = _WorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreementDet ON EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement  -- association [0..*]
LEFT OUTER JOIN I_Employment AS _Employment ON EmploymentInternalID = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON EmploymentInternalID = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngagementProjectServiceOrg ON EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_PlanSkillTags AS _PlanSkillTags ON ResourceDemandUUID = _PlanSkillTags.ResourceDemandUUID  -- association [0..1]
;