Table of contents
Scope
1. Remove the icon(s) when not applicable
2. Add countries when the procedure is for a specific country (optional)
ERP
3. Remove the icon(s) when not applicable
References
4. Add the link to SAP procedures (when it exists)
Attachments
5. Add the link to attachments (to be stored in AODocs or GDrive) or external links
Objective
This procedure explains how to extract data from the SAP system.
The extraction of data can be requested by all SOLVAY colleagues.
Tools
SE16
The most common transaction to extract data from the SAP system is the SE16. It can be used in all the systems.
Inserting a Table code it is possible to extract all the respective information.
In the vendors master data you can find the Table code that is linked to a specific field by clicking on the field and then clicking on the F1 key. It appears a new window. VAT ID example:
Then clicking in the button “Technical Information” 
the system will give the table code:
With the table code you will be able to use the transaction SE16:
The search fields can be added or removed. The change is performed in the “Settings” button, clicking in “Fields for Selection”:
Each search field will allow 16 different restrictive options:
NOTE: The transaction has an automatic search limite that must be removed for large reports. It can be seen at the bottom of the table window:
To data is extracted by clicking in the button EXECUTE 
.
EXAMPLE - Extract all the active German vendors, with "A" as first letter Name, from the city Berlin and with VAT ID:
| Search | Result |
|---|---|
|
|
To manage the columns in the file provided it is used the field “Change Layout” 
.
In the previous page this action can also be performed by clicking in the button “Settings”, then “Format List” and “Choose Fields:
To extract the data to an excel file it needs to be selected the button “Local File” 
or clicking in the right side of the month and selecting the option Spreadsheet.