snap_authorized

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 snap_authorized.
-- 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: SNAP_AUTH

CREATE VIEW snap_authorized AS
SELECT
  s.datum AS datum,
  s.uzeit AS uzeit,
  s.ahost AS ahost,
  s.uname AS uname,
  s.mandt AS mandt,
  s.modno AS modno,
  s.seqno AS seqno,
  s.xhold AS xhold,
  s.flist AS flist,
  s.flist02 AS flist02,
  s.flist03 AS flist03,
  s.flist04 AS flist04,
  s.flist05 AS flist05,
  s.flist06 AS flist06,
  s.flist07 AS flist07,
  s.flist08 AS flist08
FROM snap AS s
LEFT OUTER JOIN snap_adt AS a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr_attr_id AS u ON /* join condition not captured in parsed metadata */
;