Surface likely duplicate vendor master records by grouping on name, country and VAT number and counting matching vendors.
| Vendor Name | Country Key | VAT Registration No. | Country Name | Vendor Count | Vendor Name | Country Key | VAT Registration No. |
|---|---|---|---|---|---|---|---|
| Brightway Components | 02 | 01 | Atlas Supplies Ltd | 100200 | Atlas Supplies Ltd | 01 | 03 |
| Northgate Industrial | 01 | Z1 | Vector Freight GmbH | 100483 | Vector Freight GmbH | 10 | 10 |
| Summit Fasteners Inc | 02 | 02 | Summit Fasteners Inc | 100766 | Summit Fasteners Inc | 02 | 10 |
| Atlas Supplies Ltd | 02 | 10 | Meridian Parts Co | 101049 | Meridian Parts Co | 01 | 01 |
| Vector Freight GmbH | 02 | 02 | Lakeshore Retail Group | 101332 | Vector Freight GmbH | Z1 | Z1 |
| Brightway Components | 10 | 02 | Brightway Components | 101615 | Harbor Logistics BV | 10 | Z1 |
| Meridian Parts Co | 10 | Z1 | Northgate Industrial | 101898 | Northgate Industrial | 02 | 10 |
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.
Duplicate Master Data (Vendors) condenses what process owners, analysts and auditors usually chase across multiple SAP screens into a single sheet: surface likely duplicate vendor master records by grouping on name, country and VAT number and counting matching vendors. Rather than working through transactions one object at a time, you get 9 pre-selected columns side by side — keys, descriptions and organizational context in one place, ready to filter, pivot and share.
Without a prebuilt report, this view is assembled by hand. You can display individual records in SE16 or XK03, but a complete extract usually means SE16 downloads of LFA1, T005T matched together on their key fields in Excel. The raw tables speak in codes rather than names, so someone maintains a lookup sheet on the side — and repeats the whole exercise every time an auditor, a migration project or a data-quality review asks for a current version.
In PostNow the report ships ready to run. The 2 underlying tables (LFA1, T005T) 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 2 tables — LFA1, T005T — 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 9 delivered columns can be extended in the visual builder if you need more.
Transactions like SE16 and XK03 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.
The report keeps its selection, so a refresh pulls the latest state of the data instead of restarting the export from scratch. That makes it practical to re-run before an audit walkthrough, during data-cleansing sprints, or as a recurring quality check — an SE16 dump is stale the moment it is saved; this is not.
This preview uses sample data. Run the real thing from Excel in minutes — read-only, in your own SAP session.