I_MKT_InteractionProduct

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_InteractionProduct.
-- 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.

CREATE VIEW I_MKT_InteractionProduct AS
SELECT
  cast (Persistence.db_key as cuan_cds_ia_product preserving type) AS InteractionProductUUID,
  cast (Persistence.parent_key as cuan_cds_interaction preserving type) AS InteractionUUID,
  Persistence.object_id AS Product,
  product_quantifier AS InteractionProdWeightingFactor,
  Persistence.amount AS InteractionProductAmount,
  quantity AS InteractionProductQuantity,
  unit_of_measure AS InteractionProductUnit,
  ia_prod_status AS InteractionProductStatus,
  ia_prod_reason AS InteractionProductReason,
  '' AS ProductName,
  _MKT_Interaction.Currency AS Currency
FROM cuand_ce_ia_prod AS Persistence
LEFT OUTER JOIN I_MKT_Interaction AS _MKT_Interaction ON InteractionUUID = _MKT_Interaction.Interaction  -- association [1..1]
LEFT OUTER JOIN E_MKT_IA_PRODUCT AS _Extension ON Persistence.db_key = _Extension.InteractionProduct  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON InteractionProductUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;