I_EWM_ProductWarehouse

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_ProductWarehouse.
-- 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_ProductWarehouse AS
SELECT
  ProductEWMWarehouse.matid AS ProductInternalUUID,
  ProductEWMWarehouse.scuguid AS SupplyChainUnitUUID,
  ProductEWMWarehouse.entitled_id AS EWMPartyEntitledToDisposeUUID,
  _Product[inner].Product AS Product,
  _BusinessPartner[inner].BusinessPartner AS BusinessPartner,
  _AssgWhseBusinessPartner[inner].EWMWarehouse AS EWMWarehouse,
  ProductEWMWarehouse.procprfl AS EWMProductProcessBlockProfile,
  ProductEWMWarehouse.ptdetind AS EWMWarehouseProcessType,
  ProductEWMWarehouse.ptdetind AS EWMProcessTypeControlCode,
  ProductEWMWarehouse.wrkldgr AS EWMProductLoadCategory,
  ProductEWMWarehouse.ccind AS EWMPhysInventoryCountingCycle,
  cast( ProductEWMWarehouse.slrq_min as cmd_prd_shelf_life_req_min_n preserving type ) AS RequiredMinShelfLife,
  ProductEWMWarehouse.backflush_prod AS EWMProdBackflushWthdrwlMethod,
  ProductEWMWarehouse.kit_fixed_quan AS EWMKitQuantityCorrelation,
  ProductEWMWarehouse.vasvcp AS EWMIsCnsmpnRlvtForValAddedSrvc,
  ProductEWMWarehouse.medi_aprof_wh AS EWMQuantityAdjustmentProfile,
  ProductEWMWarehouse.quancla_merch AS EWMMrchdsDistrQtyClassfctn,
  ProductEWMWarehouse.puom_wh AS PreferredUnitOfMeasure,
  ProductEWMWarehouse.puom_wh AS EWMPreferredUnit,
  ProductEWMWarehouse.qgrp_wh AS EWMQualityInspectionGroup,
  ProductEWMWarehouse.put_stra AS EWMPtwyControlStrategy,
  ProductEWMWarehouse.lptyp AS EWMStorageBinType,
  ProductEWMWarehouse.block AS EWMBulkStorageMethod,
  ProductEWMWarehouse.lgbkz AS EWMStorageSectionMethod,
  ProductEWMWarehouse.rem_stra AS EWMStockRemovalControlStrategy,
  ProductEWMWarehouse.stckdetgr AS EWMStockDeterminationGroup,
  ProductEWMWarehouse.l2skr AS EWMProdTwoStepPickingRelevant,
  ProductEWMWarehouse.drdetgr AS EWMStggAreaDeterminationGroup,
  _Product[inner].BaseUnit AS BaseUnit,
  _Product[inner]._BaseUnitOfMeasure AS _BaseUnitOfMeasure,
  ProductEWMWarehouse.demqty AS EWMSltgRequirementQuantity,
  ProductEWMWarehouse.nosoi AS EWMSltgNumberOfSalesOrderItems,
  ProductEWMWarehouse.rsqty AS EWMSltgRecmddStorageQuantity,
  ProductEWMWarehouse.wghtind AS EWMSlottingWeightSizeCode,
  ProductEWMWarehouse.volind AS EWMSlottingVolumeSizeCode,
  ProductEWMWarehouse.lgthind AS EWMSlottingLengthSizeCode,
  ProductEWMWarehouse.wdthind AS EWMSlottingWidthSizeCode,
  ProductEWMWarehouse.hghtind AS EWMSlottingHeightSizeCode
