C_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 C_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: CEWMWAREHOUSE

CREATE VIEW C_ProdEWMWarehouse AS
SELECT
  ProductEWMWarehouse.Product AS Product,
  ProductEWMWarehouse.Warehouse AS Warehouse,
  ProductEWMWarehouse.BusinessPartner AS BusinessPartner,
  ProductEWMWarehouse.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  _BusinessPartner.Plant AS Plant,
  ProductEWMWarehouse.WarehouseForEdit AS WarehouseForEdit,
  ProductEWMWarehouse.ProductUUID AS ProductUUID,
  ProductEWMWarehouse.SupplyChainUnitUUID AS SupplyChainUnitUUID,
  ProductEWMWarehouse.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProductEWMWarehouse.EWMProductProcessBlockProfile AS EWMProductProcessBlockProfile,
  ProductEWMWarehouse.EWMWarehouseProcessType AS EWMWarehouseProcessType,
  ProductEWMWarehouse.EWMProductLoadCategory AS EWMProductLoadCategory,
  ProductEWMWarehouse.EWMPhysInventoryCountingCycle AS EWMPhysInventoryCountingCycle,
  ProductEWMWarehouse.RequiredMinShelfLife AS RequiredMinShelfLife,
  ProductEWMWarehouse.RequiredMinShelfLifeCalc AS RequiredMinShelfLifeCalc,
  ProductEWMWarehouse.EWMProdBackflushWthdrwlMethod AS EWMProdBackflushWthdrwlMethod,
  ProductEWMWarehouse.EWMKitQuantityCorrelation AS EWMKitQuantityCorrelation,
  ProductEWMWarehouse.EWMIsCnsmpnRlvtForValAddedSrvc AS EWMIsCnsmpnRlvtForValAddedSrvc,
  ProductEWMWarehouse.AdjustmentProfile AS AdjustmentProfile,
  ProductEWMWarehouse.EWMMrchdsDistrQtyClassfctn AS EWMMrchdsDistrQtyClassfctn,
  ProductEWMWarehouse.PreferredUnitOfMeasure AS PreferredUnitOfMeasure,
  cast ('' as val_text) AS EWMQltyMgmtGdsRcptBlkCtrlText,
  cast ('' as val_text) AS EWMIsDocumentaryBatchText,
  cast ('' as /scwm/de_ssqss) AS EWMQltyMgmtGdsRcptBlkCtrlKey,
  cast ('' as /scwm/de_dbatchind) AS IsDocumentaryBatch,
  ProductEWMWarehouse.EWMQualityInspectionGroup AS EWMQualityInspectionGroup,
  ProductEWMWarehouse.EWMPtwyControlStrategy AS EWMPtwyControlStrategy,
  ProductEWMWarehouse.EWMStorageSectionMethod AS EWMStorageSectionMethod,
  ProductEWMWarehouse.StorageBinType AS StorageBinType,
  ProductEWMWarehouse.ProductBulkStorageMethod AS ProductBulkStorageMethod,
  ProductEWMWarehouse.EWMStockRemovalControlStrategy AS EWMStockRemovalControlStrategy,
  ProductEWMWarehouse.EWMStockDeterminationGroup AS EWMStockDeterminationGroup,
  ProductEWMWarehouse.ProdIsRlvtForTwoStepPicking AS ProdIsRlvtForTwoStepPicking,
  ProductEWMWarehouse.EWMStggAreaDeterminationGroup AS EWMStggAreaDeterminationGroup,
  cast( '' as msehi ) AS ShelfLifeDurationUnit
FROM I_ProdEWMWarehouseTP AS ProductEWMWarehouse
LEFT OUTER JOIN C_ProdEWMWrhsStorageType AS _WrhsStorage ON Product = _WrhsStorage.Product AND Warehouse = _WrhsStorage.Warehouse AND BusinessPartner = _WrhsStorage.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProdEWMPartyToDispose AS _BusinessPartner ON WarehouseForEdit = _BusinessPartner.Warehouse AND BusinessPartnerForEdit = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumberText AS _WarehouseText ON WarehouseForEdit = _WarehouseText.Warehouse AND _WarehouseText.Language = $session.system_language  -- association [0..1]
;