rfm_scc_salesorder_data_basic

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_scc_salesorder_data_basic.
-- 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: RFMSCCSOBASICV

CREATE VIEW rfm_scc_salesorder_data_basic AS
SELECT
  vbeln,
  posnr,
  kunnr,
  auart,
  vkorg,
  vtweg,
  fsh_candate,
  fsh_season,
  fsh_theme,
  matnr,
  kwmeng,
  vrkme,
  werks,
  spart,
  size1,
  size2,
  color,
  color_atinn,
  size1_atinn,
  size2_atinn,
  mtart,
  matkl,
  attyp,
  shiptoparty,
  edatu,
  sgt_rcat,
  _productcategorytext.Name AS attyp_text,
  _ProductDescription.ProductDescription AS maktx,
  _ProductGroupText.MaterialGroupName AS matkl_wgbez,
  _RetailCharacteristicColor.RetailCharacteristicValue AS color_desc,
  _RetailCharacteristicSize1.RetailCharacteristicValue AS size1_desc,
  _RetailCharacteristicSize2.RetailCharacteristicValue AS size2_desc,
  _ProductTypeText.MaterialTypeName AS mtart_mtbez,
  tvkot.vtext AS vkorg_vtxtk,
  tvtwt.vtext AS vtweg_vtxtk,
  tspat.vtext AS spart_vtxtk,
  t001w.name1 AS werks_name1,
  kna1_vbak.CustomerName AS kunnr_name1,
  tvakt.bezei AS auart_bezei
FROM rfm_scc_salesdata_basic_V
LEFT OUTER JOIN I_ProductDescription AS _ProductDescription ON matnr = _ProductDescription.Product AND _ProductDescription.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN tvakt ON auart = tvakt.auart AND tvakt.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN tvkot ON vkorg = tvkot.vkorg AND tvkot.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN tvtwt ON vtweg = tvtwt.vtweg AND tvtwt.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN tspat ON spart = tspat.spart AND tspat.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN t001w ON werks = t001w.werks  -- association [1..1]
LEFT OUTER JOIN I_Customer AS kna1_vbak ON kunnr = kna1_vbak.Customer  -- association [1..1]
LEFT OUTER JOIN I_Customer AS kna1_shipto ON shiptoparty = kna1_shipto.Customer  -- association [1..1]
LEFT OUTER JOIN rfm_Scc_season_text AS season_text ON fsh_season_year = season_text.fsh_season_year AND fsh_season = season_text.fsh_season AND fsh_collection = season_text.fsh_collection AND fsh_theme = season_text.fsh_theme  -- association [1..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _RetailCharacteristicColor ON color_atinn = _RetailCharacteristicColor.CharacteristicInternalID AND color = _RetailCharacteristicColor.RetailCharacteristicValue AND _RetailCharacteristicColor.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _RetailCharacteristicSize1 ON size1_atinn = _RetailCharacteristicSize1.CharacteristicInternalID AND size1 = _RetailCharacteristicSize1.RetailCharacteristicValue AND _RetailCharacteristicSize1.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _RetailCharacteristicSize2 ON size2_atinn = _RetailCharacteristicSize2.CharacteristicInternalID AND size2 = _RetailCharacteristicSize2.RetailCharacteristicValue AND _RetailCharacteristicSize2.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeText ON mtart = _ProductTypeText.ProductType AND _ProductTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProductCategoryText AS _productcategorytext ON attyp = _productcategorytext.ProductCategory AND _productcategorytext.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON matkl = _ProductGroupText.MaterialGroup AND _ProductGroupText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN rfm_scc_season_indicator_text AS _SCCSeasonIndicatorText ON seasoncompletenessindicator = _SCCSeasonIndicatorText.value AND _SCCSeasonIndicatorText.language = $session.system_language  -- association [1..1]
;