SAP EWM Tables

SAP EWM Tables - Table of Content

• Introduction to SAP EWM
• SAP EWM Tables
• Stock
• Warehouse Task
• References
• Physical Inventory Documents
• APO Location
• Final Thoughts

If you work with SAP Extended Warehouse Management, sooner or later you need to go straight to the tables. Whether you are debugging why a warehouse task did not create, tracing a delivery through the system, or pulling stock data for a report, knowing the right table name saves hours. This guide is the reference for that, organized the way an EWM consultant actually thinks about it: by function, from deliveries and warehouse tasks to stock, bins, and configuration.

It covers both embedded EWM in SAP S/4HANA and decentralized EWM, since the underlying table structure is largely the same across the two. Alongside the table lists, there is a short teaching layer, covering how to view these tables, what the naming prefixes mean, and how the tables connect across a warehouse process, so the names are not just a list to copy but something you can navigate with confidence.

Let's start with the foundation, because it makes every table name afterward easier to read.

Introduction to SAP EWM :

SAP EWM is a crucial functional module that is pivotal in helping organizations manage their inventories and streamline the movement of goods within their warehouse operations. This advanced software solution offers a complete suite of functions. It includes handling inbound and outbound delivery processes, (GR) receipt of goods, order success, and efficient goods distribution.

Understanding SAP EWM Table Naming:

SAP EWM tables are not named randomly. Once you learn the prefixes, you can often guess which application area a table belongs to just by looking at it. Almost every EWM table sits inside a namespace marked by slashes, and each namespace maps to a functional area.

/SCWM/ is the core EWM namespace. Most tables you touch day to day, such as warehouse tasks, handling units, waves, stock, and bins, live here. If you remember one prefix, remember this one.

/SCDL/ covers the delivery layer (Supply Chain Delivery). Inbound and outbound delivery documents, both the request and the actual delivery, are stored under this namespace.

/LIME/ is the Logistics Inventory Management Engine, the stock ledger underneath EWM. Physical stock quantities and physical inventory data live here.

/SAPAPO/ holds master data that EWM inherits from its SCM roots, such as products, units of measure, and location data. Even in embedded S/4HANA EWM, you will still see these table names.

/SCMB/ covers supply chain basis objects like routes, transportation zones, and supply chain units.

Knowing these five prefixes turns a wall of table names into something readable. A table like /SCWM/ORDIM_O is clearly core EWM (/SCWM/), and /SCDL/DB_DLVH_O is clearly a delivery-layer document. Keep this in mind as you scan the lists below.

1) Stock

• /SCWM/AQUA: Describes available quantity.
• /SCWM/QUAN: Defines quant attributes.
• /LIME/NQUAN: Details LIME quantity attributes.
• /SCWM/STOCK_IW01: Manages stock key material (WME).
• /SCWM/STOCK_IW02: Manages stock key material with batch (WME).
• /SCWM/STOCK_IW03: Manages stock key material with batch and reference documents (WME).
• /SCWM/STOCK_IW04: Manages stock key material with sales order and project (WME).

Become a master of SAP EWM by going through this HKR SAP EWM Online Training! 

SAP EWM Training

• Master Your Craft
• Lifetime LMS & Faculty Access
• 24/7 online expert support
• Real-world & Project Based Learning

Explore Curriculum

2) Warehouse Task

• /SCWM/ORDIM_C: Defines confirmed warehouse tasks.
• /SCWM/ORDIM_CS: Specifies serial numbers for confirmed warehouse task items.
• /SCWM/ORDIM_E: Specifies exception codes for warehouse tasks.
• /SCWM/ORDIM_H: Manages warehouse task movements for handling unit (HU) items.
• /SCWM/ORDIM_HS: Handles serial numbers for HU item movements.
• /SCWM/ORDIM_L: Logs warehouse task information.
• /SCWM/ORDIM_LS: Logs serial numbers for warehouse task entries.
• /SCWM/ORDIM_O: Open warehouse tasks.
• SCWM/ORDIM_OS: It handles serial number items for available warehouse tasks.
•  

3) Transportation Unit

