P_EngmntProjPlnDataAttributes

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_EngmntProjPlnDataAttributes.
-- 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_EngmntProjPlnDataAttributes AS
SELECT
  A.EngagementProject AS EngagementProject,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  A.Customer AS Customer,
  A.EngmntProjReviewYearPeriod AS EngmntProjReviewYearPeriod,
  A.EngagementProjectReviewStatus AS EngagementProjectReviewStatus,
  A.EngagementProjectStage AS EngagementProjectStage,
  CurrentYearPeriod,
  A.WorkPackage AS WorkPackage,
  A.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  A.WorkItem AS WorkItem,
  A.Currency AS Currency,
  A.EngagementProjectResource AS EngagementProjectResource,
  A.EngagementProjectResourceType AS EngagementProjectResourceType,
  A.BillingControlCategory AS BillingControlCategory,
  A.EngagementProjectServiceOrg AS DemandServiceOrg,
  A.ResourceDemand AS ResourceDemand,
  cast ( cast ((SupplyCostAmt + RemainingDemandCostAmt + PlannedExpenseCost ) as abap.curr( 23, 2 )) as /cpd/pfp_curr ) AS PlndCostAmt,
  case when A.IsUnitBased <> 'X' then cast ( cast ((SupplyEffortQty + RemainingDemandEffortQty ) as abap.quan( 15, 3 ) ) as megxxx) else A.PlndEffortQty end as PlndEffortQty AS PlndEffortQtyendasPlndEffortQty,
  case when A.IsUnitBased <> 'X' then cast ( cast ((SupplyRevnAmt + RemainingDemandRevnAmt + PlannedExpenseRevenue ) as abap.curr( 23, 2 )) as /cpd/pfp_curr ) else A.PlndRevnAmt end as PlndRevnAmt AS PlndRevnAmtendasPlndRevnAmt,
  case when A.IsUnitBased <> 'X' then A.PlndEffortQty end as DemandEffortQty AS PlndEffortQtyendasDemandEffortQty,
  A.PlndCostAmt AS DemandCostAmt,
  A.PlndRevnAmt AS DemandRevAmt,
  A.ActualPlanDeviationCost AS ActualPlanDeviationCost,
  A.ActualPlanDeviationEffort AS ActualPlanDeviationEffort,
  SupplyEffortQty,
  A.FiscalYear AS FiscalYear,
  A.FiscalPeriod AS FiscalPeriod,
  concat (A.FiscalYear,A.FiscalPeriod) AS FiscalYearPeriod,
  A.UnitOfMeasure AS UnitOfMeasure,
  IsUnitBased,
  A.IsMyProject AS IsMyProject,
  A.ProjectManager AS ProjectManager,
  A.ProjectManagerName AS ProjectManagerName,
  A.ProjectManagerExternalID AS ProjectManagerExternalID,
  A.ProjectAccountant AS ProjectAccountant,
  A.ProjectAccountantName AS ProjectAccountantName,
  A.ProjectAccountantExternalID AS ProjectAccountantExternalID,
  A.ProjectController AS ProjectController,
  A.ProjectControllerName AS ProjectControllerName,
  A.ProjectControllerExternalID AS ProjectControllerExternalID,
  A.Projectpartner AS Projectpartner,
  A.ProjectPartnerName AS ProjectPartnerName,
  A.ProjectPartnerExternalID AS ProjectPartnerExternalID,
  A.ProjectVisibility AS ProjectVisibility,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  A.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  A.ProfitCenter AS ProfitCenter
FROM P_PlngDataAggrgnByDelivOrg AS A
;