TMAS_OLA_SR

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 TMAS_OLA_SR.
-- 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: TMAS_OLA_V_SR

CREATE VIEW TMAS_OLA_SR AS
SELECT
  sr1.objtype AS objtype,
  sr1.objname AS objname,
  wrk.wlistid AS worklist_id,
  sr1.domanam AS domanam,
  sr1.domatyp AS domatyp,
  sr1.collnam AS coll_name,
  sr1.colltyp AS coll_type,
  att.tcnttyp AS tcnttyp,
  sr1.total_word AS total_word,
  sr1.nomatch_word AS nomatch_word,
  sr1.m100_word AS m100_word,
  sr1.m9599_word AS m9599_word,
  sr1.m8594_word AS m8594_word,
  sr1.m7584_word AS m7584_word,
  sr1.m5074_word AS m5074_word,
  wrk.stattrn AS STATTRN
LEFT OUTER JOIN tmas_ola_d_sr14 AS sr2 ON /* join condition not captured in parsed metadata */
INNER JOIN LXE_WRK_ALL AS wrk ON /* join condition not captured in parsed metadata */
;