Satc_Ac_Resultvb_Dv

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_Resultvb_Dv.
-- 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: SATC_AC_RSTVB_DV

CREATE VIEW Satc_Ac_Resultvb_Dv AS
SELECT
  display_id,
  obj_name,
  obj_type,
  module_id,
  checksum,
  resp1,
  priority,
  package_name,
  case priority when 1 then 1 else 0 end AS count_prio1,
  case priority when 2 then 1 else 0 end AS count_prio2,
  case priority when 3 then 1 else 0 end AS count_prio3,
  case priority when 4 then 1 else 0 end AS count_prio4,
  timestamp,
  host,
  exc_kind,
  exc_validity,
  exc_approval,
  since,
  sub_index,
  '' AS is_imported
FROM satc_Ac_Rstib_Ddlv
;