Eursap’s Tip of the Week: A quick way to get a list of customer name and addresses in Fiori and SAP GUI
Running SQVIs, CDS views or SQ01s to get your customer details from your system? No need – SAP has a simple customer address list transaction as well as a useful Fiori app. This can be run to get a list of customer name and addresses in normal ABAP list format, ALV format, word processing format or spreadsheet format.
The transaction is available in ERP6.0 systems as well as S/4HANA, so works with business partners as well as customers.
The Fiori app is only available in S/4HANA, from version 1709 onwards.
The Fiori app is “Display Customer List” and is a standard app with filter selections in the usual Fiori format:
The settings button on the right just above the output allows you to view any of the customer master fields in the output.
The GUI transaction is S_ALR_87012180:
To be able to select only customers based on attributes other than the customer number, select the Dynamic Selections button to show additional parameters to select by:
Unlike the Fiori app, this is a transaction which is designed to show names and addresses. The selection parameters available are restricted to the customer central data.
Similarly, the output itself is restricted to basic name and address fields as below:
I hope you find this useful! Stay tuned for another SAP Tip from Eursap next week!
Be sure to also check out Eursap’s SAP Blog for more in depth articles.