P_EWM_Slotting

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 P_EWM_Slotting.
-- 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 P_EWM_Slotting AS
SELECT
  EWMWarehouse,
  Product,
  EntitledToDisposeParty,
  ProdSupChnMgmtUUID22,
  SupplyChainUnitUUID,
  BusinessPartnerUUID,
  WarehouseStorageCondition,
  HandlingIndicator,
  IsPilferable,
  ProductGroup,
  WarehouseProductGroup,
  EWMPtwyControlStrategy,
  EWMStorageSectionMethod,
  EWMStockRemovalControlStrategy,
  EWMBulkStorageMethod,
  PreferredUnitOfMeasure,
  BaseUnit,
  EWMSltgRequirementQuantity,
  EWMSltgNumberOfSalesOrderItems,
  EWMSltgRecmddStorageQuantity,
  _SltgRqmtInd.EWMSltgNrOfSlsOrdItmsIndCode AS EWMSltgNrOfSlsOrdItmsIndCode,
  _SltgRqmtInd.EWMSltgRqmtQuantityIndCode AS EWMSltgRqmtQuantityIndCode,
  _SltgRqmtInd.EWMSltgRecmddStorQtyIndCode AS EWMSltgRecmddStorQtyIndCode,
  _SltgDimnInd.EWMSlottingWeightSizeCode AS EWMSlottingWeightSizeCode,
  _SltgDimnInd.EWMSlottingVolumeSizeCode AS EWMSlottingVolumeSizeCode,
  _SltgDimnInd.EWMSlottingLengthSizeCode AS EWMSlottingLengthSizeCode,
  _SltgDimnInd.EWMSlottingWidthSizeCode AS EWMSlottingWidthSizeCode,
  _SltgDimnInd.EWMSlottingHeightSizeCode AS EWMSlottingHeightSizeCode
FROM P_EWM_WarehouseProductSlotting
LEFT OUTER JOIN P_EWM_SltgRqmtInd03 AS _SltgRqmtInd ON EWMWarehouse = _SltgRqmtInd.EWMWarehouse AND Product = _SltgRqmtInd.Product AND EntitledToDisposeParty = _SltgRqmtInd.EntitledToDisposeParty  -- association [0..1]
LEFT OUTER JOIN P_EWM_SltgDimnInd05 AS _SltgDimnInd ON EWMWarehouse = _SltgDimnInd.EWMWarehouse AND Product = _SltgDimnInd.Product AND EntitledToDisposeParty = _SltgDimnInd.EntitledToDisposeParty  -- association [0..1]
;