P_EngmntProjUnbilledRevData

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_EngmntProjUnbilledRevData.
-- 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_EngmntProjUnbilledRevData AS
SELECT
  A.EngagementProject AS EngagementProject,
  B.SalesOrder AS SalesOrder,
  A.Currency AS ProjectCurrency,
  A.Currency AS Currency,
  B.PostingDate AS PostingDate,
  B.SalesOrderItem AS SalesOrderItem,
  B.FiscalYear AS FiscalYear,
  concat(B.FiscalYear, concat('0', substring (PostingDate,5,2) )) AS FiscalYearPeriod,
  B.AmountInCompanyCodeCurrency AS UnbilledRevnInCoCodeCrcy,
  B.Ledger AS Ledger,
  B.GLAccountHierarchy AS GLAccountHierarchy,
  A.IsMyProject AS IsMyProject,
  A.ProjectManagerExternalID AS ProjectManagerExternalID,
  A.ProjectManagerName AS ProjectManagerName
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN P_GLAcctLineItemSemTagProjects AS B ON /* join condition not captured in parsed metadata */
INNER JOIN I_EvtBsdRevnRecgnEvalScp AS C ON /* join condition not captured in parsed metadata */
;