I_MKT_Product

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 I_MKT_Product.
-- 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: IMKT_PRODUCT

CREATE VIEW I_MKT_Product AS
SELECT
  cast (cuand_prod_root.db_key as cuan_cds_product preserving type) AS Product,
  cuand_prod_root.image_url AS ProductImageURL,
  cuand_prod_root.nav_url AS WebsiteURL,
  cuand_prod_root.brand_id AS Brand,
  cuand_prod_root.base_product_id AS BaseProductID,
  cuand_prod_root.base_product_origin AS BaseProductOrigin,
  cuand_prod_root.is_base_product AS IsBaseProduct,
  cuand_prod_root.prod_variant_type AS ProductVariantType,
  cuand_prod_root.valid_to AS ProductValidEndDate,
  cuand_prod_facet.product_id AS ProductID,
  cuand_prod_facet.product_origin AS ProductOrigin
FROM cuand_prod_root
LEFT OUTER JOIN I_MKT_ProductText AS _Text ON Product = _Text.Product  -- association [0..*]
LEFT OUTER JOIN I_MKT_ProductOriginData AS _MKT_BaseProductOriginData ON BaseProductID = _MKT_BaseProductOriginData.ProductID AND BaseProductOrigin = _MKT_BaseProductOriginData.ProductOrigin  -- association [0..1]
LEFT OUTER JOIN I_MKT_Brand AS _MKT_Brand ON Brand = _MKT_Brand.Brand  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProductCatAssignment AS _MKT_ProductCatAssignment ON Product = _MKT_ProductCatAssignment.Product  -- association [0..*]
LEFT OUTER JOIN I_MKT_ProductVariantType AS _MKT_ProductVariantType ON ProductVariantType = _MKT_ProductVariantType.ProductVariantType  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProductOrigin AS _MKT_ProductOrigin ON ProductOrigin = _MKT_ProductOrigin.ProductOrigin  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProductMarketingArea AS _MKT_ProductMarketingArea ON Product = _MKT_ProductMarketingArea.ProductUUID association[1..1] to E_MKT_PRODUCT as _Extension on cuand_prod_root.db_key = _Extension.Product  -- association [0..*]
;