I_ProdEWMWarehouse

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_ProdEWMWarehouse.
-- 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: IPRDEWMWRHS

CREATE VIEW I_ProdEWMWarehouse AS
SELECT
  ProductEWMWarehouse.matid AS ProductUUID,
  ProductEWMWarehouse.scuguid AS SupplyChainUnitUUID,
  ProductEWMWarehouse.entitled_id AS BusinessPartnerUUID,
  _Product.Product AS Product,
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  _AssgWhseBusinessPartner.Warehouse AS Warehouse,
  ProductEWMWarehouse.procprfl AS EWMProductProcessBlockProfile,
  ProductEWMWarehouse.ptdetind AS EWMWarehouseProcessType,
  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 AdjustmentProfile,
  ProductEWMWarehouse.quancla_merch AS EWMMrchdsDistrQtyClassfctn,
  ProductEWMWarehouse.puom_wh AS PreferredUnitOfMeasure,
  ProductEWMWarehouse.qgrp_wh AS EWMQualityInspectionGroup,
  ProductEWMWarehouse.put_stra AS EWMPtwyControlStrategy,
  ProductEWMWarehouse.lptyp AS StorageBinType,
  ProductEWMWarehouse.block AS ProductBulkStorageMethod,
  ProductEWMWarehouse.lgbkz AS EWMStorageSectionMethod,
  ProductEWMWarehouse.rem_stra AS EWMStockRemovalControlStrategy,
  ProductEWMWarehouse.stckdetgr AS EWMStockDeterminationGroup,
  ProductEWMWarehouse.l2skr AS ProdIsRlvtForTwoStepPicking,
  ProductEWMWarehouse.drdetgr AS EWMStggAreaDeterminationGroup,
  _Product.BaseUnit AS BaseUnit,
  _Product._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 ProductUUID = _Product.ProdSupChnMgmtUUID22  -- association [1..1]
