I_EWM_ProductSearchModel

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_EWM_ProductSearchModel.
-- 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_EWM_ProductSearchModel AS
SELECT
  ProductEWMWarehouse.matid AS ProductUUID,
  ProductEWMWarehouse.scuguid AS SupplyChainUnitUUID,
  ProductEWMWarehouse.entitled_id AS BusinessPartnerUUID,
  Product.matnr AS Product,
  BusinessPartner.partner AS BusinessPartner,
  AssgWhseBusinessPartner.lgnum AS Warehouse,
  Product.matnr_external AS ProductExternalID,
  Product.mtart AS ProductType,
  Product.matkl AS ProductGroup,
  Product.meins AS ProductBaseUnit,
  Product.ntgew AS ProductNetWeight,
  Product.brgew AS ProductGrossWeight,
  Product.gewei AS WeightUnit,
  Product.volum AS ProductVolume,
  Product.voleh AS VolumeUnit,
  BusinessPartner.xpcpt AS IsBusinessPurposeCompleted,
  ProductEWMWarehouse.put_stra AS EWMPtwyControlStrategy,
  ProductEWMWarehouse.rem_stra AS EWMStockRemovalControlStrategy,
  ProductEWMWarehouse.block AS ProductBulkStorageMethod,
  ProductEWMWarehouse.ccind AS EWMPhysInventoryCountingCycle
FROM /sapapo/matlwh AS ProductEWMWarehouse
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_EWM_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumberText AS _WarehouseText ON Warehouse = _WarehouseText.Warehouse  -- association [0..*]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeText ON ProductType = _ProductTypeText.ProductType  -- association [0..*]
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText ON ProductGroup = _ProductGroupText.ProductGroup  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _BaseUnitOfMeasureText ON ProductBaseUnit = _BaseUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _WeightUnitOfMeasureText ON WeightUnit = _WeightUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _VolumeUnitOfMeasureText ON VolumeUnit = _VolumeUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMPtwyCtrlStrgyText AS _PutawayCtrlStrategyText ON Warehouse = _PutawayCtrlStrategyText.Warehouse AND EWMPtwyControlStrategy = _PutawayCtrlStrategyText.EWMPtwyControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMStkRemovalCtrlTxt AS _StockRemovalCtrlStrategyText ON Warehouse = _StockRemovalCtrlStrategyText.Warehouse AND EWMStockRemovalControlStrategy = _StockRemovalCtrlStrategyText.EWMStockRemovalControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMBulkStorMethText AS _ProductBulkStorageMethodText ON Warehouse = _ProductBulkStorageMethodText.Warehouse AND ProductBulkStorageMethod = _ProductBulkStorageMethodText.ProductBulkStorageMethod  -- association [0..*]
;