P_EngmntProjPlngData

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_EngmntProjPlngData.
-- 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 P_EngmntProjPlngData AS
SELECT
  A.EngagementProject AS EngagementProject,
  A.Customer AS Customer,
  A.EngmntProjReviewYearPeriod AS EngmntProjReviewYearPeriod,
  A.EngagementProjectReviewStatus AS EngagementProjectReviewStatus,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.CurrentYearPeriod AS CurrentYearPeriod,
  A.ProjectManagerExternalID AS ProjectManagerExternalID,
  A.ProjectAccountantExternalID AS ProjectAccountantExternalID,
  A.ProjectControllerExternalID AS ProjectControllerExternalID,
  A.ProjectPartnerExternalID AS ProjectPartnerExternalID,
  A.ProjManagerUserID AS ProjectManager,
  A.ProjAccountantUserID AS ProjectAccountant,
  A.ProjControllerUserID AS ProjectController,
  A.ProjPartnerUserID AS Projectpartner,
  A.ProjectManagerName AS ProjectManagerName,
  A.ProjectAccountantName AS ProjectAccountantName,
  A.ProjectControllerName AS ProjectControllerName,
  A.ProjectPartnerName AS ProjectPartnerName,
  A.IsMyProject AS IsMyProject,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  B.WorkPackage AS WorkPackage,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  B.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  B.BillingControlCategory AS BillingControlCategory,
  B.PlndCostAmt AS PlndCostAmt,
  B.PlndRevnAmt AS PlndRevnAmt,
  B.PlndEffortQty AS PlndEffortQty,
  B.ResourceDemandUUID AS ResourceDemandUUID,
  B.ResourceDemand AS ResourceDemand,
  B.ResourceSupply AS ResourceSupply,
  B.EngagementProjectResource AS EngagementProjectResource,
  case when B.IsUnitBased = 'X' then B.UnitOfMeasure end as WorkPackageUnitUoM AS UnitOfMeasureendasWorkPackageUnitUoM,
  B.UnitOfMeasure AS UnitOfMeasure,
  B.EngagementProjectResourceType AS EngagementProjectResourceType,
  B.WorkItem AS WorkItem,
  B.EmploymentInternalID AS EmploymentInternalID,
  B.EngmtProjEmployeeIsStaffed AS EngmtProjEmployeeIsStaffed,
  B.FiscalYear AS FiscalYear,
  B.FiscalPeriod AS FiscalPeriod,
  A.Currency AS Currency,
  B.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  SupplyEmployeeDelOrg.EngagementProjectServiceOrg AS EngmntProjectDeliveryOrg,
  B.IsUnitBased AS IsUnitBased,
  A.ProjectVisibility AS ProjectVisibility,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  A.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  A.ProfitCenter AS ProfitCenter
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN I_EngmntProjectPlanData AS B ON /* join condition not captured in parsed metadata */
;