SAP WM / EWM Table Relationships

An interactive reference showing how SAP Warehouse Management (classic WM) and Extended Warehouse Management (EWM) tables connect across transfer orders, stock, handling units, storage bins and warehouse structure - in SAP ECC, SAP S/4HANA and embedded EWM.

SAP warehouse data lives in two parallel table sets: classic WM (LTAK/LTAP/LQUA and related tables, still used in many ECC and S/4HANA landscapes) and Extended Warehouse Management (EWM), which uses a separate /SCWM/ namespace and is the strategic platform in S/4HANA. Understanding how these tables join together - and which set applies to your warehouse - is essential for building stock-accuracy dashboards, pick-productivity reports, slotting analytics and dock-to-stock cycle-time analyses.

Use the diagram below to explore table relationships visually, or scroll to the quick-reference guide for a complete list of tables, join keys and system compatibility. Note that EWM tables (/SCWM/ namespace) only exist in S/4HANA or decentralised EWM systems; classic WM exists in both ECC and S/4HANA.

Read the Full Blog Post

Interactive Data Model

Hover over any table to see its description, key fields and system compatibility. Dashed red borders indicate S/4HANA-specific tables; purple borders indicate EWM (/SCWM/) tables which only exist in S/4HANA or decentralised EWM.

WM Transaction

Master Data

EWM (S/4HANA)

S/4HANA

Configuration

Quick-Reference Guide

All SAP WM and EWM tables shown above with their primary join keys and SAP system compatibility.

Table	Description	Primary Join Keys	System
WM Transfer Orders - Transactional
LTAK	Transfer Order Header	LGNUM, TANUM	ECC + S/4HANA
LTAP	Transfer Order Item	LGNUM, TANUM, TAPOS	ECC + S/4HANA
LTBK	Transfer Requirement Header	LGNUM, TBNUM	ECC + S/4HANA
LTBP	Transfer Requirement Item	LGNUM, TBNUM, TBPOS	ECC + S/4HANA
WM Stock - Transactional
LQUA	Quant (stock in bin)	LGNUM, LQNUM	ECC + S/4HANA
LEIN	Storage Unit Header	LGNUM, LENUM	ECC + S/4HANA
WM Master Data
LAGP	Storage Bins	LGNUM, LGTYP, LGPLA	ECC + S/4HANA
Material Documents (Goods Movements)
MKPF	Material Document Header	MBLNR, MJAHR	ECC (compat view in S/4)
MSEG	Material Document Items	MBLNR, MJAHR, ZEILE	ECC
MATDOC	Universal Material Document (replaces MKPF+MSEG)	MBLNR, MJAHR, ZEILE	S/4HANA
Material Master
MARA	Material Master - General	MATNR	ECC + S/4HANA
MARC	Material - Plant Data	MATNR, WERKS	ECC + S/4HANA
MARD	Storage Location Stock (LABST, INSME, SPEME)	MATNR, WERKS, LGORT	ECC + S/4HANA
MCHA	Batches (per plant)	MATNR, WERKS, CHARG	ECC + S/4HANA
EWM (/SCWM/ namespace)
/SCWM/ORDIM_O	EWM Warehouse Task (open)	LGNUM, TANUM, TAPOS	S/4HANA
/SCWM/ORDIM_C	EWM Warehouse Task (confirmed)	LGNUM, TANUM, TAPOS	S/4HANA
/SCWM/HUHDR	Handling Unit Header (HUIDENT)	GUID_HU	S/4HANA
/SCWM/QUAN	EWM Quants (stock on hand)	LGNUM, CAT, STOCK_TYPE, OWNER	S/4HANA
/SCWM/PRDO	EWM Outbound Delivery Order	DOCID	S/4HANA
/SCWM/PRDI	EWM Inbound Delivery Order	DOCID	S/4HANA
/SCWM/LAGP	EWM Storage Bins	LGNUM, LGPLA	S/4HANA
Configuration
T001L	Storage Locations	WERKS, LGORT	ECC + S/4HANA
T001W	Plants	WERKS	ECC + S/4HANA
T300	WM Warehouse Numbers	LGNUM (WERKS)	ECC + S/4HANA
T320	Storage Location / Warehouse Assignment	WERKS, LGORT, LGNUM	ECC + S/4HANA

Related Resources

Explore more SAP content from DVW Analytics.

SAP WM/EWM Tables Blog Post

Detailed descriptions of every table shown in this diagram, with practical tips for building warehouse analytics workflows.

DVW Help Centre

Guides and documentation for the DVW Connector for SAP, DVW Flow Tool and other DVW products. Available to free trial and paid users.

Try it free for 30 days

Free 30-day trial. Full functionality. No commitment.

Start Your Free Trial

Watch demos View pricing Talk to our team