SAP Purchase Order Report: Purchase Order 360

What this report answers

PostNow.ai's Purchase Order 360 (MM-05) puts the header, the item, the schedule line and the PO history of each order on one row set, with vendor, material, plant and organisation names resolved. Buyers and AP use it for:

• Expediting. Which schedule lines are past their delivery date and still not fully received?
• Open quantities. What is still to come per vendor, plant or material, against what was ordered?
• GR/IR follow-up. Which items were received but not invoiced, or invoiced ahead of the goods?
• Release and hygiene. Which POs are still waiting for release, and which items are deleted, blocked or delivery-completed but still show open quantities?

Header columns include PO number, document type, company code, purchasing org and group, vendor, currency, document date, created on and release indicator. Item columns include material, short text, plant, quantity, unit, net price and value, item category, delivery completed, final invoice, deletion indicator and material group. Schedule lines add delivery date, scheduled and received quantity; history adds category, document number, posting date, quantity and amount.

ME2N, ME2M and ME2L: the SAP standard way, and where it stops

PostNow.ai covers the same ground as the ME2 lists: ME2N lists purchasing documents by document number, ME2M by material, ME2L by vendor and ME2K by account assignment, and ME80FN is the flexible general analysis. The selection parameter field does the real work: WE101 gives open goods receipts, WE102 items with a goods receipt, WE103 open goods receipts counting GR blocked stock, and RECHNUNG open invoices. For GR/IR balances, MB5S lists them; on S/4HANA SAP also offers the Fiori apps Reconcile GR/IR Accounts (F3302) and Monitor GR/IR Account Reconciliation (F3303).

Each list answers one question at a time. Open quantity, PO history and vendor terms sit on different screens, the scope of WE101 depends on how it is set up in customizing, and putting header, schedule line and history side by side for a few hundred POs still means several exports joined in Excel.

SAP tables behind it: EKKO, EKPO, EKET and EKBE

PostNow.ai's MM-05 joins EKKO to EKPO on PO number, then EKET and EKBE to the item on PO number and item, and adds LFA1, MAKT, MARA, T001W, T001, T024, T024E and T161T for names and texts.

• EKKO is the header: document type BSART, document date BEDAT, purchasing org EKORG and group EKGRP, release indicator FRGKE and release status FRGZU.
• EKPO is the item: net order value NETWR, item category PSTYP, delivery completed ELIKZ, final invoice EREKZ and deletion indicator LOEKZ (L for deleted, S for blocked).
• EKET holds the schedule lines: delivery date EINDT, scheduled quantity MENGE and quantity received WEMNG, numbered by ETENR.
• EKBE is the PO history: category BEWTP (E goods receipt, Q invoice receipt, D service entry, A down payment), with the material or invoice document number, posting date, quantity, local-currency amount and a debit/credit indicator SHKZG.

Checks to run before you send it to buyers

1. One item, many rows. An item with two schedule lines and three history records appears on several rows, and Net Value repeats on each. Remove duplicates on PO number and item before you sum value, and count POs as distinct numbers.
2. Open quantity per schedule line. Scheduled quantity minus received quantity, compared with the delivery date, is your overdue list. Work it on the schedule line, not the item, or split deliveries hide.
3. Reversals in the history. A goods receipt reversal (movement type 102) is its own history record. The delivered history columns carry no debit/credit indicator, so have a designer add EKBE-SHKZG before you total history quantities, or a reversal adds instead of subtracting.
4. Deleted, blocked and completed items. Exclude LOEKZ L and S from open lists. Delivery completed means no further goods receipt is expected, even though one can still be posted, so treat the remainder as closed.
5. GR against IR. Compare category E and Q totals per item. Where they differ, the item belongs in your GR/IR reconciliation. The SAP invoice matching guide covers how the invoice is checked against the PO and the goods receipt.
6. Two currencies. Net Value is in the PO currency shown on the header; the history amount is in local currency. Do not add them together.

How PostNow.ai runs it

In PostNow.ai you run Purchase Order 360 from the Report Library in the Excel add-in and filter with SAP value help on PO number, document type, company code, purchasing org and group, vendor, plant, material, material group, document date, delivery date, created on, item category, deletion indicator and delivery completed. The rows land read-only from your own SAP session with names in place of codes. Save the selection to My Reports, or share it to Team Reports so every buyer refreshes the same expediting list. For the vendor terms behind each order, see Vendor Master Purchasing 360. To create the purchase orders themselves from Excel, see ME21N mass upload of purchase orders.