C_EngmntProjFcstQuery

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 C_EngmntProjFcstQuery.
-- 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: CEPFCSTQUERY
-- Parameters: P_Date : sydatum, P_Language : sylangu

CREATE VIEW C_EngmntProjFcstQuery AS
SELECT
  lookupEntity: 'I_FiscalCalendarDate' AS lookupEntityI_FiscalCalendarDate,
  resultElement: 'FiscalYearPeriod' AS resultElementFiscalYearPeriod,
  binding: [ { targetElement : 'CalendarDate' , type : #PARAMETER , value : 'P_Date' AS EngagementProject,
  WorkPackageCube.EngagementProjectName AS EngagementProjectName,
  EngagementProjectServiceOrg,
  _EngagementProjectSrvcOrg._Text[1:Language = $parameters.P_Language].EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  WorkPackageCube.WorkPackage AS WorkPackage,
  WorkPackageCube.WorkPackageName AS WorkPackageName,
  WorkPackageCube.EngagementProjectResourceType AS EngagementProjectResourceType,
  WorkPackageCube.EngagementProjectResource AS EngagementProjectResource,
  _EngagementProjectResource._Text[ 1:Language = $parameters.P_Language ].EngagementProjResourceText AS EngagementProjResourceText,
  WorkPackageCube.WorkItem AS WorkItem,
  _WorkItem.WorkItemName AS WorkItemName,
  WorkPackageCube.EngmntProjectDeliveryOrg AS EngmntProjectDeliveryOrg,
  _EngagementProjectSrvcOrg._Text[ 1:Language = $parameters.P_Language ].EngmtProjectServiceOrgName AS EngagementProjDeliveryOrgName,
  WorkPackageCube.UnitOfMeasure AS UnitOfMeasure,
  WorkPackageCube.Currency AS Currency,
  WorkPackageCube.SalesOrder AS SalesOrder,
  WorkPackageCube.SalesOrderItem AS SalesOrderItem,
  WorkPackageCube.SalesOrderItemText AS SalesOrderItemText,
  1 AS PlannedCostRate,
  1 AS CostVariance,
  1 AS EffortVariance,
  1 AS CalculatedAdjustedRmngCost,
  1 AS CalculatedAdjustedRmngEffort,
  1 AS CalcdAdjustedRmngExpnCost,
  1 AS EstimateToCompleteExpenseCost,
  1 AS EstimateToCompleteEffort,
  1 AS EstimateToCompleteEffortCost,
  1 AS EstimateToCompleteCostAmount,
  1 AS EstimateAtCompletionEffort,
  1 AS EstimateAtCompletionCost,
  1 AS PercentageOfCompletionEffort,
  1 AS PercentageOfCompletionCost
FROM I_EngmntProjFcstCube AS WorkPackageCube
;