I_EWM_ProductSearchModel_2

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_2.
-- 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_2 AS
SELECT
  WarehouseProduct.matid AS ProdSupChnMgmtUUID22,
  WarehouseProduct.scuguid AS SupplyChainUnitUUID,
  WarehouseProduct.entitled_id AS BusinessPartnerUUID,
  Product.matnr AS Product,
  BusinessPartner.partner AS BusinessPartner,
  AssgWhseBusinessPartner.lgnum AS EWMWarehouse,
  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,
  WarehouseProduct.put_stra AS EWMPtwyControlStrategy,
  WarehouseProduct.rem_stra AS EWMStockRemovalControlStrategy,
  WarehouseProduct.block AS EWMBulkStorageMethod,
  WarehouseProduct.ccind AS EWMPhysInventoryCountingCycle
FROM /sapapo/matlwh AS WarehouseProduct
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumberText_2 AS _WarehouseText ON EWMWarehouse = _WarehouseText.EWMWarehouse  -- association [0..*]
LEFT OUTER JOIN I_ProductTypeText_2 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_EWM_PtwyControlStrategyText AS _PtwyControlStrategyText ON EWMWarehouse = _PtwyControlStrategyText.EWMWarehouse AND EWMPtwyControlStrategy = _PtwyControlStrategyText.EWMPtwyControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_EWM_StkRemovalCtrlStrgyText AS _StkRemovalCtrlStrgyText ON EWMWarehouse = _StkRemovalCtrlStrgyText.EWMWarehouse AND EWMStockRemovalControlStrategy = _StkRemovalCtrlStrgyText.EWMStockRemovalControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_EWM_BulkStorageMethodText AS _BulkStorageMethodText ON EWMWarehouse = _BulkStorageMethodText.EWMWarehouse AND EWMBulkStorageMethod = _BulkStorageMethodText.EWMBulkStorageMethod  -- association [0..*]
LEFT OUTER JOIN E_ProdEWMWarehouse AS _Extension ON ProdSupChnMgmtUUID22 = _Extension.ProdSupChnMgmtUUID22 AND SupplyChainUnitUUID = _Extension.SupplyChainUnitUUID AND BusinessPartnerUUID = _Extension.BusinessPartnerUUID  -- association [0..1]
;