sepm_sddl_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 sepm_sddl_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: SEPM_SDDL_PROD

CREATE VIEW sepm_sddl_product AS
SELECT
  node_key AS product_key,
  product_id,
  type_code,
  category,
  created_at,
  changed_at,
  supplier_guid AS supplier_key,
  measure_unit,
  weight_unit,
  price
FROM snwd_pd
LEFT OUTER JOIN sepm_sddl_employees AS created_by_employee ON created_by_employee_key = created_by_employee.employee_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_employees AS changed_by_employee ON changed_by_employee_key = changed_by_employee.employee_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_text_data AS product_name ON product_name_key = product_name.original_lanuage_key  -- association [1..*]
LEFT OUTER JOIN sepm_sddl_text_data AS product_description ON product_description_key = product_description.original_lanuage_key  -- association [1..*]
LEFT OUTER JOIN sepm_sddl_text_original_langu AS product_name_orig_langu ON product_name_key = product_name_orig_langu.text_original_language_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_text_original_langu AS product_description_orig_langu ON product_description_key = product_description_orig_langu.text_original_language_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_businesspartner AS supplier ON supplier_key = supplier.business_partner_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_product_categories AS main_category ON snwd_pd.category = main_category.category  -- association [0..1]
LEFT OUTER JOIN sepm_sddl_product_conv_factors AS conversion_factor ON product_key = conversion_factor.product_key  -- association [0..*]
LEFT OUTER JOIN sepm_sddl_review_header AS review_header ON product_key = review_header.related_entity_key  -- association [0..1]
LEFT OUTER JOIN tcurc AS currency ON currency_code = waers  -- association [1]
LEFT OUTER JOIN t006 AS measure_unit_code ON measure_unit = msehi  -- association [1]
LEFT OUTER JOIN t006 AS dimension_unit_code ON dim_unit = msehi  -- association [1]
LEFT OUTER JOIN t006 AS weight_unit_code ON weight_unit = msehi  -- association [1]
LEFT OUTER JOIN sepm_sddl_stock AS storage_bins ON product_key = storage_bins.product_key  -- association [0..*]
;