rfm_scc_stocktransfer_basic_V

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_stocktransfer_basic_V.
-- 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: RFMSCCSTOBASICV

CREATE VIEW rfm_scc_stocktransfer_basic_V AS
SELECT
  ekko.ebeln AS ebeln,
  ekko.bsart AS bsart,
  ekko.bstyp AS bstyp,
  ekpo.ebelp AS ebelp,
  ekpo.matnr AS matnr,
  ekpo.sgt_rcat AS sgt_rcat,
  ekpo.sgt_scat AS sgt_scat,
  ekpo.fsh_season AS fsh_season,
  ekpo.fsh_theme AS fsh_theme,
  ekpv.vkorg AS vkorg,
  tvkot.vtext AS vkorg_vtxtk,
  tvtwt.vtext AS vtweg_vtxtk,
  ekpv.vtweg AS vtweg,
  ekpv.spart AS spart,
  tspat.vtext AS spart_vtxtk,
  ekpo.werks AS werks,
  t001w_werks.name1 AS werks_name1,
  ekko.reswk AS reswk,
  t001w_reswk.name1 AS reswk_name1,
  ekpo.menge AS menge,
  ekpo.meins AS meins,
  eket.eindt AS eindt,
  mara.size1 AS size1,
  mara.size2 AS size2,
  mara.color AS color,
  mara.color_atinn AS color_atinn,
  mara.size1_atinn AS size1_atinn,
  mara.size2_atinn AS size2_atinn,
  mara.mtart AS mtart,
  mara.matkl AS matkl,
  mara.attyp AS attyp,
  _ProductDescription.ProductDescription AS maktx,
  _RetailCharacteristicColor.RetailCharacteristicValue AS color_desc,
  _RetailCharacteristicSize1.RetailCharacteristicValue AS size1_desc,
  _RetailCharacteristicSize2.RetailCharacteristicValue AS size2_desc,
  _ProductTypeText.MaterialTypeName AS mtart_mtbez,
  productcategorytext.Name AS attyp_text,
  _ProductGroupText.MaterialGroupName AS matkl_wgbez,
  _purchasingdocumenttypetext.PurchasingDocumentTypeName AS bsart_batxt
FROM ekko
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekpv ON /* join condition not captured in parsed metadata */
INNER JOIN eket ON /* join condition not captured in parsed metadata */
INNER JOIN mara ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductDescription AS _ProductDescription ON matnr = _ProductDescription.Product AND _ProductDescription.Language = $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 AS t001w_werks ON werks = t001w_werks.werks  -- association [1..1]
LEFT OUTER JOIN t001w AS t001w_reswk ON reswk = t001w_reswk.werks  -- 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 I_PurchasingDocumentTypeText AS _purchasingdocumenttypetext ON bsart = _purchasingdocumenttypetext.PurchasingDocumentType AND bstyp = _purchasingdocumenttypetext.PurchasingDocumentCategory AND _purchasingdocumenttypetext.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]
;