P_EngmntProjPlannedData

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_EngmntProjPlannedData.
-- 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_EngmntProjPlannedData AS
SELECT
  D.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  D.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  D.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  D.ControllingArea AS ControllingArea,
  D.CompanyCode AS CompanyCode,
  D.Ledger AS Ledger,
  D.FiscalYear AS FiscalYear,
  D.ProfitCenter AS ProfitCenter,
  D.CostCenter AS CostCenter,
  D.Project AS Project,
  _WBSElementBasicData.WBSElement AS WBSElement,
  D.WBSElementInternalID AS WBSElementInternalID,
  D.CostCtrActivityType AS CostCtrActivityType,
  D.WorkPackage AS WorkPackage,
  D.WorkItem AS WorkItem,
  D.BillableControl AS BillableControl,
  case when D.PartnerCostCtrActivityType <> '' then D.PartnerCostCtrActivityType when Cost.EngagementProjectResource <> '' then Cost.EngagementProjectResource when D.Material <> '' then D.Material end as EngagementProjectResource AS MaterialendasEngagementProjectResource,
  D.TransactionCurrency AS TransactionCurrency,
  D.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  D.CompanyCodeCurrency AS CompanyCodeCurrency,
  D.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  D.GlobalCurrency AS GlobalCurrency,
  D.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  D.CostSourceUnit AS UnitOfMeasure,
  case when D.PlanningCategory = 'PRO02' then D.ValuationQuantity else 0 end as PlndEffortQty AS ValuationQuantityelse0endasPlndEffortQty,
  D.FiscalPeriod AS FiscalPeriod,
  D.FiscalYearPeriod AS FiscalYearPeriod,
  D.SalesDocument AS SalesOrder,
  D.SalesDocumentItem AS SalesOrderItem,
  D.Product AS Product,
  D.ProductGroup AS ProductGroup,
  D.Customer AS Customer,
  D.PlanningCategory AS PlanningCategory,
  D.AccountAssignmentType AS AccountAssignmentType,
  D.PersonnelNumber AS PersonnelNumber,
  A.IsMyProject AS IsMyProject,
  A.ProjectManagerName AS ProjectManagerName
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN I_FinancialPlanningEntryItem AS D ON /* join condition not captured in parsed metadata */
;