LEFT OUTER JOIN I_EWM_AssgWhseBusinessPartner AS _AssgWhseBusinessPartner ON SupplyChainUnitUUID = _AssgWhseBusinessPartner.SupplyChainUnitUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerNumber ON businesspartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_EWM_WarehouseNumberText AS _WarehouseText ON Warehouse = _WarehouseText.Warehouse  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMProcBlkProfile AS _EWMProductProcessBlockProfile ON Warehouse = _EWMProductProcessBlockProfile.Warehouse AND EWMProductProcessBlockProfile = _EWMProductProcessBlockProfile.EWMProductProcessBlockProfile  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMProcBlkPrflText AS _EWMProdProcessBlockProfileTxt ON Warehouse = _EWMProdProcessBlockProfileTxt.Warehouse AND EWMProductProcessBlockProfile = _EWMProdProcessBlockProfileTxt.EWMProductProcessBlockProfile  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMWrhsProcType AS _EWMWarehouseProcessType ON Warehouse = _EWMWarehouseProcessType.Warehouse AND EWMWarehouseProcessType = _EWMWarehouseProcessType.EWMWarehouseProcessType  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMWrhsProcTypeText AS _EWMWarehouseProcessTypeText ON Warehouse = _EWMWarehouseProcessTypeText.Warehouse AND EWMWarehouseProcessType = _EWMWarehouseProcessTypeText.EWMWarehouseProcessType  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMProdLoadCat AS _EWMProductLoadCategory ON Warehouse = _EWMProductLoadCategory.Warehouse AND EWMProductLoadCategory = _EWMProductLoadCategory.EWMProductLoadCategory  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMProdLoadCatText AS _EWMProductLoadCategoryText ON Warehouse = _EWMProductLoadCategoryText.Warehouse AND EWMProductLoadCategory = _EWMProductLoadCategoryText.EWMProductLoadCategory  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMAdjmtProfile AS _AdjustmentProfile ON AdjustmentProfile = _AdjustmentProfile.AdjustmentProfile  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMAdjmtProfileText AS _AdjustmentProfileText ON AdjustmentProfile = _AdjustmentProfileText.AdjustmentProfile  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMMrchdsDistrQty AS _EWMMrchdsDistrQtyClassfctn ON EWMMrchdsDistrQtyClassfctn = _EWMMrchdsDistrQtyClassfctn.EWMMrchdsDistrQtyClassfctn  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMMrchdsDistrQtyTxt AS _EWMMrchdsDistrQtyClassfctnTxt ON EWMMrchdsDistrQtyClassfctn = _EWMMrchdsDistrQtyClassfctnTxt.EWMMrchdsDistrQtyClassfctn  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMPtwyCtrlStrgy AS _EWMPtwyControlStrategy ON Warehouse = _EWMPtwyControlStrategy.Warehouse AND EWMPtwyControlStrategy = _EWMPtwyControlStrategy.EWMPtwyControlStrategy  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMPtwyCtrlStrgyText AS _EWMPtwyControlStrategyText ON Warehouse = _EWMPtwyControlStrategyText.Warehouse AND EWMPtwyControlStrategy = _EWMPtwyControlStrategyText.EWMPtwyControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMStorageBinType AS _StorageBinType ON Warehouse = _StorageBinType.Warehouse AND StorageBinType = _StorageBinType.StorageBinType  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMStorBinTypeText AS _StorageBinTypeText ON Warehouse = _StorageBinTypeText.Warehouse AND StorageBinType = _StorageBinTypeText.StorageBinType  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMBulkStorMethod AS _ProductBulkStorageMethod ON Warehouse = _ProductBulkStorageMethod.Warehouse AND ProductBulkStorageMethod = _ProductBulkStorageMethod.ProductBulkStorageMethod  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMBulkStorMethText AS _ProductBulkStorageMethodText ON Warehouse = _ProductBulkStorageMethodText.Warehouse AND ProductBulkStorageMethod = _ProductBulkStorageMethodText.ProductBulkStorageMethod  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMStkRemovalCtrl AS _EWMStockRemovalCtrlStrategy ON Warehouse = _EWMStockRemovalCtrlStrategy.Warehouse AND EWMStockRemovalControlStrategy = _EWMStockRemovalCtrlStrategy.EWMStockRemovalControlStrategy  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMStkRemovalCtrlTxt AS _EWMStkRemovalCtrlStrategyText ON Warehouse = _EWMStkRemovalCtrlStrategyText.Warehouse AND EWMStockRemovalControlStrategy = _EWMStkRemovalCtrlStrategyText.EWMStockRemovalControlStrategy  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMStkDetnGroup AS _EWMStockDeterminationGroup ON Warehouse = _EWMStockDeterminationGroup.Warehouse AND EWMStockDeterminationGroup = _EWMStockDeterminationGroup.EWMStockDeterminationGroup  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMStkDetnGroupText AS _EWMStockDeterminationGroupTxt ON Warehouse = _EWMStockDeterminationGroupTxt.Warehouse AND EWMStockDeterminationGroup = _EWMStockDeterminationGroupTxt.EWMStockDeterminationGroup  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMStggAreaDetn AS _EWMStggAreaDeterminationGroup ON Warehouse = _EWMStggAreaDeterminationGroup.Warehouse AND EWMStggAreaDeterminationGroup = _EWMStggAreaDeterminationGroup.EWMStggAreaDeterminationGroup  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMStggAreaDetnText AS _EWMStggAreaDeterminationText ON Warehouse = _EWMStggAreaDeterminationText.Warehouse AND EWMStggAreaDeterminationGroup = _EWMStggAreaDeterminationText.EWMStggAreaDeterminationGroup  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMPtwyStorSection AS _EWMStorageSectionMethod ON Warehouse = _EWMStorageSectionMethod.Warehouse AND EWMStorageSectionMethod = _EWMStorageSectionMethod.EWMStorageSectionMethod  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMPtwyStorSctnText AS _EWMStorageSectionMethodText ON Warehouse = _EWMStorageSectionMethodText.Warehouse AND EWMStorageSectionMethod = _EWMStorageSectionMethodText.EWMStorageSectionMethod  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON PreferredUnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _PreferredUnitOfMeasure ON PreferredUnitOfMeasure = _PreferredUnitOfMeasure.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMBackflushMethod AS _EWMProdBackflushWthdrwlMethod ON EWMProdBackflushWthdrwlMethod = _EWMProdBackflushWthdrwlMethod.EWMProdBackflushWthdrwlMethod  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMBackflushMethText AS _EWMProdBackflushWthdrwlTxt ON EWMProdBackflushWthdrwlMethod = _EWMProdBackflushWthdrwlTxt.EWMProdBackflushWthdrwlMethod  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMKitQtyCorrln AS _EWMKitQuantityCorrelation ON EWMKitQuantityCorrelation = _EWMKitQuantityCorrelation.EWMKitQuantityCorrelation  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMKitQtyCorrlnText AS _EWMKitQuantityCorrelationText ON EWMKitQuantityCorrelation = _EWMKitQuantityCorrelationText.EWMKitQuantityCorrelation  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMTwoStepPicking AS _ProdRlvtForTwoStepPicking ON ProdIsRlvtForTwoStepPicking = _ProdRlvtForTwoStepPicking.ProdIsRlvtForTwoStepPicking  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMTwoStpPickingText AS _ProdRlvtForTwoStepPickingText ON ProdIsRlvtForTwoStepPicking = _ProdRlvtForTwoStepPickingText.ProdIsRlvtForTwoStepPicking  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMInvtryCycCounting AS _EWMPhysInventoryCountingCycle ON Warehouse = _EWMPhysInventoryCountingCycle.Warehouse AND EWMPhysInventoryCountingCycle = _EWMPhysInventoryCountingCycle.EWMPhysInventoryCountingCycle  -- association [0..1]
LEFT OUTER JOIN I_EWM_QualityInspectionGroup AS _EWMQualityInspectionGroup ON EWMQualityInspectionGroup = _EWMQualityInspectionGroup.QualityInspectionGroup  -- association [0..1]
LEFT OUTER JOIN I_EWM_QualityInspectionGroupT AS _EWMQualityInspectionGroupText ON EWMQualityInspectionGroup = _EWMQualityInspectionGroupText.QualityInspectionGroup  -- association [0..*]
LEFT OUTER JOIN E_ProdEWMWarehouse AS _Extension ON ProductUUID = _Extension.ProdSupChnMgmtUUID22 AND SupplyChainUnitUUID = _Extension.SupplyChainUnitUUID AND BusinessPartnerUUID = _Extension.BusinessPartnerUUID  -- association [0..1]
;