# SAP Procure-to-Pay (PTP) Reporting: Reports, Tcodes and Tables > Source: https://netray.co/erp-help/sap-ptp-reporting-procure-to-pay-reports-tcodes-tables > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer SAP procure-to-pay reporting spans requisition, PO, goods receipt, invoice and payment. Use ME2N for open POs, MB5S for GR/IR balances, MIR5 and MRBR for invoices, and FBL1N for vendor open items. For cycle time, join EBAN, EKKO, EKBE and RBKP. ## Kind how-to ## System sap ## Erp SAP ERP / S/4HANA ## Module MM / FI Procure-to-Pay Reporting ## Query sap ptp reporting ## Alternate Queries - sap procure to pay reports - sap open po report - sap gr/ir report MB5S - sap p2p cycle time report ## Applies To SAP ECC 6.0 and S/4HANA, standard MM and FI-AP ## Steps ### How to build a PTP reporting set **Items:** - Open purchase orders and undelivered items: ME2N, with scope for items not yet fully delivered. - Goods received not invoiced: MB5S for GR/IR analysis, then clear balances with MR11 after review. - Invoice status: MIR5 to list invoice documents, MRBR to release invoices blocked for price or quantity. - Vendor payables: FBL1N for vendor line items, with open items, due dates and payment status. - Receipts: MB51 with movement type 101 for goods receipts and 102 for reversals. - Cycle time and process analysis: join EBAN, EKKO, EKPO, EKBE, RBKP and RSEG in a query, or use process analytics apps on S/4HANA. ## Sections ### The key reports by stage **Body:** Requisition to PO: ME5A lists purchase requisitions and ME57 helps assign sources. A backlog here shows buyers who are behind. Table EBAN holds requisitions. PO to goods receipt: ME2N and ME2L show open quantities and delivery dates. MD04 shows planned receipts against requirements. EKET holds the schedule lines with delivery dates and EKES holds vendor confirmations. Goods receipt to invoice to payment: MB5S analyses GR/IR, MIR5 lists invoices, and FBL1N shows payables. The GR/IR account is a clearing account and its balance is the main control for this step. ### GR/IR and the three-way match **Body:** The GR/IR clearing account holds the value of goods received but not invoiced, and invoices received before goods. Large old balances usually mean missing invoices, wrong quantities or a PO posted in the wrong unit. Three-way match compares PO, goods receipt and invoice. Differences beyond the tolerance limits block the invoice, which then appears in MRBR. Tolerance limits are set in OMR6. A monthly review of old GR/IR items, grouped by vendor and age, is the standard control. Clearing without review writes off real liabilities. ### Cycle-time query across the tables **Body:** To measure PR to PO time, compare EBAN creation date to EKKO document date. PO to receipt uses EKKO and EKBE with history category E for goods receipt. Receipt to invoice uses EKBE category Q and the invoice header RBKP. The history table EKBE has a transaction type field VGABE: 1 for goods receipt and 2 for invoice receipt. Joining on it gives a per-PO timeline. **Code:** -- PO item timeline (illustrative) SELECT p.ebeln, p.ebelp, h.vgabe, h.budat, h.menge, h.dmbtr FROM ekpo p JOIN ekbe h ON h.ebeln = p.ebeln AND h.ebelp = p.ebelp WHERE h.vgabe IN ('1','2') ORDER BY p.ebeln, p.ebelp, h.budat ## Pitfalls - ME2N shows open quantities per item, not per schedule line. Late deliveries need schedule-line data from EKET. - Reversed goods receipts (movement 102) must be netted in cycle-time calculations. - Delivery-completed flags can hide partial deliveries. Check item status. - Invoices posted through FI without a PO do not appear in MM reports. - Currency and unit conversions affect GR/IR reconciliation. Compare in local currency and base unit. ## Ai Angle A PTP report set is a good fit for a grounded assistant because the questions are routine and the joins are tedious. Ask 'which vendors have GR/IR items older than 90 days' and get the list with the query shown. Read-only access and on-prem deployment keep supplier and pricing data private. ## Faq ### Which report shows open purchase orders in SAP? **Answer:** ME2N lists purchase orders with open quantities, and ME2L lists them by vendor. Use the selection scope for items not yet fully delivered. ### What is MB5S? **Answer:** MB5S analyses the GR/IR clearing account by PO, showing quantities and values received but not invoiced and the reverse. ### How do I see blocked invoices? **Answer:** Use MRBR to list and release invoices blocked for price, quantity or other tolerance differences. MIR5 lists all invoice documents. ### Which tables hold PO history? **Answer:** EKBE holds the PO history with goods receipts and invoice receipts, distinguished by field VGABE. EKKO and EKPO hold header and item data. ## Search terms sap ptp reporting, sap procure to pay reports, sap open po report ME2N, sap GR/IR report MB5S, sap invoice status report MIR5, sap p2p cycle time, sap EKBE history table, sap MRBR blocked invoices --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json