rfm_mm_seasons_basic_view

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 rfm_mm_seasons_basic_view.
-- 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: RFMMMSEABASIC_V

CREATE VIEW rfm_mm_seasons_basic_view AS
SELECT
  v_ekko.mandt AS mandt,
  v_ekko.ebeln AS ebeln,
  v_ekpo.ebelp AS ebelp,
  v_eket.eindt AS eindt,
  v_ekko.bedat AS bedat,
  v_ekpo.matnr AS matnr,
  v_mara.satnr AS satnr,
  v_ekpo.sgt_scat AS sgt_scat,
  v_ekpo.fsh_season AS fsh_season,
  v_ekpo.fsh_theme AS fsh_theme,
  v_ekpv.vkorg AS vkorg,
  v_ekpv.vtweg AS vtweg,
  v_ekpv.kunnr AS kunnr,
  v_kna1.land1 AS land1,
  v_kna1.regio AS regio
FROM ekko AS v_ekko
INNER JOIN ekpo AS v_ekpo ON /* join condition not captured in parsed metadata */
INNER JOIN eket AS v_eket ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS v_mara ON /* join condition not captured in parsed metadata */
INNER JOIN ekpv AS v_ekpv ON /* join condition not captured in parsed metadata */
INNER JOIN kna1 AS v_kna1 ON /* join condition not captured in parsed metadata */
INNER JOIN t001w AS v_t001w ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN knvv AS v_knvv ON /* join condition not captured in parsed metadata */
;