# SAP WM and EWM Warehouse Tables Reference

> Source: https://netray.co/tools/sap-wm-ewm-warehouse-tables-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A searchable list of the classic WM and EWM tables you query most, with a plain description and typical key fields.

## Category

sap

## Erp

SAP ECC / S/4HANA

## Audience

- SAP WM consultant
- SAP EWM consultant
- ABAP developer

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### System

**Key:** system

**Type:** text

#### Table

**Key:** table

**Type:** text

#### What it holds

**Key:** purpose

**Type:** text

#### Typical key fields

**Key:** keys

**Type:** text

**Rows:**

**System:** WM

**Table:** T300

**Purpose:** Warehouse numbers

**Keys:** MANDT, LGNUM

**System:** WM

**Table:** T301

**Purpose:** Storage types

**Keys:** MANDT, LGNUM, LGTYP

**System:** WM

**Table:** T302

**Purpose:** Storage sections

**Keys:** MANDT, LGNUM, LGTYP, LBERS

**System:** WM

**Table:** T320

**Purpose:** Assignment of plant and IM storage location to a warehouse number

**Keys:** MANDT, WERKS, LGORT

**System:** WM

**Table:** T331

**Purpose:** Storage type control (putaway and removal strategy settings per storage type)

**Keys:** MANDT, LGNUM, LGTYP

**System:** WM

**Table:** LAGP

**Purpose:** Storage bin master data

**Keys:** MANDT, LGNUM, LGTYP, LGPLA

**System:** WM

**Table:** LQUA

**Purpose:** Quants (stock per bin, material, batch, special stock)

**Keys:** MANDT, LGNUM, LQNUM

**System:** WM

**Table:** LEIN

**Purpose:** Storage units (pallets and containers managed in WM)

**Keys:** MANDT, LGNUM, LENUM

**System:** WM

**Table:** MLGN

**Purpose:** Material master data per warehouse number

**Keys:** MANDT, MATNR, LGNUM

**System:** WM

**Table:** MLGT

**Purpose:** Material master data per storage type

**Keys:** MANDT, MATNR, LGNUM, LGTYP

**System:** WM

**Table:** LTAK

**Purpose:** Transfer order header

**Keys:** MANDT, LGNUM, TANUM

**System:** WM

**Table:** LTAP

**Purpose:** Transfer order items

**Keys:** MANDT, LGNUM, TANUM, TAPOS

**System:** WM

**Table:** LTBK

**Purpose:** Transfer requirement header

**Keys:** MANDT, LGNUM, TBNUM

**System:** WM

**Table:** LTBP

**Purpose:** Transfer requirement items

**Keys:** MANDT, LGNUM, TBNUM, TBPOS

**System:** WM

**Table:** LINV

**Purpose:** Physical inventory record for WM bins

**Keys:** MANDT, IVNUM

**System:** Shared

**Table:** LIKP

**Purpose:** Delivery header (SD and LE)

**Keys:** MANDT, VBELN

**System:** Shared

**Table:** LIPS

**Purpose:** Delivery items

**Keys:** MANDT, VBELN, POSNR

**System:** Shared

**Table:** VEKP

**Purpose:** Handling unit header

**Keys:** MANDT, VENUM

**System:** Shared

**Table:** VEPO

**Purpose:** Handling unit items

**Keys:** MANDT, VENUM, VEPOS

**System:** Shared

**Table:** MARD

**Purpose:** Stock by plant and storage location (inventory management)

**Keys:** MANDT, MATNR, WERKS, LGORT

**System:** EWM

**Table:** /SCWM/ORDIM_O

**Purpose:** Open warehouse tasks

**Keys:** Warehouse number, task number

**System:** EWM

**Table:** /SCWM/ORDIM_C

**Purpose:** Confirmed warehouse tasks

**Keys:** Warehouse number, task number

**System:** EWM

**Table:** /SCWM/WHO

**Purpose:** Warehouse orders (groups of warehouse tasks assigned to a resource)

**Keys:** Warehouse number, warehouse order

**System:** EWM

**Table:** /SCWM/QUAN

**Purpose:** Quants (stock per bin, product, batch, owner)

**Keys:** Warehouse number, quant ID

**System:** EWM

**Table:** /SCWM/LAGP

**Purpose:** Storage bin master data

**Keys:** Warehouse number, storage bin

**System:** EWM

**Table:** /SCWM/HUHDR

