P_EngmntProjPlnDataDrftUnion

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_EngmntProjPlnDataDrftUnion.
-- 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: PPLNDATADFTUNION

CREATE VIEW P_EngmntProjPlnDataDrftUnion AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as /cpd/eng_pfp_db_key ) AS EngmntProjPlanDataDraftUUID,
  Active.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  Active.WorkPackageUUID AS WorkPackageUUID,
  Active.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  Active.EngagementProjectResourceType AS EngagementProjectResourceType,
  Active.EngagementProjectResource AS EngagementProjectResource,
  Active.WorkPackage AS WorkPackage,
  Active.FiscalPeriod AS FiscalPeriod,
  Active.FiscalYear AS FiscalYear,
  Active.EmploymentInternalID AS EmploymentInternalID,
  Active.EngmtProjEmployeeIsStaffed AS EngmtProjEmployeeIsStaffed,
  Active.WorkItem AS WorkItem,
  Active.ResourceDemandUUID AS ResourceDemandUUID,
  Active.ResourceDemand AS ResourceDemand,
  Active.ResourceSupply AS ResourceSupply,
  Active.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  cast ( hextobin('00000000000000000000000000000000') as /cpd/eng_db_key ) AS EngagementProjectUUID,
  Active.Currency AS Currency,
  Active.PlndCostAmt AS PlndCostAmt,
  Active.UnitOfMeasure AS UnitOfMeasure,
  Active.PlndEffortQty AS PlndEffortQty,
  Active.PlndRevnAmt AS PlndRevnAmt,
  Active.ActualPlanDeviationCost AS ActualPlanDeviationCost,
  Active.ActualPlanDeviationEffort AS ActualPlanDeviationEffort,
  Active.ActualPlanDeviationRevenue AS ActualPlanDeviationRevenue,
  Active.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  Active.SupplySource AS SourceOfSupply,
  Active.BillingControlCategory AS BillingControlCategory,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  cast( ' ' as sdraft_has_active preserving type ) AS HasActiveEntity,
  cast( case when Draft.DraftUUID is null then ' ' else 'X' end as sdraft_has_draft preserving type ) as HasDraftEntity AS DraftUUIDasEngmntProjPlanDataDraftUUID,
  cast( ' ' as sdraft_has_draft preserving type ) AS HasDraftEntity
FROM I_EngmntProjectPlnDataVersion AS Active
LEFT OUTER JOIN I_EngmntProjPlanDrftData AS Draft ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_EngmntProjPlanDrftData
;