• /SCWM/TU_DLV: Describes the assignment of deliveries and HUs to transportation units.
• /SCWM/TU_DOOR: Assigns transport units to doors.
• /SCWM/TUNIT: Defines transportation units.
• /SCWM/TU_SR_ACT: Specifies S and R activities of transportation units.
• /SCWM/TU_STATUS: Manages the status of transportation unit activities.
• /SCWM/TU_VEH: Assigns transport units to vehicles.
• /SCWM/DOOR_SRACT: Defines S & R activities of doors.
•  

4) Wave

• /SCWM/WAVEHDR: Manages wave header data.
• /SCWM/WAVEITM: Contains wave item data.
•  

5) Outbound Delivery

• /SCDL/DB_DLVH_O: Handles outbound delivery header data.
• /SCDL/DB_DLVI_O: Manages outbound delivery item details.
• /SCDL/DB_PROCH_O: Oversees outbound delivery order header.
• /SCDL/DB_PROCI_O: Manages outbound delivery order items.
•  

6) Inbound Delivery

• /SCDL/DB_PROCH_I: Manages inbound delivery header information.
• /SCDL/DB_PROCI_I: Details inbound delivery item information.

Interested in learning python Join HKR Python certification training! 

7) References

• /SCDL/DB_REFDOC: Determines reference information.
• /SCDL/DB_REQH: Defines header information for inbound delivery notifications or outbound delivery requests.
• /SCDL/DB_REQI: Manages item information for inbound delivery notifications or outbound delivery requests.
•  

8) Handling Units (HUs)

• /SCWM/HUHDR: Oversees handling unit header information.
• /SCWM/GMHUIDENT: Manages additional handling units for goods movement logs.
• /SCWM/HUSSTAT: Specifies individual status for each handling unit.
• /SCWM/HUREF: Manages handling unit references.
• /SCWM/HUSTOBJ: Details information about handling unit status objects.
• /SCWM/GMHUSTAT: Tracks HU status from goods movement logs.
• /SCWM/GMHUITM: Manages handling unit items.
• /SCWM/GMHUHDR: Maintains handling unit header data in goods movement logs.
•  

9) Storage Bins

• /SCWM/LAGP: Provides storage bin details.
• /SCWM/LAGPS: Offers comprehensive information on available storage bins for various execution areas and activities.
•  

10) Master Data

• /SAPAPO/MATKEY: Defines product details.
• /SAPAPO/MATMAP: Manages mapping table details for products.
• /SAPAPO/MATEXEC: This table contains product execution data.
• /SAPAPO/MATTXT: It provides material descriptions.
• /SAPAPO/MATLWHST: This table states the location-specific product information by storage types.
• /SAPAPO/MATLWH: It specifies location product information for warehouse locations.
•  

11) Physical Inventory Documents

• /LIME/PI_DCTYTXT: It describes physical inventory procedure details.
• /LIME/PI_DOCTYPE: It defines document types for physical inventory and internal settings.
• /LIME/PI_DOC_IT: It manages physical inventory document items.
• /LIME/PI_DOC_SER: This table tracks serial numbers for physical inventory document items.
• /LIME/PI_DOC_TB: This table contains quantities for physical inventory document items.
• /LIME/PI_IT_BIZ: Specifies business key objects for physical inventory documents.
• /LIME/PI_LOGHEAD: It logs header data of physical inventory log entries.
• /LIME/PI_LOGHIST: Maintains a history table for physical inventory log entries.
• /LIME/PI_LOGITEM: This table logs item data of a physical inventory document.
• /LIME/PI_PAR_BIZ: It manages parent objects for physical inventory document business keys.
•  

12) Route

• /SCMB/ROUTE: Provides route information.
• /SCMB/ROUTET: Contains route table information.
• /SCMB/TOENTITYT: Specifies text information about supply chain units.
• /SCDL/TSRVLVLT: It specifies the details of shipping condition text information.
• /SCMB/ROUTE_SC: Manages shipping conditions for routes.
• /SCMB/ROUTE_RT: Defines request types for routes.
• /SCMB/STOP: Offers information about route stop logs.
• /SCMB/ZONE: Contains transportation zone details.
• /SCMB/ZONE_D: Provides details on transportation unavailability zones.
• /SCMB/TOENTITY: Manages the details of the supply chain unit header.
•  

