CUAN_IA_ABANDONED_SC

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_ABANDONED_SC.
-- 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_IAASC

CREATE VIEW CUAN_IA_ABANDONED_SC AS
SELECT
  AbandonedShoppingCart AS DB_KEY,
  RequestedInteractionKey AS REQUEST_KEY,
  _MKT_Interaction.RootInteraction AS ROOT_KEY,
  _MKT_Interaction.InteractionType AS IA_TYPE,
  _MKT_Interaction.InteractionSourceDataURL AS SOURCE_DATA_URL,
  _MKT_Interaction.InteractionTimeStampUTC AS TIMESTAMP,
  _MKT_Interaction.Currency AS TOTAL_AMOUNT_CURRENCY,
  _MKT_Interaction.InteractionAmount AS TOTAL_AMOUNT,
  _MKT_Interaction.PrecedingInteractionUUID AS PARENT_KEY,
  _MKT_InteractionProduct.InteractionProductUUID AS IA_PROD_KEY,
  _MKT_InteractionProduct.ProductUUID AS PRODUCT_KEY,
  _MKT_InteractionProduct.Product AS PRODUCT_ID,
  _MKT_InteractionProduct._MKT_Product._Text[1: Language=$session.system_language].ProductDescription AS DESCRIPTION,
  _MKT_InteractionProduct._MKT_Product._Text[1: Language=$session.system_language].ProductName AS NAME,
  _MKT_InteractionProduct._MKT_Product.ProductValidEndDate AS VALID_TO,
  _MKT_InteractionProduct.InteractionSourceItemNumber AS SOURCE_ITEM_NO,
  _MKT_InteractionProduct.ProductOrigin AS PRODUCT_ORIGIN,
  _MKT_InteractionProduct._MKT_Product.ProductImageURL AS IMAGE_URL,
  _MKT_InteractionProduct._MKT_Product.WebsiteURL AS NAV_URL,
  _MKT_Interaction.Currency AS CURRENCY,
  _MKT_InteractionProduct.InteractionProductAmount AS AMOUNT,
  _MKT_InteractionProduct.InteractionProductQuantity AS QUANTITY,
  _MKT_InteractionProduct.InteractionProductUnit AS UNIT_OF_MEASURE,
  _MKT_InteractionProduct._MKT_Product._Text.Language AS LANGUAGE
FROM CUAN_IA_ABANDONED_SC_BASE AS _Mkt_ASC_Interaction
LEFT OUTER JOIN I_Mkt_Interaction AS _MKT_Interaction ON DB_KEY = _MKT_Interaction.Interaction  -- association [1..1]
LEFT OUTER JOIN I_MKT_InteractionProduct AS _MKT_InteractionProduct ON DB_KEY = _MKT_InteractionProduct.InteractionUUID  -- association [0..*]
LEFT OUTER JOIN E_MKT_IA_PRODUCT AS _ExtensionIAProd ON DB_KEY = _ExtensionIAProd.InteractionProduct  -- association [1..1]
LEFT OUTER JOIN E_MKT_PRODUCT AS _ExtensionProd ON DB_KEY= _ExtensionProd.Product  -- association [1..1]
LEFT OUTER JOIN E_MKT_INTERACTION AS _ExtensionIA ON DB_KEY = _ExtensionIA.Interaction  -- association [1..1]
;