P_EngmntProjPlnDataByRsceType

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_EngmntProjPlnDataByRsceType.
-- 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_EngmntProjPlnDataByRsceType AS
SELECT
  A.EngagementProject AS EngagementProject,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  A.Customer AS Customer,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectReviewStatus AS EngagementProjectReviewStatus,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngmntProjReviewYearPeriod AS EngmntProjReviewYearPeriod,
  A.WorkPackage AS WorkPackage,
  A.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  WorkItem,
  A.Currency AS Currency,
  A.EngagementProjectResource AS EngagementProjectResource,
  A.EngagementProjectResourceType AS EngagementProjectResourceType,
  A.UnitOfMeasure AS UnitOfMeasure,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  EngmntProjectDeliveryOrg,
  '' AS GLAccount,
  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,
  A.BaselinePlndCostAmt AS BaselinePlndCostAmt,
  A.BaselinePlndRevnAmt AS BaselinePlndRevnAmt,
  A.PlndCostAmt AS PlndCostAmt,
  A.PlndRevnAmt AS PlndRevnAmt,
  ActualPlanDeviationCost,
  SupplyEffortQty,
  PlannedCostUpToCurPerd,
  PlannedRevnUpToCurPerd,
  PlndCostAmtUpToRevPerd,
  PlndRevnAmtUpToRevPerd,
  case when A.EngagementProjectResourceType = '0EXP' then A.PlndCostAmt else 0 end as PlannedExpenseCost AS PlndCostAmtelse0endasPlannedExpenseCost,
  AdjustedPlndCost,
  cast(0 as /cpd/sc_completionrate) AS UnitCompltnRateUpToCurPerd,
  cast(0 as /cpd/sc_completionrate) AS UnitCompltnRateUpToRevPerd
FROM P_EngmntProjPlnDataByPeriod AS A
INNER JOIN I_WorkPackage AS B ON /* join condition not captured in parsed metadata */
;