I_PPM_ChecklistItemSeverity

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 I_PPM_ChecklistItemSeverity.
-- 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: IPPMCLISEVERITY

CREATE VIEW I_PPM_ChecklistItemSeverity AS
SELECT
  Severity.ReferencedObjectUUID AS ReferencedObjectUUID,
  SeverityText.SeverityText AS SeverityText,
  Severity.Severity AS Severity,
  SeveritySettings.CriticalityCode AS CriticalityCode
FROM P_PPM_ActualChcklstItmSeverity AS Severity
LEFT OUTER JOIN I_PPM_SeverityText AS SeverityText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Severity AS SeveritySettings ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ReferencedObjectUUID AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' OR _AuthUser.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = ReferencedObjectUUID AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' OR _AuthSubst.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = ReferencedObjectUUID AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' OR _AuthRole.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = ReferencedObjectUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_SeverityText AS _SeverityText ON ( _SeverityText.Severity = Severity ) AND( _SeverityText.EvaluationEngineApplication = 'CPROJECTS' )  -- association [0..*]
;