In this blog we identify the most important SAP Warehouse Management (WM) and Extended Warehouse Management (EWM) tables for users of:
SAP warehouse data lives in two parallel table sets. Classic WM (LTAK, LTAP, LQUA and their related tables) is still used in many SAP ECC and SAP S/4HANA landscapes. Extended Warehouse Management (EWM) sits in its own /SCWM/ namespace and is the strategic warehousing platform in SAP S/4HANA. Understanding which set applies to your site is essential for stock accuracy, pick productivity, slotting and dock-to-stock analytics. SAP Warehouse Management tables are found in the following SAP systems:
The /SCWM/ tables exist only in SAP S/4HANA or decentralised EWM systems. The classic WM (L*) tables exist in both SAP ECC and SAP S/4HANA. Classic Warehouse Management (WM) TablesClassic WM uses the L* table family to record transfer orders, transfer requirements, bin-level stock and warehouse master data. These tables are available in both SAP ECC and SAP S/4HANA and remain the backbone of warehouse reporting for sites that have not yet migrated to EWM. Transfer Order TablesLTAK - Transfer Order Header. Contains one row per transfer order with fields such as warehouse number (LGNUM), transfer order number (TANUM) and movement type (BWLVS). The source storage type (VLTYP) and destination storage type (NLTYP) describe the physical movement. This is your starting point for all transfer order analysis including picking, putaway and replenishment. LTAP - Transfer Order Item. Contains one row per line item within each transfer order. Key fields include warehouse number (LGNUM), transfer order number (TANUM), item number (TAPOS), material (MATNR), batch (CHARG), source storage type (VLTYP), destination storage type (NLTYP) and source quantity (VSOLM). Join to LTAK on LGNUM and TANUM to build a complete transfer order dataset. LTBK - Transfer Requirement Header. Contains one row per transfer requirement with fields such as warehouse number (LGNUM) and transfer requirement number (TBNUM). Transfer requirements are the planned demand that triggers transfer orders, so this table is important for understanding backlog and open workload. LTBP - Transfer Requirement Item. Contains one row per line item within each transfer requirement. Key fields are warehouse number (LGNUM), transfer requirement number (TBNUM) and item number (TBPOS). Join to LTBK on LGNUM and TBNUM for open demand reporting. WM Stock TablesLQUA - Quant / Stock in Bin. Contains one row per quant, which is the unit of stock of a given material in a specific bin. Key fields include warehouse number (LGNUM), quant number (LQNUM), material (MATNR), batch (CHARG), total quantity (GESME), available quantity (VERME), storage type (LGTYP) and storage bin (LGPLA). This is the primary table for bin-level stock reporting, slotting analysis and cycle count preparation. LEIN - Storage Unit Header. Contains one row per storage unit with fields such as warehouse number (LGNUM), storage unit number (LENUM), storage unit type (LEART) and current bin (LGPLA). Use this table where storage unit management is active, for example on pallet-based operations. WM Master Data TablesLAGP - Storage Bins. Contains one row per storage bin with fields such as warehouse number (LGNUM), storage type (LGTYP) and bin coordinate (LGPLA). Join to LQUA on LGNUM, LGTYP and LGPLA to enrich stock data with bin attributes such as section, picking area and bin type. Extended Warehouse Management (EWM) TablesEWM tables live in the /SCWM/ namespace and are only present in SAP S/4HANA (embedded EWM) or decentralised EWM systems. The object model is richer than classic WM, with warehouse tasks, handling units and delivery order documents replacing transfer orders and deliveries. EWM Warehouse Task Tables/SCWM/ORDIM_O - Open Warehouse Task. Contains one row per open task line with key fields task number (TANUM) and task item (TAPOS). Use this table to measure open pick, putaway and replenishment workload in real time. /SCWM/ORDIM_C - Confirmed Warehouse Task. Contains one row per confirmed task line with key fields task number (TANUM) and task item (TAPOS). This is the historical record of completed work and is the starting point for productivity, travel time and dock-to-stock analytics. EWM Stock and HU Tables/SCWM/HUHDR - Handling Unit Header. Contains one row per handling unit with key field GUID_HU. The external handling unit number (HUIDENT) is the readable identifier used on labels and scanning devices. Essential for any pallet or tote-level reporting. /SCWM/QUAN - EWM Quants / Stock. Contains one row per quant of stock in EWM. Key fields include warehouse number (LGNUM), stock category (CAT), stock type (STOCK_TYPE) and owner (OWNER). The record carries material identifier (MATID), external handling unit number (HUIDENT) and quantity (QUAN). This is the primary table for EWM stock reporting. /SCWM/LAGP - EWM Storage Bins. Contains one row per EWM bin with key fields warehouse number (LGNUM) and bin (LGPLA). Join to /SCWM/QUAN to enrich stock data with EWM bin attributes. EWM Delivery Tables/SCWM/PRDO - EWM Outbound Delivery Order. Contains one row per outbound delivery order header with key field DOCID. This is the EWM equivalent of the ERP outbound delivery and is the starting point for outbound flow analytics in EWM sites. /SCWM/PRDI - EWM Inbound Delivery Order. Contains one row per inbound delivery order header with key field DOCID. Use this table for goods receipt, putaway lead time and supplier on-time analytics in EWM. Material Document TablesMaterial documents record every inventory movement in SAP and are the reconciliation point between warehouse transactions and inventory accounting. They apply to both classic WM and EWM sites. MKPF - Material Document Header. Contains one row per material document with key fields document number (MBLNR) and document year (MJAHR). Use this as the header for all goods movement reporting in SAP ECC. MSEG - Material Document Items. Contains one row per material document line item with key fields document number (MBLNR), document year (MJAHR) and item number (ZEILE). Join to MKPF on MBLNR and MJAHR for complete movement-level reporting. MATDOC - Universal Material Document (SAP S/4HANA). In SAP S/4HANA, MATDOC replaces MKPF and MSEG as the single source of truth for material movements. Key fields are document number (MBLNR), document year (MJAHR) and item number (ZEILE). SAP also exposes compatibility views named MKPF and MSEG on top of MATDOC, so legacy queries continue to work, but new S/4HANA analytics workflows should target MATDOC directly for performance and to access the extended field set. Material Master TablesMaterial master data is spread across several tables in SAP, each holding a different slice of the material record. Together they provide the dimensional context for warehouse and stock reporting. MARA - Material Master: General Data. Contains client-level material data with key field material number (MATNR). Typical fields include material type, material group and base unit of measure. This is your primary material dimension table. MARC - Material Plant Data. Contains material data specific to a plant with key fields material number (MATNR) and plant (WERKS). Includes fields such as MRP controller, procurement type and ABC indicator. Join to MARA on MATNR. MARD - Storage Location Stock. Contains stock quantities per material, plant and storage location with key fields material number (MATNR), plant (WERKS) and storage location (LGORT). Key stock fields are unrestricted use stock (LABST), quality inspection stock (INSME) and blocked stock (SPEME). MARD is the aggregate counterpart to the bin-level stock held in LQUA and /SCWM/QUAN. MCHA - Batches per Plant. Contains one row per batch at a plant with key fields material number (MATNR), plant (WERKS) and batch (CHARG). Important wherever batch management is active, for example pharmaceuticals, food and chemicals. WM Configuration TablesConfiguration tables (also known as customising tables) define the plants, storage locations and warehouses in your system and how they are connected. These tables are small and slowly changing, and they are essential for decoding the values in transaction and master data tables. The configuration tables listed below apply to both SAP ECC and SAP S/4HANA. T001L - Storage Locations. Contains one row per storage location with key fields plant (WERKS) and storage location (LGORT). Join to MARD to decode storage location codes in stock reports. T001W - Plants. Contains one row per plant with key field plant (WERKS). Useful for filtering and grouping data by plant in multi-site warehouse reports. T300 - WM Warehouse Numbers. Contains one row per classic WM warehouse number with key field warehouse number (LGNUM) and linked plant (WERKS). Use this table to translate warehouse numbers into readable site labels. T320 - Storage Location / Warehouse Assignment. Contains one row per link between a storage location and a WM warehouse number, with key fields plant (WERKS), storage location (LGORT) and warehouse number (LGNUM). This is the bridge between MM storage location stock (MARD) and WM bin-level stock (LQUA). Explore SAP WM and EWM Tables with a DVW ConnectorThe fastest way to explore SAP WM and EWM tables is to connect directly to your SAP system from your preferred analytics platform. DVW Connectors let you browse available tables, preview fields and extract data without writing any ABAP code. All DVW products support classic WM and EWM across SAP ECC and SAP S/4HANA. To see how all 25 tables in this blog connect to each other, visit our SAP WM / EWM Table Relationships page for an interactive data model diagram with join keys and ECC vs S/4HANA compatibility. All DVW products include a 30-day free trial with full functionality, so you can start working with these tables right away. Visit our Free Trial page to get started, or explore our Help Centre for detailed documentation on connecting to SAP WM and EWM tables. Next StepsSee these SAP WM and EWM tables in action. Register for a 30-day free trial and start extracting warehouse, transfer order and stock data from your SAP system today. Comments are closed.
|
Categories
All
Archives
May 2026
|
RSS Feed