Article Overview:
This article explains how to export purchasing data from SAP within 5 minutes.
For this, the transaction ME80FN is used.
Since suppliers and materials are only displayed as IDs in this report, the corresponding name mappings also need to be exported — either via SE16 / SE16N or, if those are not available, via MKVZ and MM60.
Steps for Data Export
Step 1: ME80FN
Open transaction ME80FN
Apply filters (e.g., document date and document type)
Execute the transaction
Export to Excel
Step 2: Option 1 – SE16 or SE16N
Open SE16 or SE16N
Select table LFA1
Remove the maximum hit limit and restrict field selection
Execute the transaction
Export to Excel
Open SE16 or SE16N again and select table MAKT
Filter by language = German
Remove the maximum hit limit and execute
Export to Excel
Open SE16 or SE16N again and select table T023T
Filter by language = German
Remove the maximum hit limit and execute
Export to Excel
Step 2: Option 2 – MKVZ and MM60
Open MKVZ
Execute the transaction
Restrict layout to ID and Name
Download Excel file
Open MM60
Execute the transaction
Restrict layout to ID and Description
Download Excel file
Step 3: SE16 or SE16N
Open SE16 or SE16N and select table EKKO
Reset field selection
Limit field selection to document number and payment terms
Remove maximum number of hits and execute transaction
Export Excel
