SAP Inventory Management Table Relationships

An interactive reference showing how SAP Inventory Management tables connect across goods movements, stock levels, material master data and configuration - in both SAP ECC and SAP S/4HANA.

The SAP Inventory Management module stores inventory data across dozens of related tables. Understanding how these tables join together is essential for building accurate stock reporting, goods movement analysis and inventory valuation workflows. This page provides an interactive diagram and a quick-reference table covering the full inventory data model, including the MATDOC changes introduced in SAP S/4HANA.

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.

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.

Transaction

Master Data

Stock Tables

Configuration

S/4HANA

Hover over any box in the diagram to reveal table descriptions, key fields and system compatibility. Green dashed lines show cross-references between sections; red dashed boxes indicate S/4HANA-specific tables.

Quick-Reference Guide

All SAP Inventory Management tables with their primary join keys and SAP system compatibility.

Table	Description	Primary Join Keys	System
Transaction - Material Documents
MKPF	Material Document Header	MBLNR (Doc #), MJAHR (Year)	ECC + S/4HANA
MSEG	Material Document Line Item	MBLNR, MJAHR, ZEILE (Line)	ECC + S/4HANA
Transaction - Material Valuation
MBEW	Material Valuation	MATNR (Material), BWKEY (Val. Area)	ECC + S/4HANA
MBEWH	Material Valuation History	MATNR, BWKEY, LFMON (Period)	ECC
Transaction - Physical Inventory
IKPF	Physical Inventory Doc Header	IBLNR (Doc #), GJAHR (Year)	ECC + S/4HANA
ISEG	Physical Inventory Doc Item	IBLNR, GJAHR, IPOS (Line)	ECC + S/4HANA
Stock Tables
MARD	Storage Location Stock	MATNR, WERKS (Plant), LGORT (Storage Loc.)	ECC + S/4HANA
MCHB	Batch Stocks	MATNR, WERKS, CHARG (Batch)	ECC + S/4HANA
MSLB	Vendor Special Stock	MATNR, WERKS, LGORT, LIFNR (Vendor)	ECC + S/4HANA
MSKU	Customer Special Stock	MATNR, WERKS, LGORT, KUNNR (Customer)	ECC + S/4HANA
MSKA	Sales Order Stock	MATNR, WERKS, LGORT, VBELN (SO #)	ECC + S/4HANA
Master Data - Material Master
MARA	General Material Data	MATNR	ECC + S/4HANA
MAKT	Material Descriptions	MATNR, SPRAS (Language)	ECC + S/4HANA
MARC	Plant Data	MATNR, WERKS	ECC + S/4HANA
MARM	Units of Measure	MATNR, MEINH (UoM)	ECC + S/4HANA
MVKE	Sales Data	MATNR, VKORG (Sales Org.), VTWEG (Dist. Channel)	ECC + S/4HANA
Master Data - Batches
MCH1	Batches - Material Level	MATNR, CHARG	ECC + S/4HANA
MCHA	Batches - Plant Level	MATNR, WERKS, CHARG	ECC + S/4HANA
S/4HANA
MATDOC	Material Document (Unified)	MATDOCID, MATLEVEL (Material), DOCTYPE	S/4HANA
NSDM_V_MSEG	MSEG Compatibility View (replaces MSEG in S/4HANA)	MBLNR, MJAHR, ZEILE	S/4HANA
Configuration
T001W	Plants (Werke)	WERKS	ECC + S/4HANA
T001L	Storage Locations	WERKS, LGORT	ECC + S/4HANA
T001K	Valuation Areas	BWKEY	ECC + S/4HANA
T023/T023T	Material Groups	MATKL	ECC + S/4HANA
T134/T134T	Material Types	MTART	ECC + S/4HANA
T156/T156T	Movement Types	BWART	ECC + S/4HANA

Related Resources

Explore more SAP content from DVW Analytics.

SAP Inventory Management Tables Blog Post

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

Read the Article

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.

Visit Help Centre

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