P_EngmntProjStaffingAnalysis

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_EngmntProjStaffingAnalysis.
-- 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_EngmntProjStaffingAnalysis AS
SELECT
  B.EngagementProject AS EngagementProject,
  B.WorkPackage AS WorkPackage,
  B.WorkItem AS WorkItem,
  B.EngagementProjectResource AS EngagementProjectResource,
  B.EngagementProjectResourceType AS EngagementProjectResourceType,
  B.PersonnelNumber AS PersonnelNumber,
  B.CurrentDate AS CurrentDate,
  concat(left(B.CurrentDate, 4), concat('0', substring(B.CurrentDate, 5, 2))) AS ToFiscalYearPeriod,
  concat(B.FiscalYear, B.FiscalPeriod) AS FiscalYearPeriod,
  B.FiscalYear AS FiscalYear,
  B.FiscalPeriod AS FiscalPeriod,
  B.UnitOfMeasure AS UnitOfMeasure,
  A.IsMyProject AS IsMyProject,
  A.ProjectManagerName AS ProjectManagerName,
  A.ProjectManagerExternalID AS ProjectManagerExternalID,
  A.ProjManagerUserID AS ProjectManager,
  B.PlndEffortQty AS PlndEffortQty,
  B.EngmntProjStaffedEffort AS EngmntProjStaffedEffort,
  B.RecordedHours AS RecordedHours,
  B.UnapprovedHours AS UnapprovedHours,
  B.ApprovedHours AS ApprovedHours,
  B.ActlEffortQty AS ActlEffortQty
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN P_EngagementProjTimeShtAnlys AS B ON /* join condition not captured in parsed metadata */
;