C_PPM_ProjectBriefCost

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_PPM_ProjectBriefCost.
-- 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: CPPMPROBRFCOSP

CREATE VIEW C_PPM_ProjectBriefCost AS
SELECT
  PPM.ProjectUUID AS ProjectUUID,
  PPM.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  PPM.ProjectInternalID AS ProjectInternalID,
  Period.YearMonth AS YearMonth,
  PPM.Project AS Project,
  cast( 'EUR' as abap.cuky ) AS GlobalCurrency,
  Period.CalendarYear AS CalendarYear,
  Period.CalendarMonth AS CalendarMonth,
  _CalendarMonth._Text[1:Language = $session.system_language].CalendarMonthName AS CalendarMonthName,
  cast( 0 as /s4ppm/ovr_act_cos_in_glo_curr) AS ActualAmountInGlobalCurrency,
  cast( 0 as /s4ppm/ovr_pln_cos_in_glo_curr) AS PlanAmountInGlobalCurrency,
  PPM._I_Project AS _I_Project,
  PPM._AuthUser AS _AuthUser,
  PPM._AuthSubst AS _AuthSubst,
  PPM._AuthRole AS _AuthRole,
  PPM._AuthGroup AS _AuthGroup
FROM I_PPM_Project AS PPM
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1]
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUserFin ON _AuthUserFin.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthUserFin.UserID = $session.user AND _AuthUserFin.Activity = 'Financials'  -- association [0..1]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubstFin ON _AuthSubstFin.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthSubstFin.UserID = $session.user AND _AuthSubstFin.Activity = 'Financials'  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRoleFin ON _AuthRoleFin.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthRoleFin.UserID = $session.user AND _AuthRoleFin.Activity = 'Financials'  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroupFin ON _AuthGroupFin.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthGroupFin.UserID = $session.user AND _AuthGroupFin.Activity = 'Financials'  -- association [0..*]
;