There may be times when a user would like to download data from FBL1N, FBL3N or FBL5N. Instead of creating a Query script, it is easier to generate the data using Transaction.
1. Record the script using Transaction as required filling in entry screens as needed (Batch or GUI Scripting).
2. The data will be returned in the familiar table.
3. To download the data, click on System/List/Save/Local File
4. In the pop-up, leave radio button as unconverted and green tick.
5. It is helpful to know the path of the directory where you would like to save the file along with the name you want to give the file before you create the script.
6. Click Generate
7. When mapping the script, map from spreadsheet to SAP for those fields you would like to be variable remembering to change the file name for each run.
8. See the attached script and data file for an example.