**Purpose:** Handling unit header

**Keys:** Warehouse number, HU ID

**System:** EWM

**Table:** /SCWM/WAVEHDR

**Purpose:** Wave header

**Keys:** Warehouse number, wave number

**System:** EWM

**Table:** /SCWM/WAVEITM

**Purpose:** Wave items (warehouse request items assigned to a wave)

**Keys:** Warehouse number, wave number, item

**System:** EWM

**Table:** /SCDL/DB_PROCH_I

**Purpose:** Inbound delivery header (delivery processing in EWM)

**Keys:** Document ID

**System:** EWM

**Table:** /SCDL/DB_PROCH_O

**Purpose:** Outbound delivery order header (delivery processing in EWM)

**Keys:** Document ID

**Notes:** Descriptions are paraphrased. Key fields are the typical ones; always confirm exact field names and keys for your release in SE11 or SE16N before writing code. EWM table structures differ between embedded EWM in S/4HANA and decentralized EWM.

## Content

**Intro:** When you debug a stuck transfer order or build a stock report, the first question is which table holds the data. This reference lists the classic WM tables, the shared delivery and handling unit tables, and the main EWM tables, with a one-line description each.

**Sections:**

#### How to use the table list

**Body:** Type a table name or a word such as quant, wave or handling unit into the search box to filter rows. The System column tells you whether the table belongs to classic Warehouse Management (WM), to Extended Warehouse Management (EWM) or is shared with SD and logistics execution. Export to Excel if you want to paste the list into a technical specification or a data migration plan. Use SE16N for a quick look at contents, but remember that large tables such as LQUA and LTAP should always be filtered by warehouse number.

#### WM versus EWM data models

**Body:** Classic WM is built around the transfer order (LTAK and LTAP), the quant (LQUA) and the storage bin (LAGP). EWM replaces the transfer order with warehouse tasks and warehouse orders, keeps stock as quants in its own tables and uses delivery processing from the SCDL framework. A frequent mistake in migration projects is assuming a one to one table mapping. A WM transfer order item becomes a warehouse task, but the grouping of tasks into warehouse orders is new and has no WM equivalent.

**Bullets:**

- WM stock: LQUA, with LAGP for bins
- EWM stock: /SCWM/QUAN, with /SCWM/LAGP for bins
- WM movement: LTAK and LTAP
- EWM movement: /SCWM/ORDIM_O and /SCWM/ORDIM_C

#### Reading the results and common mistakes

**Body:** Open and confirmed documents are split in EWM: a warehouse task lives in ORDIM_O until it is confirmed and then moves to ORDIM_C. If you report on throughput, read both tables. In WM, an unconfirmed transfer order item has the confirmation indicator PQUIT blank in LTAP, while confirmed items carry an X. Another common mistake is joining LQUA to MARD without allowing for stock that is in transit or posted in interim storage types such as 902 and 904 style bins, which causes small differences against inventory management.

**Cta:** If you want to ask your warehouse data questions in plain language instead of writing joins across these tables, Netray can connect a read-only assistant to your SAP data on your own infrastructure.

**Faq:**

#### Which table shows current stock in a WM bin?

**Answer:** LQUA holds quants, one row per material, batch and special stock combination in a bin. LAGP holds the bin itself, with its capacity and blocking indicators. Join the two on warehouse number, storage type and bin to see what is stored where.

#### Where do I find open warehouse tasks in EWM?

**Answer:** Open warehouse tasks sit in /SCWM/ORDIM_O and move to /SCWM/ORDIM_C when confirmed. Warehouse orders that group tasks for a resource are in /SCWM/WHO. The warehouse monitor, transaction /SCWM/MON, reads all of these for you.

#### Can I use SE16N on these tables in production?

**Answer:** Technically yes if you have the authorisation, but many companies restrict it. Prefer a standard report, the warehouse monitor or an approved ABAP report. Always filter by warehouse number to avoid long running queries.

#### Are the tables the same in S/4HANA?

**Answer:** Classic WM tables still exist in S/4HANA but WM is on the path to being replaced by embedded EWM. Embedded EWM uses the /SCWM/ tables in the same system. Check the simplification list for your target release.

## Search terms

sap wm tables, sap ewm tables list, LQUA table sap, LAGP table sap, LTAP table sap, /SCWM/ORDIM_O, sap warehouse management tables, sap ewm warehouse task table

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json