C_SeasonAssignedDownload

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 C_SeasonAssignedDownload.
-- 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.

CREATE VIEW C_SeasonAssignedDownload AS
SELECT
  product.Product AS Product,
  SeasonProduct.ProductSeasonYear AS ProductSeasonYear,
  SeasonProduct.ProductSeason AS ProductSeason,
  SeasonProduct.ProductCollection AS ProductCollection,
  SeasonProduct.ProductTheme AS ProductTheme,
  product._Text[1: Language=$session.system_language].ProductName AS ProductDescription,
  product.ProductCharacteristic1 AS ProductCharacteristic1,
  product._RetProdCharc1Text[1: Language=$session.system_language].RetailCharacteristicValueDesc AS ProductCharacteristic1Desc,
  product.ProductCharacteristic2 AS ProductCharacteristic2,
  product._RetProdCharc2Text[1: Language=$session.system_language].RetailCharacteristicValueDesc AS ProductCharacteristic2Desc,
  product.ProductCharacteristic3 AS ProductCharacteristic3,
  product._RetProdCharc3Text[1: Language=$session.system_language].RetailCharacteristicValueDesc AS ProductCharacteristic3Desc,
  product.ProductCategory AS ProductCategory,
  product._ProductCategory._Text[1: Language=$session.system_language].Name AS ProductCategoryName,
  SeasonProduct.ProductSeasonInternalUUID AS ProductSeasonInternalUUID
FROM I_SeasonProduct AS SeasonProduct
LEFT OUTER JOIN C_ProductBasicInfo AS _ProductInfo ON Product = _ProductInfo.Product  -- association [0..1]
;