RFM_SD_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_SD_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: RFMSEABASIC_V

CREATE VIEW RFM_SD_SEASONS_BASIC_VIEW AS
SELECT
  V.mandt AS mandt,
  V.vbeln AS vbeln,
  V1.posnr AS posnr,
  V2.edatu AS edatu,
  M.matnr AS matnr,
  M.satnr AS satnr,
  V.vkorg AS vkorg,
  V.vtweg AS vtweg,
  K.land1 AS land1,
  K.regio AS regio,
  VB.kdgrp AS kdgrp,
  VB.bzirk AS bzirk,
  V.kunnr AS kunnr,
  V1.fsh_season AS fsh_season,
  V1.fsh_theme AS fsh_theme,
  V.audat AS audat,
  V1.sgt_rcat AS sgt_rcat
FROM vbak AS V
INNER JOIN vbap AS V1 ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS M ON /* join condition not captured in parsed metadata */
INNER JOIN vbep AS V2 ON /* join condition not captured in parsed metadata */
INNER JOIN kna1 AS K ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbkd AS VB ON /* join condition not captured in parsed metadata */
;