CUAN_IA_READ_COMMERCE_UI

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_IA_READ_COMMERCE_UI.
-- 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: CUANIAREADCMRC

CREATE VIEW CUAN_IA_READ_COMMERCE_UI AS
SELECT
  ia_prod_key,
  IA_KEY,
  contact_key,
  ia_reason,
  IA_REASON_T,
  ia_status,
  object_id AS product_id,
  product_key,
  quantity,
  timestamp,
  ADD_CONTACT_KEY,
  target_currency AS currency,
  COUNTRY,
  mkt_area_id,
  _ProductDesc.description AS product_desc,
  _ProductDesc.name AS product_name
FROM CUAN_IA_READ_UI
LEFT OUTER JOIN tcurt AS _InteractionTargetCurrencyT ON currency = _InteractionTargetCurrencyT.waers AND _InteractionTargetCurrencyT.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tcurt AS _InteractionOriginalCurrencyT ON original_currency = _InteractionOriginalCurrencyT.waers AND _InteractionOriginalCurrencyT.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN t006a AS _InteractionProductUoM ON unit_of_measure_int = _InteractionProductUoM.msehi AND _InteractionProductUoM.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN dd07t AS _InteractionStatus ON ia_status = _InteractionStatus.domvalue_l AND _InteractionStatus.ddlanguage = $session.system_language AND _InteractionStatus.domname = 'CUAN_CE_IA_STATUS' AND _InteractionStatus.as4local = 'A'  -- association [0..1]
LEFT OUTER JOIN cuand_prod_root AS _ProductRoot ON product_key = _ProductRoot.db_key  -- association [0..1]
LEFT OUTER JOIN cuand_prod_desc AS _ProductDesc ON product_key = _ProductDesc.parent_key AND _ProductDesc.langu = $session.system_language  -- association [0..1]
;