I_RetailPromotionItem

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_RetailPromotionItem.
-- 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_RetailPromotionItem AS
SELECT
  aktnr AS RetailPromotion,
  cast(artnr as productnumber preserving type) AS Product,
  mebme AS SalesQuantityUnit,
  akpos AS RetailPromotionItem,
  waela AS PromnPlnItmCurrency,
  plvkp AS PromnPlnItmSalesPrice,
  vpein AS RtlPromotionItemSalesPriceQty,
  reb_value AS RetailPromnDiscountAmount,
  cast( '%' as mebme ) AS QuantityUnit,
  reb_perc AS RetailPromotionDiscountPercent,
  reb_status AS RetailPromotionDiscountStatus,
  pabbm AS PromnPlnItmSalesQuantity,
  waeek AS PromnPlnItmPurchaseCurrency,
  plekp AS PromnPlnItmPurchasePrice,
  no_kalk AS PrcWithoutPrcCalcIsActive,
  activ AS NmbrOfRtlPromnItmPriceActvtn,
  spdat AS RetailPromnItemBlockDate,
  spgru AS RetailPromnBlockingReason,
  vk_aktiv_ab AS RetailPromotionSalesFromDate,
  vk_aktiv_bi AS RetailPromotionSalesToDate,
  pumvp AS PromnPlnItmTotalQtySalesPrice,
  pumep AS PromnPlnItmTotalQtyPurPrice,
  cast(satnr as productnumber preserving type) AS CrossPlantConfigurableProduct,
  matkl AS ProductGroup,
  abeln AS AllocationTable,
  abelp AS AllocationTableItem,
  meauf AS AllocationUnit,
  aufme AS AllocationTableQty,
  erdat AS CreationDate,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aenam AS LastChangedByUser
FROM wakp
LEFT OUTER JOIN I_RetailPromotion AS _RetailPromotion ON RetailPromotion = _RetailPromotion.RetailPromotion  -- association [1..1]
LEFT OUTER JOIN I_RetailPromotionItemStore AS _RetailPromotionItemStore ON RetailPromotion = _RetailPromotionItemStore.RetailPromotion AND Product = _RetailPromotionItemStore.Product AND SalesQuantityUnit = _RetailPromotionItemStore.SalesQuantityUnit  -- association [0..*]
LEFT OUTER JOIN I_RtlPromnBlockingReason AS _RtlPromnBlockingReason ON RetailPromnBlockingReason = _RtlPromnBlockingReason.RetailPromnBlockingReason  -- association [1..1]
LEFT OUTER JOIN I_RtlPromnDiscountStatus AS _RtlPromnDiscountStatus ON RetailPromotionDiscountStatus = _RtlPromnDiscountStatus.RetailPromotionDiscountStatus  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Product AS _GenericProduct ON CrossPlantConfigurableProduct = _GenericProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON SalesQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_ClassHeader AS _ClassHeader ON ProductGroup = _ClassHeader.Class AND _ClassHeader.ClassType = '026'  -- association [0..1]
LEFT OUTER JOIN I_AllocationTable AS _AllocationTable ON AllocationTable = _AllocationTable.AllocationTable  -- association [0..1]
LEFT OUTER JOIN I_AllocationTableItem AS _AllocationTableItem ON AllocationTable = _AllocationTableItem.AllocationTable AND AllocationTableItem = _AllocationTableItem.AllocationTableItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PromnPlnItmCurrency ON PromnPlnItmCurrency = _PromnPlnItmCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PromnPlnItmPurchaseCurrency ON PromnPlnItmPurchaseCurrency = _PromnPlnItmPurchaseCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;