The most important SAP Inventory Management tables for users of Alteryx, KNIME, Dataiku, Microsoft, Databricks, Snowflake & more

​In this blog we identify the most important SAP Inventory Management tables for users of:

• Alteryx and the DVW Alteryx Connector for SAP
• KNIME and the DVW KNIME Connector for SAP
• Dataiku and the DVW Dataiku Connector for SAP
• Power BI, Tableau, Databricks, Snowflake and the DVW Flow Tool​

SAP Inventory Management tables are found in the following SAP systems:

• SAP ECC 
• SAP ERP
• SAP S/4HANA

---

SAP Inventory Management Transaction Tables

SAP Material Document Tables

• MKPF - Header: Material Document
• MSEG - Document Segment: Material

SAP Material Valuation Tables

• MBEW - Material Valuation
• ​MBEWH - Material Valuation: History

SAP Physical Inventory Document Tables

• IKPF - Header: Physical Inventory Document
• ​ISEG - Physical Inventory Document Items

---

SAP Inventory Management Master Data Tables

• MARA - General Material Data
• MAKT - Material Descriptions
• MARD - Storage Location Data for Material

---

SAP Inventory Management Configuration Tables

• T001K - Valuation area
• T023 and T023T - Material Groups and Material Group Descriptions
• T134 and T134T - Material Types and Material Type Descriptions
• T156 and T156T - Movement Type and Movement Type Text
• T188 and T188T - Conditions: Groups for Customer Classifications and Conditions: Groups for Customer Classes: Texts

---

Other Sources of SAP Table Information

Google is your best friend when searching for SAP Table data. Give it a go!

---

Next Steps

Register for a 30-day trial of our products.
​
Free Trial | Pricing | Contact Us