satc_Ac_Rstism_Ddlv

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 satc_Ac_Rstism_Ddlv.
-- 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 satc_Ac_Rstism_Ddlv AS
SELECT
  fnd_v.item_id AS item_id,
  h.display_id AS display_id,
  itm.created_on AS since,
  itm.status AS status,
  chm.module_id AS module_id,
  chm.ci_id AS test_id,
  obj.obj_name AS obj_name,
  obj.obj_type AS obj_type,
  osy.package_name AS package_name,
  osy.comp_short AS comp_short,
  osy.dlv_release AS dlv_release,
  osy.dlv_unit AS dlv_unit,
  osy.tr_layer AS tr_layer,
  itm.processor AS resp1,
  fnd.checksum AS checksum,
  fnd_v.exc_kind AS exc_kind,
  fnd_v.exc_validity AS exc_validity,
  fnd_v.exc_approval AS exc_approval,
  msgt.title AS msg_title,
  fnd_v.priority AS priority,
  fnd_v.created_on AS timestamp,
  fnd_v.host AS host,
  fnd_v.status_new AS status_new,
  fnd_v.status_old AS status_old,
  fnd_v.sub_index AS sub_index
FROM satc_ac_resulth AS h
INNER JOIN satc_ac_fnd_v AS fnd_v ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_itm AS itm ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_fnd AS fnd ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_obj AS obj ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_osy AS osy ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_chm AS chm ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_cmm AS cmm ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_chc AS chc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN satc_ac_msgt AS msgt ON /* join condition not captured in parsed metadata */
;