I_PPM_ObjectPageChecklistItem

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_ObjectPageChecklistItem.
-- 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: IPPMCHEKLISTITOP

CREATE VIEW I_PPM_ObjectPageChecklistItem AS
SELECT
  ChecklistItem.ChecklistItemUUID AS ChecklistItemUUID,
  ChecklistItem.ObjectType AS ObjectType,
  ChecklistItem.ChecklistParentObjectUUID AS ChecklistParentObjectUUID,
  ChecklistItem.ProjectUUID AS ProjectUUID,
  Project.Project AS Project,
  Project.MasterLanguage AS MasterLanguage,
  ChecklistItem.IsApprovalRelevant AS IsApprovalRelevant,
  ChecklistItem.ChecklistItem AS ChecklistItem,
  ChecklistItem.IsChecklistItemChangeable AS IsChecklistItemChangeable,
  ChecklistItem.FailureModeEfctAnlysDetection AS FailureModeEfctAnlysDetection,
  ChecklistItem.IsDurationZero AS IsDurationZero,
  ChecklistItem.FailureModeEfctAnlysOccurence AS FailureModeEfctAnlysOccurence,
  ChecklistItem.ChecklistItemProcessingStatus AS ChecklistItemProcessingStatus,
  ChecklistItem.ChecklistItemParentProcStatus AS ChecklistItemParentProcStatus,
  ChecklistItem.FailureModeEfctAnlysRiskPrioNo AS FailureModeEfctAnlysRiskPrioNo,
  ChecklistItem.ProjectVersionNumber AS ProjectVersionNumber,
  ChecklistItem.FailureModeEfctAnlysSeverity AS FailureModeEfctAnlysSeverity,
  ChecklistItem.PriorityCode AS PriorityCode,
  ChecklistItem.CreatedByUser AS CreatedByUser,
  ChecklistItem.CreationDateTime AS CreationDateTime,
  ChecklistItem.LastChangedByUser AS LastChangedByUser,
  ChecklistItem.LastChangeDateTime AS LastChangeDateTime,
  ChecklistItem.ActualFinishDate AS ActualFinishDate,
  ChecklistItem.LatestFinishDate AS LatestFinishDate,
  ChecklistItem.ChecklistItemResult AS ChecklistItemResult,
  case when ProjectTextUserLang.ObjectName > '' then ProjectTextUserLang.ObjectName else Project.ProjectName end as ProjectName AS ProjectNameendasProjectName,
  ProjectTextUserLang.ObjectName AS ProjectNameUserLanguage,
  Project.ProjectName AS ProjectNameMasterLanguage,
  case when ChecklistItemTextUserLang.ObjectName > '' then ChecklistItemTextUserLang.ObjectName else case when ChecklistItemTextMasterLang.ObjectName > '' then ChecklistItemTextMasterLang.ObjectName else ChecklistItem.ChecklistItem end end as ChecklistItemName AS ChecklistItemendendasChecklistItemName,
  ChecklistItemTextUserLang.ObjectName AS ChecklistItemNameUserLanguage,
  ChecklistItemTextMasterLang.ObjectName AS ChecklistItemNameMasterLangu,
  /s4ppm/cds_dummy.dummy_string AS ProjectElementDescription,
  _GlobalSetting.EPPMSettingsDefaultValue AS EPPMSettingsDefaultValue,
  ChecklistItem._ChecklistItemResult AS _ChecklistItemResult,
  ChecklistItem._ChecklistItemStatus AS _ChecklistItemStatus,
  ChecklistItem._CreatedByUser AS _CreatedByUser,
  ChecklistItem._IsApprovalRelevant AS _IsApprovalRelevant,
  ChecklistItem._LastChangedByUser AS _LastChangedByUser,
  ChecklistItem._Priority AS _Priority,
  ChecklistItem._AuthUser AS _AuthUser,
  ChecklistItem._AuthSubst AS _AuthSubst,
  ChecklistItem._AuthRole AS _AuthRole,
  ChecklistItem._AuthGroup AS _AuthGroup
FROM I_PPM_ChecklistItem AS ChecklistItem
LEFT OUTER JOIN I_PPM_ProjectSummaryTask AS Project ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS ProjectTextUserLang ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS ChecklistItemTextUserLang ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS ChecklistItemTextMasterLang ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /s4ppm/cds_dummy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EPPMGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_SingleResponsibleForObj AS _Responsible ON _Responsible.ReferencedObjectUUID = ChecklistItemUUID  -- association [0..1]
LEFT OUTER JOIN I_PPM_ChecklistItemSeverity AS _ChecklistItemSeverity ON ChecklistItemUUID = _ChecklistItemSeverity.ReferencedObjectUUID  -- association [1..1]
;