In this blog we identify the most important SAP Purchasing (MM-PUR) tables for users of:
See these tables read from SAP in one flow, then reconciled in two front ends off it: line by line in Power BI, and again in a web app built with AI. Also available on YouTube. These tables cover the full procure-to-pay lifecycle, from purchase requisitions and purchase orders through to goods receipts and invoice verification, along with the vendor master data, purchasing info records and configuration tables you will need to build complete procurement reporting and analytics workflows. SAP Purchasing (MM-PUR) tables are found in the following SAP systems:
SAP Purchasing (MM-PUR) Transaction TablesPurchase Requisition TablesPurchase requisitions are internal documents requesting the procurement of materials or services. They are created manually by users or generated automatically by MRP. EBAN - Purchase Requisition Item. Contains one row per requisition item with fields such as requisition number (BANFN), item number (BNFPO), material number (MATNR), plant (WERKS), requested quantity (MENGE), delivery date (LFDAT), requisition date (BADAT) and requisition type. This is your starting point for any procurement demand analysis. In S/4HANA, EBAN continues to be the primary purchase requisition table with the same structure. EBKN - Purchase Requisition Account Assignment. Contains account assignment details for each requisition item, including cost center (KOSTL), GL account (SAKTO), WBS element (PS_PSP_PNR) and order number (AUFNR). Join to EBAN on BANFN and BNFPO. Essential for analyzing procurement spend by cost object. Purchase Order TablesThe purchase order is the central transaction document in SAP Purchasing. It is created to formalise the procurement of materials or services from a vendor. SAP stores purchase order data across a header table, item table, scheduling table, history table and account assignment table. EKKO - Purchasing Document Header. Contains one row per purchasing document with fields such as document number (EBELN), document type (BSART), vendor number (LIFNR), purchasing organization (EKORG), purchasing group (EKGRP), document date (BEDAT) and currency (WAERS). This covers purchase orders, scheduling agreements and contracts. This is typically your primary purchasing transaction header table. EKPO - Purchasing Document Item. Contains one row per line item within each purchasing document. Key fields include document number (EBELN), item number (EBELP), material number (MATNR), plant (WERKS), ordered quantity (MENGE), net price (NETPR), price unit (PEINH) and item category (PSTYP). Join to EKKO on EBELN. This is where material-level purchasing detail lives. EKET - Scheduling Agreement Schedule Lines. Contains delivery schedule lines for each purchasing document item. Key fields include document number (EBELN), item number (EBELP), schedule line number (ETENR), delivery date (EINDT) and scheduled quantity (MENGE). Join to EKPO on EBELN and EBELP. Important for tracking delivery schedules against purchase orders and scheduling agreements. EKBE - History per Purchasing Document. Contains the complete history of goods receipts, invoice receipts and other follow-on documents for each purchasing document item. Key fields include document number (EBELN), item number (EBELP), history category (VGABE), material document number (BELNR), fiscal year (GJAHR), quantity (MENGE) and amount (WRBTR). Join to EKPO on EBELN and EBELP. Essential for purchase order completion analysis, three-way matching and GR/IR reconciliation. The history category (VGABE) distinguishes goods receipts (1), invoice receipts (2), and other document types. EKKN - Account Assignment in Purchasing Document. Contains account assignment details for each purchasing document item, including cost center (KOSTL), GL account (SAKTO), WBS element (PS_PSP_PNR), internal order (AUFNR) and asset number (ANLN1). Join to EKPO on EBELN and EBELP. Use this for procurement spend analysis by cost object. Goods Receipt TablesWhen goods are received against a purchase order, SAP creates a material document. The same MKPF and MSEG tables used in SAP Inventory Management record these goods receipt movements. MKPF - Material Document Header. Contains one row per material document with fields such as document number (MBLNR), document year (MJAHR), posting date (BUDAT) and user name (USNAM). Join to MSEG on MBLNR and MJAHR. In a purchasing context, filter for goods receipt movement types (such as 101 and 103) to isolate purchase order receipts. MSEG - Material Document Line Item. Contains one row per line item within each material document. Key fields include document number (MBLNR), year (MJAHR), line item (ZEILE), material number (MATNR), plant (WERKS), storage location (LGORT), movement type (BWART), quantity (MENGE) and purchase order reference (EBELN, EBELP). The purchase order fields allow you to join goods receipt lines back to EKPO for complete procurement tracking. In S/4HANA, MSEG exists as a compatibility view over MATDOC. Invoice Verification TablesInvoice verification (also known as logistics invoice verification or LIV) is the final step in the procure-to-pay cycle. When a vendor invoice is received, SAP records it against the corresponding purchase order. RBKP - Document Header: Invoice Receipt. Contains one row per invoice document with fields such as document number (BELNR), fiscal year (GJAHR), invoice date (BLDAT), posting date (BUDAT), vendor number (LIFNR), gross amount (RMWWR) and currency (WAERS). This is your starting point for accounts payable and invoice analysis. RSEG - Document Item: Incoming Invoice. Contains one row per line item within each invoice document. Key fields include document number (BELNR), fiscal year (GJAHR), line item (BUZEI), purchase order number (EBELN), purchase order item (EBELP), amount (WRBTR) and quantity (MENGE). Join to RBKP on BELNR and GJAHR. Join to EKPO on EBELN and EBELP to link invoices back to purchase orders for three-way match reporting. SAP Purchasing (MM-PUR) Master Data TablesPurchasing Info Record TablesPurchasing info records store the relationship between a material and a vendor, including pricing, lead times and purchasing conditions. They are maintained per purchasing organization. EINA - Purchasing Info Record: General Data. Contains one row per material-vendor combination with fields such as info record number (INFNR), vendor number (LIFNR), material number (MATNR) and material group (MATKL). This is the general (cross-purchasing-organization) level of the info record. EINE - Purchasing Info Record: Purchasing Organization Data. Contains purchasing organization-specific data for each info record, including net price (NETPR), price unit (PEINH), planned delivery time (APLFZ), minimum order quantity (MINBM) and effective price date. Join to EINA on INFNR. This table is essential for analyzing vendor pricing and lead times by purchasing organization. Vendor Master Tables (SAP ECC)In SAP ECC, vendor master data is stored in a set of LF* tables. These tables also exist in SAP S/4HANA as compatibility views, so queries against them will continue to work. However, the underlying data in S/4HANA is stored in the Business Partner tables described below. LFA1 - Vendor Master (General Section). Contains client-level vendor data that is not specific to any company code or purchasing organization. Key fields include vendor number (LIFNR), name (NAME1), country (LAND1), city (ORT01) and address number (ADRNR). This is typically your primary vendor dimension table. LFB1 - Vendor Master (Company Code). Contains vendor data specific to a company code, such as reconciliation account (AKONT), payment terms (ZTERM) and payment methods (ZWELS). Join to LFA1 on LIFNR. LFM1 - Vendor Master (Purchasing Organization). Contains vendor data specific to a purchasing organization, including order currency (WAERS), payment terms (ZTERM), incoterms (INCO1) and planned delivery time (APLFZ). Join to LFA1 on LIFNR. This is the purchasing-specific view of the vendor master. LFBK - Vendor Master (Bank Details). Contains bank account details for each vendor, including bank country (BANKS), bank key (BANKL), bank account number (BANKN) and IBAN. Join to LFA1 on LIFNR. Used in payment processing and bank detail reporting. ADRC - Address Data. Contains detailed address information including street, city, postal code, region and country. Join to LFA1 using the address number (ADRNR) to enrich vendor data with full address details for geographic and spend-by-region reporting. Business Partner Tables (SAP S/4HANA)In SAP S/4HANA, SAP replaced the separate customer and vendor master data models with a unified Business Partner (BP) model. All vendors are now created as Business Partners first, with Customer Vendor Integration (CVI) mapping them to the traditional LIFNR vendor number. If you are building analytics workflows against an S/4HANA system, you should be aware of the following tables: BUT000 - Business Partner: General Data. The S/4HANA equivalent of LFA1. Contains one row per Business Partner with fields such as partner number (PARTNER), name (NAME_ORG1 for organizations, NAME_FIRST / NAME_LAST for persons), partner type and creation date. This is the central table in the BP model. BUT020 - Business Partner: Address Data. Contains address assignments for each Business Partner, linking to ADRC for the full address details. Join to BUT000 on PARTNER. In S/4HANA this replaces the direct LFA1-to-ADRC relationship used in ECC. CVI_VEND_LINK - Customer Vendor Integration: Vendor Link. Maps a Business Partner number (PARTNER) to the traditional vendor number (LIFNR). This is the bridge table that allows you to join S/4HANA Business Partner data back to legacy vendor numbers used in purchasing transaction tables such as EKKO. SAP Purchasing (MM-PUR) Configuration Data TablesConfiguration tables (also known as customizing tables) contain the settings and descriptions that define how your SAP Purchasing module behaves. These are small, slowly changing tables that are useful for decoding the values stored in transaction and master data tables. The configuration tables listed below apply to both SAP ECC and SAP S/4HANA. T024 - Purchasing Groups. Contains the list of purchasing groups configured in your system. Each purchasing group represents a buyer or group of buyers responsible for specific procurement activities. Join to EKKO or EKPO using the purchasing group field (EKGRP) to decode buyer assignments in your reports. T024E - Purchasing Organizations. Contains the list of purchasing organizations configured in your system. Join to EKKO using the purchasing organization field (EKORG) to decode organizational assignments. T161 - Purchasing Document Types. Contains the list of purchasing document types configured in your system (such as standard purchase order, framework order, scheduling agreement). Join to EKKO using the document type field (BSART) to decode document types in your reports. T161T - Purchasing Document Types: Texts. Contains the language-specific descriptions for each purchasing document type. Join to T161 on BSART and filter by language key (SPRAS) to get readable labels. SAP S/4HANA Changes for PurchasingMost SAP Purchasing tables remain the same in S/4HANA, but there are two important changes that affect analytics users. MATDOC - Material Document (S/4HANA). In S/4HANA, MATDOC replaces MKPF and MSEG as the primary table for material documents. MATDOC combines header and item data into a single table, making it simpler to query goods receipt data. Key fields are the same as MKPF and MSEG combined: document number (MBLNR), year (MJAHR), line item (ZEILE), material number (MATNR), plant (WERKS), movement type (BWART), quantity (MENGE) and purchase order reference (EBELN, EBELP). NSDM_V_MSEG - Compatibility View for MSEG (S/4HANA). In S/4HANA, NSDM_V_MSEG is a CDS view that provides backwards compatibility with the classic MSEG structure. If your existing reports or workflows query MSEG, they will typically be redirected to this view automatically. For new development against S/4HANA, use MATDOC directly for better performance. Explore SAP Purchasing Tables with a DVW ConnectorThe fastest way to explore SAP Purchasing 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 both SAP ECC and SAP S/4HANA. To see how all 27 tables in this blog connect to each other, visit our SAP Purchasing 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 Purchasing tables. Next StepsSee these SAP Purchasing tables in action. Register for a 30-day free trial and start extracting procurement and purchasing data from your SAP system today. Comments are closed.
|