CUAN_PRODUCT_SEARCH

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 CUAN_PRODUCT_SEARCH.
-- 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: CUAN_PRODUCT_SEA

CREATE VIEW CUAN_PRODUCT_SEARCH AS
SELECT
  cuand_prod_root.mandt AS MANDT,
  cuand_prod_root.mandt AS HPA_CLIENT,
  cuand_prod_root.db_key AS PRODUCT_KEY,
  cuand_prod_root.image_url AS IMAGE_URL,
  cuand_prod_root.nav_url AS NAV_URL,
  cuand_prod_root.brand_id AS BRAND_ID,
  cuand_prod_root.is_base_product AS IS_BASE_PRODUCT,
  cuand_prod_root.prod_variant_type AS PROD_VARIANT_TYPE,
  cuand_prod_root.base_product_id AS BASE_PRODUCT_ID,
  cuand_prod_root.base_product_origin AS BASE_PRODUCT_ORIGIN,
  cuand_prod_root.valid_to AS VALID_TO,
  cuand_prod_root.product_oid AS PRODUCT_OID,
  cuand_prod_root.boolean1 AS BOOLEAN1,
  cuand_prod_root.boolean2 AS BOOLEAN2,
  cuand_prod_root.boolean3 AS BOOLEAN3,
  cuand_prod_root.boolean4 AS BOOLEAN4,
  cuand_prod_root.boolean5 AS BOOLEAN5,
  cuand_prod_root.boolean6 AS BOOLEAN6,
  cuand_prod_root.date1 AS DATE1,
  cuand_prod_root.date2 AS DATE2,
  cuand_prod_root.date3 AS DATE3,
  cuand_prod_root.number1 AS NUMBER1,
  cuand_prod_root.number2 AS NUMBER2,
  cuand_prod_root.number3 AS NUMBER3,
  cuand_prod_root.number4 AS NUMBER4,
  cuand_prod_root.timestamp1 AS TIMESTAMP1,
  cuand_prod_root.timestamp2 AS TIMESTAMP2,
  cuand_prod_root.decimal1 AS DECIMAL1,
  cuand_prod_root.decimal2 AS DECIMAL2,
  cuand_prod_root.decimal3 AS DECIMAL3,
  cuand_prod_root.decimal4 AS DECIMAL4,
  cuand_prod_root.text40_1 AS TEXT40_1,
  cuand_prod_root.text40_2 AS TEXT40_2,
  cuand_prod_root.text120_1 AS TEXT120_1,
  cuand_prod_root.text120_2 AS TEXT120_2,
  cuand_prod_root.text255_1 AS TEXT255_1,
  cuand_prod_root.text255_2 AS TEXT255_2,
  cuand_prod_root.quantity1 AS QUANTITY1,
  cuand_prod_root.unit_of_measure1 AS UNIT_OF_MEASURE1,
  cuand_prod_root.amount1 AS AMOUNT1,
  cuand_prod_root.amount2 AS AMOUNT2,
  cuand_prod_root.currency AS CURRENCY,
  cuand_prod_root.cuan_e_prod_rt AS CUAN_E_PROD_RT,
  cuand_prod_desc.name AS NAME,
  cuand_prod_desc.description AS DESCRIPTION,
  cuand_prod_desc.long_description AS LONG_DESCRIPTION,
  cuand_prod_facet.product_id AS PRODUCT_ID,
  cuand_prod_facet.product_origin AS PRODUCT_ORIGIN,
  cuand_prod_mkta.mkt_area_id AS MKT_AREA_ID,
  _MKT_ProductCatAssignment.ProductCategoryUUID AS CATEGORY_KEY,
  _MKT_ProductCatAssignment._MKT_ProductCategory.ProductCategory AS CATEGORY_ID,
  _MKT_ProductCatAssignment._MKT_ProductCategory.ProductCategoryHierarchy AS HIERARCHY_ID,
  _MKT_ProductCatAssignment._MKT_ProductCategory._Text[1: Language=$session.system_language].ProductCategoryName AS CATEGORY_NAME,
  _MKT_BaseProductOriginData._MKT_Product._Text[1: Language=$session.system_language].ProductName AS BASE_PRODUCT_NAME,
  _MKT_ProductVariantType._Text[1: Language=$session.system_language].ProductVariantTypeName AS PROD_VARIANT_TYPE_NAME,
  _MKT_Brand._Text[1: Language=$session.system_language].BrandName AS BRAND_NAME
FROM cuand_prod_root
LEFT OUTER JOIN cuand_prod_desc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuand_prod_mkta ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_ProductOriginData AS _MKT_BaseProductOriginData ON cuand_prod_root.base_product_id = _MKT_BaseProductOriginData.ProductID AND cuand_prod_root.base_product_origin = _MKT_BaseProductOriginData.ProductOrigin  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProductVariantType AS _MKT_ProductVariantType ON cuand_prod_root.prod_variant_type = _MKT_ProductVariantType.ProductVariantType  -- association [0..1]
LEFT OUTER JOIN I_MKT_Brand AS _MKT_Brand ON cuand_prod_root.brand_id = _MKT_Brand.Brand  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProductCatAssignment AS _MKT_ProductCatAssignment ON cuand_prod_root.db_key = _MKT_ProductCatAssignment.Product association[1..1] to E_MKT_PRODUCT as _Extension on PRODUCT_KEY = _Extension.Product  -- association [0..*]
;