EWA_ALY_I_CRV

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 EWA_ALY_I_CRV.
-- 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: EWAALYICRV

CREATE VIEW EWA_ALY_I_CRV AS
SELECT
  vbak.vbeln AS vbeln,
  vbap.posnr AS posnr,
  CN_MAT.matnr AS matnr,
  vbak.kunnr AS kunnr,
  EWAELOC.servloc AS servloc,
  vbak.kvgr1 AS kvgr1,
  vbak.kvgr2 AS kvgr2,
  vbak.kvgr3 AS kvgr3,
  vbak.kvgr4 AS kvgr4,
  vbak.kvgr5 AS kvgr5,
  field.KVGR AS KVGR,
  values.atwrt AS atwrt
FROM vbak
INNER JOIN vbap ON /* join condition not captured in parsed metadata */
INNER JOIN vbap AS VBAP_MA ON /* join condition not captured in parsed metadata */
INNER JOIN ewaelocsd_new AS EWAELOC ON /* join condition not captured in parsed metadata */
INNER JOIN equi AS EQUI ON /* join condition not captured in parsed metadata */
INNER JOIN ewaequi ON /* join condition not captured in parsed metadata */
INNER JOIN etyp AS ETYP ON /* join condition not captured in parsed metadata */
INNER JOIN EWA_ALY_P_CRP AS CN_PST ON /* join condition not captured in parsed metadata */
INNER JOIN EWA_ALY_P_CRM AS CN_MAT ON /* join condition not captured in parsed metadata */
INNER JOIN knvv AS KNVV ON /* join condition not captured in parsed metadata */
INNER JOIN EWA_ALY_P_CRF AS field ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ewav_ibvalues AS values ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN EWA_ALY_I_CRS AS status ON /* join condition not captured in parsed metadata */
INNER JOIN ewav_ibvalues AS values ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN EWA_ALY_P_CRF AS field ON /* join condition not captured in parsed metadata */
INNER JOIN EWA_ALY_P_CRI AS field ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): vbak
;