The most important SAP Purchasing (MM-PUR) tables for users of Alteryx, KNIME, Dataiku, Microsoft, Databricks, Snowflake & more

​In this blog we identify the most important SAP Purchasing (MM-PUR) 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 Purchasing (MM-PUR) tables are found in the following SAP systems:

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

---

SAP Purchasing (MM-PUR) Transaction Tables

SAP Purchasing Requisition Tables

• EBAN - Purchase Requisition
• EBKN - Purchase Requisition Account Assignment

SAP Purchase Order Tables

• EKKO - Purchasing Document Header
• EKPO - Purchasing Document Item
• EKBE - History per Purchasing Document
• EKKN - Account Assignment in Purchasing Document

SAP Goods Receipt Tables

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

SAP Invoice Receipt Tables

• RBKP - Document Header: Invoice Receipt
• RSEG - Document Item: Incoming Invoice

---

SAP Purchasing Master Data Tables

• LFA1 - Vendor / Supplier Master (General Section)
• LFB1 - Vendor Master (Company Code)
• LFBK - Vendor Master (Bank Details)

---

SAP Purchasing Configuration Data Tables

• T169G - Tolerance Limits, Invoice Verification
• TIBAN - IBAN

---

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