I_ISLM_P_PREREQ_CHK

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_ISLM_P_PREREQ_CHK.
-- 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 I_ISLM_P_PREREQ_CHK AS
SELECT
  guid,
  name,
  description,
  is_mandatory,
  check_type,
  status,
  type,
  id,
  msg_number,
  message,
  message_v1,
  message_v2,
  message_v3,
  message_v4,
  actual_value,
  addl_info,
  run._parent.parent_guid AS devclass,
  run._parent.status AS scn_status,
  run
FROM islm_prereq_chk
LEFT OUTER JOIN I_ISLM_P_PREREQ_RUNS AS run ON check_run_guid = run.guid  -- association [1..1]
;