I_MKT_ProductOriginData

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_ProductOriginData.
-- 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_PRODORIGD

CREATE VIEW I_MKT_ProductOriginData AS
SELECT
  cuand_prod_facet.db_key AS ProductOriginDataUUID,
  cast(cuand_prod_facet.parent_key as cuan_cds_product preserving type) AS Product,
  cuand_prod_facet.image_url AS ProductImageURL,
  cuand_prod_facet.nav_url AS WebsiteURL,
  cuand_prod_facet.product_id AS ProductID,
  cuand_prod_facet.product_origin AS ProductOrigin,
  cuand_prod_facet.is_base_product AS IsBaseProduct,
  cuand_prod_facet.base_product_origin AS BaseProductOrigin,
  cuand_prod_facet.base_product_id AS BaseProductID,
  cuand_prod_facet.brand_id AS Brand,
  cuand_prod_facet.valid_to AS ProductValidEndDate,
  cuand_prod_facet.is_additional_product_origin AS ProductOriginDataIsAdditional
FROM cuand_prod_facet
LEFT OUTER JOIN I_MKT_ProductOriginDataText AS _Text ON ProductOriginDataUUID = _Text.ProductOriginDataUUID  -- association [0..*]
LEFT OUTER JOIN I_MKT_Product AS _MKT_Product ON Product = _MKT_Product.Product  -- association [1..1]
LEFT OUTER JOIN I_MKT_ProductMarketingArea AS _MKT_ProductMarketingArea ON Product = _MKT_ProductMarketingArea.ProductUUID association[1..1] to E_MKT_ProductOriginData as _Extension on ProductOriginDataUUID = _Extension.ProductOriginDataUUID  -- association [0..*]
;