EWM Integration & Tech Post 1 – Main Tables in EWM

Main Tables in EWM

Leer este post en español →

A working reference to the tables behind SAP EWM, grouped by what they actually do. Tap any group to open it.

68 tables across 11 functional areas

Reading the prefixes

/SCWM/EWM core: tasks, orders, handling units, bins, resources
/SCDL/Delivery documents, inbound and outbound
/LIME/Logistics Inventory Management Engine — where physical stock actually lives
/SAPAPO/Master data inherited from the SCM stack

How to use this

Start from the process, not the table. /SCWM/MON, the Warehouse Management Monitor, shows you the same data with the business context attached — use it to find the document you care about, then go to the table when you need the raw fields. Tables marked NEW were added in this revision.

📦 Stock · 9 tables
/SCWM/AQUAAvailable stock for warehouse task creation
/SCWM/QUANPhysical stock attributes
/LIME/NQUANPhysical stock in the inventory engine
/LIME/NTREENEWStock hierarchy table of the inventory engine
/LIME/NSERIALNEWSerial numbers held by the inventory engine
/SCWM/STOCK_IW01Stock index: normal stock
/SCWM/STOCK_IW02Stock index: batch managed stock
/SCWM/STOCK_IW03Stock index: reference stock (PDI, PDO)
/SCWM/STOCK_IW04Stock index: special stock
🔧 Warehouse Task and Warehouse Order · 10 tables
/SCWM/ORDIM_OOpen warehouse tasks — the working set
/SCWM/ORDIM_CConfirmed warehouse tasks
/SCWM/ORDIM_LWarehouse task log table
/SCWM/WHONEWWarehouse order header — every warehouse task references a warehouse order here
/SCWM/ORDIM_EException codes recorded against a warehouse task
/SCWM/ORDIM_HWarehouse task: movements of HU items
/SCWM/ORDIM_HSSerial numbers for HU item movements
/SCWM/ORDIM_CSSerial numbers for confirmed warehouse task items
/SCWM/ORDIM_LSSerial numbers for the warehouse task log
/SCWM/DB_ITEMSPLNEWSource bin splits when picking draws stock from more than one bin
📥 Deliveries · 9 tables
/SCDL/DB_PROCH_IInbound delivery header
/SCDL/DB_PROCI_IInbound delivery item
/SCDL/DB_PROCH_OOutbound delivery order header
/SCDL/DB_PROCI_OOutbound delivery order item
/SCDL/DB_DLVH_OOutbound delivery header
/SCDL/DB_DLVI_OOutbound delivery item
/SCDL/DB_REQHHeader: inbound delivery notification / outbound delivery request
/SCDL/DB_REQIItem: inbound delivery notification / outbound delivery request
/SCDL/DB_REFDOCReference documents linking EWM deliveries back to ERP
🏷️ Handling Unit · 10 tables
/SCWM/HUHDRHandling unit header
/SCWM/HU_IDENTNEWAdditional identifiers a handling unit can carry beyond HUIDENT
/SCWM/HU_IW01NEWHandling unit index — key is LGNUM / HUIDENT / VHI
/SCWM/HUREFHandling unit reference
/SCWM/HUSSTATIndividual status of each handling unit
/SCWM/HUSTOBJHandling unit status object
/SCWM/GMHUHDRGoods movement: handling unit header
/SCWM/GMHUITMGoods movement: handling unit item
/SCWM/GMHUSTATHU status from the goods movement log
/SCWM/GMHUIDENTAdditional HU identifications in the goods movement log
🌊 Wave · 2 tables
/SCWM/WAVEHDRWave header
/SCWM/WAVEITMWave item
🚛 Transportation Unit and Doors · 7 tables
/SCWM/TUNITTransportation unit itself
/SCWM/TU_DLVAssignment of deliveries and HUs to transportation units
/SCWM/TU_STATUSStatus of transportation unit activities
/SCWM/TU_SR_ACTStart and end date/times of shipping and receiving activities
/SCWM/TU_DOORRelationship between TU activities and door activities
/SCWM/TU_VEHVehicle activities linked to a TU activity
/SCWM/DOOR_SRACTShipping and receiving activities of a door
📍 Storage Bins and Location Index · 5 tables
/SCWM/LAGPStorage bins
/SCWM/LAGPSBins for execution areas and activities
/SCWM/LOC_IW01NEWLocation index for bins, work centers and doors — key LGNUM / LGTYP / LGPLA
/SCWM/LOC_IW02NEWLocation index for resources — key LGNUM / RSRC
/SCWM/LOC_IW03NEWLocation index for the warehouse number as a logical location
🗂️ Master Data · 6 tables
/SAPAPO/MATKEYProduct master key
/SAPAPO/MATMAPMapping table for products
/SAPAPO/MATEXECProduct execution data
/SAPAPO/MATTXTMaterial descriptions
/SAPAPO/MATLWHLocation product for the warehouse
/SAPAPO/MATLWHSTLocation product at warehouse and storage type level
⚙️ Customizing · 4 tables
/SCWM/T300NEWWarehouse number definition — the check table behind LGNUM
/SCWM/T331NEWStorage type customizing
/SCWM/T333ANEWProcess categories used by storage and handling unit postings
/SCWM/T340DNEWSettings maintained at warehouse number level
👷 Resources, Labor and Quality · 3 tables
/SCWM/RSRCNEWResources — the users and equipment that execute warehouse work
/SCWM/EPDNEWEmployee performance documents used by labor management
/SCWM/QIOTWM_NIRNEWEWM process-relevant quality data when no inspection rule is used
🔢 Serialization and APIs · 3 tables
/SCWM/SERH2NEWSerial number data for warehouse usage — the current standard table
/SCWM/SERHNEWLegacy serialization table, superseded by /SCWM/SERH2
/SCWM/TAPI_IMPLNEWRegistered EWM API interfaces and their implementations

Related reading

Table names verified against the official SAP EWM course material and reference literature. Descriptions are original summaries, not reproductions.

Free: Replenishment Diagnostic Scorecard · Gratis: Scorecard de Diagnóstico

ENDownload Scorecard
ESDescargar Scorecard

Comments

Deja un comentario

Descubre más desde SAP EWM Warehouse Management

Suscríbete ahora para seguir leyendo y obtener acceso al archivo completo.

Seguir leyendo