13) Location

• /SCWM/LOC_IW01: this table specifies location table numbers and storage bin details.
• /SCWM/LOC_IW02: This table offers details on warehouse resources.
• /SCWM/LOC_IW03:- Provides location table warehouse views.
• /SCWM/LOC_IW04:- Contains location table transport details.

frequently asked SAP EWM Interview Questions and Answers

Subscribe to our YouTube channel to get new updates..!

Subscribe

14) APO Location

• /SAPAPO/LOC:- Describes location details.
• /SAPAPO/LOCMAP:- Manages mapping tables for locations.
• /SAPAPO/LOCT: Offers short text descriptions for sites/locations.
• /SAPAPO/LOCVER:- Maintains version-dependent location data.
•  

15) RF (Radio Frequency)

• /SCWM/TTRNS_CAT:- It specifies logical transactions.
• /SCWM/TSTEP_CAT:- It manages steps of logical transactions.
• /SCWM/TPRDV_CAT:- This table specifies presentation devices.
• /SCWM/TPRES_CAT:- This table defines presentation profiles.
•  

16) Communications 

• TRFCQIN:- Describes TRFC queue details for inbound delivery processes.
• EDIDC:- Contains control record details.
•  

17) Business Partner (BP)

• ADRC:- Provides business address server details.
• SCDL/DB_BPLOC:- Manages partner location searches for delivery information.
• BUT000:- Contains general data for BP.
• BUT020:- Specifies BP address details.

How the Tables Connect Across a Warehouse Process

A list of tables is far more useful when you can see how they link during an actual process. Here is how the main tables chain together in a typical outbound flow, which is the scenario people troubleshoot most often.

An outbound process begins when an outbound delivery order is created, landing in /SCDL/DB_PROCH_O (header) and /SCDL/DB_PROCI_O (item). Those deliveries are grouped into a wave, recorded in /SCWM/WAVEHDR and /SCWM/WAVEITM, with the assignment held in the wave-to-delivery table. Releasing the wave generates warehouse tasks, which appear as open tasks in /SCWM/ORDIM_O and are grouped into warehouse orders in /SCWM/WO. As the warehouse worker picks the stock, the task moves from open (/SCWM/ORDIM_O) to confirmed (/SCWM/ORDIM_C), and the stock record in /SCWM/QUAN and /SCWM/AQUA updates to reflect the movement. If the stock is packed, a handling unit is created in /SCWM/HUHDR, and when it is loaded, it links to a transportation unit through /SCWM/TU_DLV.

Following that chain, delivery to wave to task to confirmation to HU to TU, is exactly how an experienced consultant traces a stuck outbound delivery. The same header-item, open-confirmed, request-document patterns repeat throughout, which is why learning the naming logic pays off far more than memorizing individual names.

Tips for Working with EWM Tables Effectively

A few habits make table work faster and less error-prone.

Always filter by warehouse number. Nearly every execution table has a /SCWM/LGNUM field, and filtering on it first keeps result sets manageable and relevant to the warehouse you are investigating.

Use the monitor before the tables when you can. The EWM Warehouse Monitor (transaction /SCWM/MON) reads most of these tables through a friendly interface, and for many day-to-day questions it is faster than raw table access. Go to the tables when you need something the monitor does not show, or when you are debugging.

Learn the header-item pairs. Most document areas, such as deliveries, waves, warehouse orders, and handling units, split into a header table and an item table following the same pattern. Recognizing the pair means you can find the item detail for any header you have, and vice versa.

Remember open versus confirmed for tasks. The most common table lookup in EWM support is checking whether a warehouse task is still open (/SCWM/ORDIM_O) or completed (/SCWM/ORDIM_C). Knowing this pair alone answers a large share of execution questions.

[Related Article : Dell Boomi Tutorial]

Final Thoughts:

This detailed overview of SAP EWM tables offers valuable insights into the critical components of warehouse management and inventory control. By exploring these tables, readers can gain a more profound knowledge of the functional modules and capabilities of SAP EWM. It also equips them to excel in real-time projects with expert guidance.

Other Related articles: 

• What is SAP EWM
• SAP EWM Process Flow
• SAP EWM modules