rfm_psst_assign

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_psst_assign.
-- 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: RFM_PSST_VIEW

CREATE VIEW rfm_psst_assign AS
SELECT
  vbap.vbeln AS vbeln,
  vbap.posnr AS posnr,
  vbap.matnr AS matnr,
  vbap.pstyv AS pstyv,
  vbap.spart AS spart,
  vbap.werks AS werks,
  vbap.vstel AS vstel,
  vbap.meins AS meins,
  vbap.kwmeng AS kwmeng,
  vbap.kbmeng AS kbmeng,
  vbap.klmeng AS klmeng,
  vbap.vrkme AS vrkme,
  vbap.reqqty_bu AS reqqty_bu,
  vbap.lfgsa AS lfgsa,
  vbap.sgt_rcat AS sgt_rcat,
  vbap.fsh_season AS fsh_season,
  vbap.fsh_theme AS fsh_theme,
  vbak.erdat AS erdat,
  vbak.auart AS auart,
  vbak.vkorg AS vkorg,
  vbak.vtweg AS vtweg,
  vbak.kunnr AS kunnr,
  vbep.edatu AS vdatu,
  mara.matkl AS matkl,
  mara.color_atinn AS color_atinn,
  mara.size1_atinn AS size1_atinn,
  mara.size2_atinn AS size2_atinn,
  mara.color AS color,
  mara.size1 AS size1,
  mara.size2 AS size2,
  sum (arun_bdbs.alloc_qty) AS ALLOC_QTY,
  kna1.name1 AS kunnr_name1,
  tvakt.bezei AS BEZEI_AUART,
  TVKOT.vtext AS VTEXT_VKORG,
  tvtwt.vtext AS VTEXT_VTWEG,
  tspat.vtext AS VTEXT_SPART,
  t001w.name1 AS WERKS_NAME1,
  makt.maktx AS maktx
INNER JOIN vbap ON /* join condition not captured in parsed metadata */
INNER JOIN vbep ON /* join condition not captured in parsed metadata */
INNER JOIN mara ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN arun_bdbs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN kna1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvakt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvkot AS TVKOT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvtwt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tspat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001w ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN makt ON /* join condition not captured in parsed metadata */
;