EWM Reference
SAP EWM Reference Database
SAP EWM is a GUID system wearing a semantic-key system’s clothes: bins and tasks key on readable columns, while stock, handling units and deliveries key on RAW16 GUIDs. A searchable reference for supply chain practitioners landing replicated EWM data in a lakehouse.
Free & ungated · Last verified August 2026
68
Tables
25
T-Codes
9
Modules
11
Quirks
How this is scoped
- Scope: the whole warehouse — structure and storage bins, stock and handling units, warehouse tasks, orders and waves, the shared /SCDL delivery layer, physical inventory, resources and RF execution, the yard and material flow, and the master data every GUID resolves through — plus the transactions that write them. A concept-level crosswalk from classic SAP WM to EWM maps each classic-WM concept to where it lives in EWM. Browse all t-codes
- Verification: every table's key structure and every field name here was read off that table's own data-dictionary page on a public mirror — SAP publishes no per-table schema site, so the column-level layer rests on those mirrors under a two-source rule, and an unverifiable field is dropped rather than guessed. Descriptions are original wording. Last verified August 2026.
- Built for analytics: relationships focus on the joins you'll actually write — the warehouse-plus-bin composite keys, the GUID bridges into stock and the product master, header/item pairs — and the generated SQL targets the replicated lakehouse copy, with the client anchor and the namespace rename already handled.
Frequently Referenced Tables
The workhorses of EWM analytics — the bin master, both halves of the warehouse-task split, the warehouse order, handling units, available stock, the outbound delivery item, and the product bridge every other table resolves through.
- /SCWM/LAGPThe storage bin master — one row per bin in a warehouse, with its storage type and section, the three block indicators, capacity limits, empty/full flags, and the layout coordinates the pick path is built from
- /SCWM/ORDIM_OOpen warehouse tasks — the work still to be done: source and destination bin, product, target quantity, process type, queue, and the delivery item the move was created for
- /SCWM/ORDIM_CConfirmed warehouse tasks — the same movement after execution, carrying the actual quantity, the confirmation timestamp, and (with the creation stamp) the task cycle time
- /SCWM/WHOWarehouse order header — the bundle of tasks one operator executes as a unit, with the creation rule that produced it, the wave it came from, its queue, activity area, assigned resource, and the timestamps that bound execution
- /SCWM/HUHDRHandling unit header — one row per HU with its external number, packaging material, current storage type and bin, weights, volumes, and the entitled party whose stock it holds
- /SCWM/AQUAAvailable quants — the stock that warehouse task creation can actually consume, with the bin, handling unit, product, stock type, batch, owner, and entitled party all resolved onto one row
- /SCDL/DB_PROCI_OOutbound delivery order item — the line grain outbound: product, quantity, entitled party, stock owner, and the picking and goods-issue statuses
- /SAPAPO/MATKEYThe product master key table — the bridge between the internal product GUID every EWM table carries and the readable material number, with the base unit, weights, volumes, and shelf-life control
The EWM quirks guide
The modeling traps that make a first EWM extract wrong in ways that look right. Each links to a worked Databricks SQL pattern.
Read all 11 quirksBrowse by Module
Organized by functional area. Click a module to see its tables.
- Warehouse StructureThe warehouse number and everything hanging off it — storage types, sections, activity areas, work centers, and doors; the configuration layer every bin, task, and stock row resolves against12 tablesSupply chain
- Storage BinsThe bin master and its satellites — bin types, activity-area sort sequences that drive pick paths, and fixed product-to-bin assignments with their replenishment quantities4 tablesSupply chain
- Stock & Handling UnitsThe LIME stock engine and the handling-unit layer — quant attributes, quantities on the location/HU tree, available stock for task creation, and HU headers5 tablesSupply chain
- Warehouse Tasks & OrdersExecution: warehouse tasks in their open, confirmed, and logged forms, the warehouse orders that bundle them for an operator, and the waves that release the work6 tablesSupply chain
- Delivery Processing (Warehouse Requests)The /SCDL delivery layer — request and processing documents inbound and outbound, plus the shared status, reference-document, and date tables every category writes into15 tablesSupply chain
- Master Data & PartiesThe product GUID bridge and its warehouse-level extensions, plus the supply chain unit that resolves warehouse and party GUIDs to readable identifiers7 tablesSupply chain
- Resources & RF ExecutionThe operators, vehicles, and devices that execute warehouse orders, with the queue and bin position each is working from5 tablesSupply chain
- Physical InventoryCounting documents, count items, and the difference postings that reconcile counted stock against the ledger5 tablesSupply chain
- Yard & Material FlowYard management and material flow system — transportation units, vehicles, yard movements, and the conveyor/automation layer9 tablesSupply chain
Sources & further reading
Table structure and behavior are authoritative only at source. Use these references to verify before building on any claim in this reference.
Show all 17 sources, graded by group
Column-level sources — per-table DDIC pages
- ERP Explorer — S/4HANA table pages (opens in new tab) — the primary column-level source this wave: each per-table page carries the full field list with data elements, types, lengths, decimals, and key flags.
- TcodeSearch — SAP table pages (opens in new tab) — the cross-check mirror; six tables were additionally verified on both, and it expands some include structures the other does not.
- se80.co.uk — S/4HANA table directory (opens in new tab) — a listed DDIC mirror that blocks automated access; recorded for manual verification cycles, and no fact here rests on it.
- LeanX — SAP table search (opens in new tab) — an ECC and HANA table search on the relaunched LeanX site; it does not resolve namespaced /SCWM/* names, so no fact in this reference rests on it.
SAP-published behavior sources
- Integration of SAP ERP or SAP S/4HANA with Decentralized EWM in SAP S/4HANA (opens in new tab) — the decentralized deployment's integration mechanics: master data distributed over ALE IDocs and the Data Replication Framework, which is what the extraction guide's decentralized section rests on.
- CDS Views for Extended Warehouse Management (opens in new tab) — the released-view catalog behind the extraction guide's CDS section; the individual view pages carry each view's own structure.
- SAP Help — Physical Inventory in EWM (opens in new tab) — the conceptual anchor for the physical-inventory module: documents, items, and the counting process the LIME-side tables persist.
- SAP KBA 3558409 (opens in new tab) — corroboration for the link between a physical-inventory document and the warehouse task raised from it.
- SAP KBA 3190865 (opens in new tab) — database-lock prevention on the storage-bin master; behavior corroboration for how the bin table is written, not for task handling.
- SAP KBA 2851251 (opens in new tab) — automatic creation of fixed storage bins; behavior corroboration for the bin/product assignment layer.
- SAP EWM for SAP S/4HANA Cloud, Private Edition, 2025 FPS01 — What's New (opens in new tab) — SAP's own release-wave statement (published February 2026) of what changed in EWM; the currency anchor for a reference that deliberately pins no release.
- SAP-authored product-master best practices (SAP Community) — behavior corroboration for the product GUID to material number bridge in embedded S/4HANA.
Corroboration only — never the sole source for a claim
- SAP Community — EWM tables overview (blog 13578494) — role corroboration for the table envelope; no column name ships on its authority alone.
- SAP Community — CDS views for inventory analysis (blog 13338508) — discovery input for the CDS path the extraction guide now covers.
- erp.pics — EWM stock model flowchart — role corroboration for the three-layer stock model.
- Community table dumps (idoc.pub, pdfcoffee) — corroboration only, and never for a /SCDL description: the /SCDL section of the circulating dump has a row-shift defect that misattributes descriptions.
- Practitioner forums and warehouse-management blogs — role corroboration for how tables are used in practice.