SATC_CI_CF_P_V_BASE

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_CI_CF_P_V_BASE.
-- 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_CI_CF_P_V_BASE AS
SELECT
  root_id,
  conf_id,
  test,
  message_id,
  test_title,
  test_title_e,
  msg_title,
  msg_title_e,
  msg_title_sl,
  priority
FROM satc_ci_cf_p_e
LEFT OUTER JOIN SATC_CI_CF_RT_BASE AS _root ON root_id = _root.root_id  -- association [1..1]
LEFT OUTER JOIN satc_ci_cf_pv_e AS _priority_text ON satc_ci_cf_p_e.priority = _priority_text.priority  -- association [1..1]
LEFT OUTER JOIN satc_ci_cf_pv_e AS _default_priority_text ON satc_ci_cf_p_e.default_priority = _default_priority_text.priority  -- association [1..1]
;