P_EngmntProjectWithActual

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_EngmntProjectWithActual.
-- 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_EngmntProjectWithActual AS
SELECT
  EngagementProject.EngagementProject AS EngagementProject,
  EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  EngagementProject.Customer AS Customer,
  EngagementProject.Currency AS Currency,
  EngagementProject.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  EngagementProject.EngmntProjReviewYearPeriod AS EngmntProjReviewYearPeriod,
  EngagementProject.EngagementProjectReviewStatus AS EngagementProjectReviewStatus,
  EngagementProject.EngagementProjectType AS EngagementProjectType,
  EngagementProject.EngagementProjectCategory AS EngagementProjectCategory,
  EngagementProject.EngagementProjectStage AS EngagementProjectStage,
  EngagementProject.CurrentYearPeriod AS CurrentYearPeriod,
  Actuals.WBSElement AS WBSElement,
  Actuals.ControllingObject AS ControllingObject,
  Actuals.WorkPackage AS WorkPackage,
  Actuals.WorkItem AS WorkItem,
  EmpOrg.CompanyCode AS PartnerCompanyCode,
  EmpOrg.CostCenter AS PartnerCostCenter,
  EmpOrg.StartDate AS StartDate,
  EmpOrg.EndDate AS EndDate,
  Actuals.SalesDocument AS SalesOrder,
  Actuals.SalesDocumentItem AS SalesOrderItem,
  Actuals.Product AS Material,
  Actuals.SourceLedger AS Ledger,
  Actuals.GLAccount AS GLAccount,
  Actuals.ChartOfAccounts AS ChartOfAccounts,
  Actuals.ControllingObjectDebitType AS ControllingObjectDebitType,
  Actuals.BusinessTransactionType AS BusinessTransactionType,
  Actuals.PersonnelNumber AS PersonnelNumber,
  case when Actuals.ControllingObjectDebitType = '1' and Actuals.Product <> '' and Actuals.MaterialGroup = 'P001' then Actuals.Quantity else Actuals.ValuationQuantity end as ValuationQuantity AS ValuationQuantityendasValuationQuantity,
  case when Actuals.ControllingObjectDebitType = '1' and Actuals.Product <> '' and Actuals.MaterialGroup = 'P001' then Actuals.BaseUnit else Actuals.CostSourceUnit end as BaseUnit AS CostSourceUnitendasBaseUnit,
  Actuals.FiscalYearPeriod AS FiscalYearPeriod,
  Actuals.PostingDate AS PostingDate,
  substring(Actuals.PostingDate,1,4) AS FiscalYear,
  substring(Actuals.PostingDate,5,2) AS FiscalPeriod,
  Actuals.CompanyCodeCurrency AS CompanyCodeCurrency,
  Actuals.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Actuals.ControllingObjectCurrency AS ControllingObjectCurrency,
  Actuals.AmountInObjectCurrency AS AmountInObjectCurrency,
  Actuals.GlobalCurrency AS GlobalCurrency,
  Actuals.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Actuals.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Actuals.TransactionCurrency AS TransactionCurrency,
  Actuals.Quantity AS Quantity,
  Actuals.CostSourceUnit AS CostSourceUnit,
  case when EmpOrg.CompanyCode <> '' then EmpOrg.CompanyCode else Actuals.PartnerCompanyCode end as CompanyCode AS PartnerCompanyCodeendasCompanyCode,
  case when EmpOrg.CostCenter <> '' then EmpOrg.CostCenter else Actuals.PartnerCostCenter end as CostCenter AS PartnerCostCenterendasCostCenter,
  Actuals.ControllingArea AS ControllingArea,
  ProjectManagerExternalID,
  ProjectAccountantExternalID,
  ProjectControllerExternalID,
  ProjectPartnerExternalID,
  ProjManagerUserID AS ProjectManager,
  ProjAccountantUserID AS ProjectAccountant,
  ProjControllerUserID AS ProjectController,
  ProjPartnerUserID AS Projectpartner,
  ProjectManagerName,
  ProjectAccountantName,
  ProjectControllerName,
  ProjectPartnerName,
  IsMyProject,
  ProjectVisibility,
  ProjectProfileCode,
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  EngagementProject.ProfitCenter AS ProfitCenter
FROM I_EngmntProjAssgmtToSessionUsr AS EngagementProject
INNER JOIN P_EngmntProjGLAcctRawData AS Actuals ON /* join condition not captured in parsed metadata */
;