FROM /sapapo/matlwh AS ProductEWMWarehouse
LEFT OUTER JOIN I_Product AS _Product ON ProductInternalUUID = _Product.ProdSupChnMgmtUUID22  -- association [1..1]
LEFT OUTER JOIN I_EWM_AssgWhseBusPartner_2 AS _AssgWhseBusinessPartner ON SupplyChainUnitUUID = _AssgWhseBusinessPartner.SupplyChainUnitUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON EWMPartyEntitledToDisposeUUID = _BusinessPartner.BusinessPartnerUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerNumber ON businesspartner = _BusinessPartnerNumber.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _WarehouseNumber ON EWMWarehouse = _WarehouseNumber.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumberText_2 AS _WarehouseNumberText ON EWMWarehouse = _WarehouseNumberText.EWMWarehouse  -- association [0..*]
LEFT OUTER JOIN I_EWM_ProcessBlockProfile AS _ProductProcessBlockProfile ON EWMWarehouse = _ProductProcessBlockProfile.EWMWarehouse AND EWMProductProcessBlockProfile = _ProductProcessBlockProfile.EWMProcessBlockProfile  -- association [0..1]
LEFT OUTER JOIN I_EWM_ProcessBlockProfileText AS _ProcessBlockProfileText ON EWMWarehouse = _ProcessBlockProfileText.EWMWarehouse AND EWMProductProcessBlockProfile = _ProcessBlockProfileText.EWMProcessBlockProfile  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseProcessTypeCtrlInd AS _WhseProcessTypeCtrlInd ON EWMWarehouse = _WhseProcessTypeCtrlInd.EWMWarehouse AND EWMWarehouseProcessType = _WhseProcessTypeCtrlInd.EWMProcessTypeControlCode  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseProcTypeCtrlIndText AS _WhseProcTypeCtrlIndText ON EWMWarehouse = _WhseProcTypeCtrlIndText.EWMWarehouse AND EWMWarehouseProcessType = _WhseProcTypeCtrlIndText.EWMProcessTypeControlCode  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseProcessTypeCtrlInd AS _WhseProcessTypeCtrlInd_2 ON EWMWarehouse = _WhseProcessTypeCtrlInd_2.EWMWarehouse AND EWMProcessTypeControlCode = _WhseProcessTypeCtrlInd_2.EWMProcessTypeControlCode  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseProcTypeCtrlIndText AS _WhseProcTypeCtrlIndText_2 ON EWMWarehouse = _WhseProcTypeCtrlIndText_2.EWMWarehouse AND EWMProcessTypeControlCode = _WhseProcTypeCtrlIndText_2.EWMProcessTypeControlCode  -- association [0..*]
LEFT OUTER JOIN I_EWM_ProductLoadCategory AS _ProductLoadCategory ON EWMWarehouse = _ProductLoadCategory.EWMWarehouse AND EWMProductLoadCategory = _ProductLoadCategory.EWMProductLoadCategory  -- association [0..1]
LEFT OUTER JOIN I_EWM_ProductLoadCategoryText AS _ProductLoadCategoryText ON EWMWarehouse = _ProductLoadCategoryText.EWMWarehouse AND EWMProductLoadCategory = _ProductLoadCategoryText.EWMProductLoadCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_QtyAdjustmentProfile_2 AS _QtyAdjustmentProfile ON EWMQuantityAdjustmentProfile = _QtyAdjustmentProfile.EWMQuantityAdjustmentProfile  -- association [0..1]
LEFT OUTER JOIN I_EWM_QtyAdjustmentPrflT_2 AS _QtyAdjustmentPrflT ON EWMQuantityAdjustmentProfile = _QtyAdjustmentPrflT.EWMQuantityAdjustmentProfile  -- association [0..*]
LEFT OUTER JOIN I_EWMQtyClassification AS _QtyClassification ON EWMMrchdsDistrQtyClassfctn = _QtyClassification.EWMProdQuantityClassification  -- association [0..1]
LEFT OUTER JOIN I_EWMQtyClassificationText AS _QtyClassificationText ON EWMMrchdsDistrQtyClassfctn = _QtyClassificationText.EWMProdQuantityClassification  -- association [0..*]
LEFT OUTER JOIN I_EWM_PtwyControlStrategy AS _PtwyControlStrategy ON EWMWarehouse = _PtwyControlStrategy.EWMWarehouse AND EWMPtwyControlStrategy = _PtwyControlStrategy.EWMPtwyControlStrategy  -- association [0..1]
LEFT OUTER JOIN I_EWM_PtwyControlStrategyText AS _PtwyControlStrategyText ON EWMWarehouse = _PtwyControlStrategyText.EWMWarehouse AND EWMPtwyControlStrategy = _PtwyControlStrategyText.EWMPtwyControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageBinType_2 AS _StorageBinType ON EWMWarehouse = _StorageBinType.EWMWarehouse AND EWMStorageBinType = _StorageBinType.EWMStorageBinType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBinTypeText_2 AS _StorageBinTypeText ON EWMWarehouse = _StorageBinTypeText.EWMWarehouse AND EWMStorageBinType = _StorageBinTypeText.EWMStorageBinType  -- association [0..*]
LEFT OUTER JOIN I_EWM_BulkStorageMethod AS _BulkStorageMethod ON EWMWarehouse = _BulkStorageMethod.EWMWarehouse AND EWMBulkStorageMethod = _BulkStorageMethod.EWMBulkStorageMethod  -- association [0..1]
LEFT OUTER JOIN I_EWM_BulkStorageMethodText AS _BulkStorageMethodText ON EWMWarehouse = _BulkStorageMethodText.EWMWarehouse AND EWMBulkStorageMethod = _BulkStorageMethodText.EWMBulkStorageMethod  -- association [0..*]
LEFT OUTER JOIN I_EWM_StkRemovalCtrlStrgy AS _StkRemovalCtrlStrgy ON EWMWarehouse = _StkRemovalCtrlStrgy.EWMWarehouse AND EWMStockRemovalControlStrategy = _StkRemovalCtrlStrgy.EWMStockRemovalControlStrategy  -- association [0..1]
LEFT OUTER JOIN I_EWM_StkRemovalCtrlStrgyText AS _StkRemovalCtrlStrgyText ON EWMWarehouse = _StkRemovalCtrlStrgyText.EWMWarehouse AND EWMStockRemovalControlStrategy = _StkRemovalCtrlStrgyText.EWMStockRemovalControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockDeterminationGroup AS _StockDeterminationGroup ON EWMWarehouse = _StockDeterminationGroup.EWMWarehouse AND EWMStockDeterminationGroup = _StockDeterminationGroup.EWMStockDeterminationGroup  -- association [0..1]
LEFT OUTER JOIN I_EWM_StkDetnGroupText AS _StkDetnGroupText ON EWMWarehouse = _StkDetnGroupText.EWMWarehouse AND EWMStockDeterminationGroup = _StkDetnGroupText.EWMStockDeterminationGroup  -- association [0..*]
LEFT OUTER JOIN I_EWM_StagingAreaDetnGroup AS _StagingAreaDetnGroup ON EWMWarehouse = _StagingAreaDetnGroup.EWMWarehouse AND EWMStggAreaDeterminationGroup = _StagingAreaDetnGroup.EWMStggAreaDeterminationGroup  -- association [0..1]
LEFT OUTER JOIN I_EWM_StagingAreaDetnGroupText AS _StagingAreaDetnGroupText ON EWMWarehouse = _StagingAreaDetnGroupText.EWMWarehouse AND EWMStggAreaDeterminationGroup = _StagingAreaDetnGroupText.EWMStggAreaDeterminationGroup  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageSectionIndicator AS _StorageSectionIndicator ON EWMWarehouse = _StorageSectionIndicator.EWMWarehouse AND EWMStorageSectionMethod = _StorageSectionIndicator.EWMStorageSectionMethod  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageSectionIndText AS _StorageSectionIndText ON EWMWarehouse = _StorageSectionIndText.EWMWarehouse AND EWMStorageSectionMethod = _StorageSectionIndText.EWMStorageSectionMethod  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON PreferredUnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON PreferredUnitOfMeasure = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure_2 ON EWMPreferredUnit = _UnitOfMeasure_2.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText_2 ON EWMPreferredUnit = _UnitOfMeasureText_2.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_EWM_BackflushMethod AS _BackflushMethod ON EWMProdBackflushWthdrwlMethod = _BackflushMethod.EWMProdBackflushWthdrwlMethod  -- association [0..1]
LEFT OUTER JOIN I_EWM_BackflushMethodText AS _BackflushMethodText ON EWMProdBackflushWthdrwlMethod = _BackflushMethodText.EWMProdBackflushWthdrwlMethod  -- association [0..*]
LEFT OUTER JOIN I_EWM_KitQtyCorrelationType AS _KitQtyCorrelationType ON EWMKitQuantityCorrelation = _KitQtyCorrelationType.EWMKitQuantityCorrelation  -- association [0..1]
LEFT OUTER JOIN I_EWM_KitQtyCorrlnTypeText AS _KitQtyCorrlnTypeText ON EWMKitQuantityCorrelation = _KitQtyCorrlnTypeText.EWMKitQuantityCorrelation  -- association [0..*]
LEFT OUTER JOIN I_EWM_RelevanceTwoStepPicking AS _RelevanceTwoStepPicking ON EWMProdTwoStepPickingRelevant = _RelevanceTwoStepPicking.EWMProdTwoStepPickingRelevant  -- association [0..1]
LEFT OUTER JOIN I_EWM_RlvnceTwoStepPickingText AS _RlvnceTwoStepPickingText ON EWMProdTwoStepPickingRelevant = _RlvnceTwoStepPickingText.EWMProdTwoStepPickingRelevant  -- association [0..*]
LEFT OUTER JOIN I_EWM_PhysInvtryCycleCounting AS _PhysInvtryCycleCounting ON EWMWarehouse = _PhysInvtryCycleCounting.EWMWarehouse AND EWMPhysInventoryCountingCycle = _PhysInvtryCycleCounting.EWMPhysInventoryCountingCycle  -- association [0..1]
LEFT OUTER JOIN I_EWM_QualityInspectionGroup AS _QualityInspectionGroup ON EWMQualityInspectionGroup = _QualityInspectionGroup.QualityInspectionGroup  -- association [0..1]
LEFT OUTER JOIN I_EWM_QualityInspectionGroupT AS _QualityInspectionGroupT ON EWMQualityInspectionGroup = _QualityInspectionGroupT.QualityInspectionGroup  -- association [0..*]
LEFT OUTER JOIN E_ProdEWMWarehouse AS _Extension ON ProductInternalUUID = _Extension.ProdSupChnMgmtUUID22 AND SupplyChainUnitUUID = _Extension.SupplyChainUnitUUID AND EWMPartyEntitledToDisposeUUID = _Extension.BusinessPartnerUUID  -- association [0..1]
;