Aggregate purchase-order net value and quantity by vendor and material group for spend analysis.
| Vendor | Vendor Name | Material Group | Mat Group Text | Purch Org | Company Code | Currency | Net Value |
|---|---|---|---|---|---|---|---|
| 100200 | Atlas Supplies Ltd | 2000 | Brightway Components | S10 | 1000 | EUR | 412,300.00 |
| 100483 | Northgate Industrial | S10 | Northgate Industrial | P01 | 2000 | USD | 212,937.00 |
| 100766 | Harbor Logistics BV | P01 | Summit Fasteners Inc | P01 | 2000 | USD | 105,574.00 |
| 101049 | Meridian Parts Co | P01 | Atlas Supplies Ltd | S10 | 1000 | EUR | 412,711.00 |
| 101332 | Lakeshore Retail Group | P01 | Lakeshore Retail Group | S10 | 1000 | EUR | 9,168.00 |
| 101615 | Harbor Logistics BV | S10 | Brightway Components | P01 | 1000 | EUR | 105,985.00 |
| 101898 | Meridian Parts Co | 2000 | Meridian Parts Co | 2000 | 1000 | USD | 213,622.00 |
Connects read-only inside your own SAP session — your business data is never changed.
Your filters run inside SAP, so only matching rows ever travel the wire.
The engine links every source table on the correct key fields, automatically.
Raw SAP codes are resolved into readable names and descriptions on the way out.
Formatted rows land in your sheet, guarded by a max-row limit for fast first runs.
The report keeps its selection — one click pulls the latest data, any time.
Pre-selected key fields with text lookups resolved — customize freely.
Key relationships resolved automatically. Joins, text lookups and filter push-down are engineered by SAP solution architects — zero ABAP on your side.
Excel add-in, read-only in your own SAP session, live data in minutes. ECC & S/4HANA.
Purchasing Spend Analysis condenses what procurement and supply-chain teams usually chase across multiple SAP screens into a single sheet: aggregate purchase-order net value and quantity by vendor and material group for spend analysis. Rather than working through transactions one object at a time, you get 17 pre-selected columns side by side — keys, descriptions and organizational context in one place, ready to filter, pivot and share.
The usual route to this data is ME2L or ME81N for the on-screen view, followed by SE16 downloads of EKPO, EKKO, LFA1 stitched together in Excel. Each export is a snapshot: text fields arrive as codes, the joins are rebuilt by hand, and by the time the workbook reconciles, the numbers are already a day old. Multiply that by every month-end or every expediting run, and the report becomes a job of its own.
In PostNow the report ships ready to run. The 4 underlying tables (EKPO, EKKO, LFA1, T023T) are already joined on the correct key fields, code values are resolved into plain-language texts, and results land directly in Excel. Every run is read-only inside your own SAP session — the engine reads data, it never changes it. Refresh whenever you need a current version, tighten the filters, or use the report as a starting point and adjust columns in the visual builder. It behaves identically on SAP ECC and S/4HANA.
It joins 4 tables — EKPO, EKKO, LFA1, T023T — on their standard key fields. Text and check tables are resolved automatically, so the output shows readable names and descriptions instead of raw codes, and the 17 delivered columns can be extended in the visual builder if you need more.
Transactions like ME2L and ME81N show the data on screen, but a clean Excel extract from them means manual exports and re-formatting every time. PostNow reads the same tables through standard interfaces — no ABAP, no transports. You pick the report in the Excel add-in, set filters such as company code and date range, and the joined result is written straight into your sheet. Every run is read-only and happens inside your own SAP session — nothing is ever written back.
Yes. Every report has selection filters with SAP value help, so you can narrow by company code, posting or document dates, plants, accounts and more before anything is fetched. A max-rows guard keeps first runs fast, and once the selection looks right you can widen it and refresh — the report remembers your filters.
This preview uses sample data. Run the real thing from Excel in minutes — read-only, in your own SAP session.