FNDEI_QAMR_FILTER

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 FNDEI_QAMR_FILTER.
-- 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: FNDEIFQAMR

CREATE VIEW FNDEI_QAMR_FILTER AS
SELECT
  qamr.mandant AS mandant,
  qamr.prueflos AS prueflos,
  qamr.vorglfnr AS vorglfnr,
  qamr.merknr AS merknr,
  qamr.satzstatus AS satzstatus,
  qamr.attribut AS attribut,
  qamr.qergdath AS qergdath,
  qamr.ersteller AS ersteller,
  qamr.erstelldat AS erstelldat,
  qamr.aenderer AS aenderer,
  qamr.aenderdat AS aenderdat,
  qamr.dbewertg AS dbewertg,
  qamr.mbewertg AS mbewertg,
  qamr.pruefer AS pruefer,
  qamr.pruefdatuv AS pruefdatuv,
  qamr.pruefdatub AS pruefdatub,
  qamr.pruefzeitv AS pruefzeitv,
  qamr.pruefzeitb AS pruefzeitb,
  qamr.pruefbemkt AS pruefbemkt,
  qamr.prltextkz AS prltextkz,
  qamr.ltextspr AS ltextspr,
  qamr.iststpanz AS iststpanz,
  qamr.iststpumf AS iststpumf,
  qamr.anzfehleh AS anzfehleh,
  qamr.anteilni AS anteilni,
  qamr.anteil AS anteil,
  qamr.anzfehler AS anzfehler,
  qamr.anzwerto AS anzwerto,
  qamr.anzwertu AS anzwertu,
  qamr.anzwertg AS anzwertg,
  qamr.maxwertni AS maxwertni,
  qamr.medianni AS medianni,
  qamr.minwertni AS minwertni,
  qamr.mittelwni AS mittelwni,
  qamr.varianzni AS varianzni,
  qamr.moment3ni AS moment3ni,
  qamr.moment4ni AS moment4ni,
  qamr.anteiloni AS anteiloni,
  qamr.anteiluni AS anteiluni,
  qamr.maxwert AS maxwert,
  qamr.medianwert AS medianwert,
  qamr.minwert AS minwert,
  qamr.mittelwert AS mittelwert,
  qamr.varianz AS varianz,
  qamr.moment3 AS moment3,
  qamr.moment4 AS moment4,
  qamr.anteilo AS anteilo,
  qamr.anteilu AS anteilu,
  qamr.guelstpanz AS guelstpanz,
  qamr.ivarianzni AS ivarianzni,
  qamr.ivarianz AS ivarianz,
  qamr.katalgart1 AS katalgart1,
  qamr.gruppe1 AS gruppe1,
  qamr.code1 AS code1,
  qamr.version1 AS version1,
  qamr.katalgart2 AS katalgart2,
  qamr.gruppe2 AS gruppe2,
  qamr.code2 AS code2,
  qamr.version2 AS version2,
  qamr.katalgart3 AS katalgart3,
  qamr.gruppe3 AS gruppe3,
  qamr.code3 AS code3,
  qamr.version3 AS version3,
  qamr.katalgart4 AS katalgart4,
  qamr.gruppe4 AS gruppe4,
  qamr.code4 AS code4,
  qamr.version4 AS version4,
  qamr.katalgart5 AS katalgart5,
  qamr.gruppe5 AS gruppe5,
  qamr.code5 AS code5,
  qamr.version5 AS version5,
  qamr.fehlklas AS fehlklas,
  qamr.sendeflag AS sendeflag,
  qamr.maschine AS maschine,
  qamr.position AS position,
  qamr.aendbeleg AS aendbeleg,
  qamr.kzbewertg AS kzbewertg,
  qamr.zeiterstl AS zeiterstl,
  qamr.zeitaend AS zeitaend,
  qamr.kzverdicht AS kzverdicht,
  qamr.sign_id AS sign_id,
  qamr.sign_state AS sign_state
FROM qamr
INNER JOIN FNDEI_QAMR_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;