SAP to Excel: Automate the export of SAP data to Excel ⚡

[@ERP-UP]

Work with SAP data in Excel. Do you work with Excel to handle SAP data?

[@TobiasMüller-r7g]

I try to work within SAP of course, but sometimes I also export SAP data to Excel. Helpful video

[@dhruvdevsingh9907]

Ya

[@ERP-UP]

@@dhruvdevsingh9907 Great

[@TobiasMüller-r7g]

Excellent. This is a grat feature to automate SAP export. I am looking forward to learn how to automate this within ABAP

[@ERP-UP]

I appreciate your support. Thank you

[@Annegret-u2f]

Sehr gut, vielen Dank! Das werden wir in jedem Fall einmal ausprobieren!

[@ERP-UP]

Das freut mich sehr. Viel Erfolg.

[@tonisklena5628]

Top! Vielen Dank für das Video. Genau das habe ich gebraucht und kann meine ABAP-Kollegen mit solchen Sachen verschonen ;)

[@ERP-UP]

Vielen Dank Toni. Es ist immer gut, wenn man sich die Arbeit erleichtern kann :)

[@veljkokaradzic329]

Thank you for your work, Sir !

[@ERP-UP]

You're welcome, Sir

[@talerguru2303]

You are my hero. Awesome video.

[@ERP-UP]

I am happy to help

[@Baba11-ex1zl]

Good Information for my work. Thank you👍

[@ERP-UP]

Thank you so much 👍

[@sabinegeiger3442]

Very helpful video !! Thanks a lot !! 👍👍👍

[@ERP-UP]

Thanks 👍

[@klarazacher9725]

Wie immer, sehr informativ 😊

[@ERP-UP]

Danke 😊

[@valentin-miroslavov]

Super! Thank you!

[@ERP-UP]

Thank you so much

[@Sreyv21]

would you know how i can change the export from 1:01 format to 9:44 when exporting to spreadsheet? most of my script won't work as it is constantly stuck being 1:01 export view.

[@ERP-UP]

You can use the dynpro based file save dialog as shown in the video 9:44. For this you have to implement the SAP note 1974590 and the SAP GUI option When you record your SAP GUI script a dynpro based file save dialog should appear if you don't activate the SAP GUI option "Accessibility & Scripting > Show native MS Windows dialog".

[@jandebruin444]

Great training, thanks. I do have a question on how a TIMESTAMPL-format field ends up in the excel. In an SAP F&R table we have a field showing runtime, defined as DEC 21,7 TIMESTAMPL data element. It can hold e.g. a value of 77,8917920 (where the comma is the DEC separator). bringing this to Excel messes up the result to: 693595-. Any clue how to solve this?

[@JosefZacher-k2z]

Спасибо 👍

[@ERP-UP]

👍

[@Foodchapters]

Thanks for this informative video, there is a basic data we need to add in VB module before we add the running script, would you able to share the same?

[@ERP-UP]

Thank you so much. In this case you want to get SAP data into an existing excel file. If you want to add SAP data into an existing excel file you need to establish an connection out of Excel. This is possible with a connection directly to the database. In Excel see "Data > Get Data > From Database > SAP HANA". Then you also need to have "Acces Software Downloads in SAP for Me". You can also use ODBC. As an alternative you can download/extract the SAP data into the excel file and use this file as the data source of your excel file (Data > Get Data > From File > From Excel Workbook). I can produce an own video on that. Good hint.

[@tiagobovolin]

Thank you very much! Congrats for the content.

[@ERP-UP]

Appreciated

[@tiagobovolin]

@@ERP-UP the record window of my SAP doesn't have the playback option. Is there a way to activate it?

[@ERP-UP]

@@tiagobovolin Sure, have a closer look at this video: kzbin.info/www/bejne/oZzIYnyXo5mMhKMsi=azCFs8d3k7icJv0p&t=31 In the transaction RZ11 maintain the profile parameter sapgui/user_scripting_disable_recording

[@tiagobovolin]

@@ERP-UP Thank you.

[@portaltobliss-ab]

Dank! Dank! One question- How to implement the SAP GUI scripting automation if I need to get Excel extracts each month and the dates to be entered change each month. Let's say, in october, I need an excel extract only for 10/01/2024 to 10/30/2024. But this will change in November.

[@ERP-UP]

You can work with variants kzbin.info/www/bejne/rYOoZYiYh9prr8U

[@filititoafa6848]

Hey boss, I have a profit n loss sap report that I want to export to Excel. The issue is it doesn’t export the entire report only the first page and not the sub headers. What do I have to do to get the entire report into a spreadsheet?

[@ERP-UP]

Hey, how do you export the data? Have a closer look at ABAP2EXCEL if you program an own ABAP report with an export function from SAP to Excel: kzbin.info/www/bejne/m4KTmH2wpcupqMUsi=WbngeqrvxXH9nGZr

[@andresdavidrodriguezzamero2086]

Hello, excellent video!! But I have a question to see if you can help me. What happens when a windows pop-up window appears? the script stops and stops recording it. In order to download the information and not modify the Excel, it is the only way I can do it. Is there any VBA code to put it when the "save as" window appears and make it automatic?

[@ERP-UP]

I don't understand the question. What type of pop-up window do you see? Why does it appear?

[@andresdavidrodriguezzamero2086]

@@ERP-UP hello!! The Windows "save as" window appears and I need it to be able to save the file without modifying the file

[@ERP-UP]

@@andresdavidrodriguezzamero2086 At about 9:35 you export the SAP data and give the excel file a name. The export is not interrupted or you don't have to modify the file.

[@ERP-UP]

​@@andresdavidrodriguezzamero2086 Now I understand your question. Another user showed me a problem on his system. You may also mean the "save as" popup when you try to select a file in Windows Explorer. Unfortunately, there is no way to interfere with that. Maybe there will be a solution in the future.

[@simsun911]

@@ERP-UP is there a way to change the save as so that it uses the sap native option instead of the windows pop up?

[@muratcankaragoz4030]

Hello, thanks for the very good video. I would like to know how it might be possible to download from several t-codes to a Excel database from SAP?

[@ERP-UP]

Thanks. You can record your download within the SAP GUI Scripting as shown in the video. You can stop the recording until your download from several t-codes has been finished. But I recommend to record one SAP GUI Script for each t-code to have it separated.

[@bzflowerbee]

Great video. Do you have any video on capture sap screenshots and save them to word documents? Thank you.

[@ERP-UP]

What do you mean with "SAP screenshots"? You can simply take screenshots with the print key and "Ctl + V" to paste it into a word document. I recommend using the key combination "Windows key + Shift + R" to easily take screenshots of a frame of your screen.

[@bzflowerbee]

@@ERP-UP I saw a video kzbin.info/www/bejne/jZCtXmyqlNKKercsi=bSirC1R2_yW5u7sL. Just wondering why we need the SAPGUI SCRIPTING API for this process.

[@ERP-UP]

@@bzflowerbee Now I understand it. Thanks for replying. You want to make screenshots with SAP GUI Scripting. Csongor explained it quite well. You are using the SAP GUI Scripting API for some functions you can use for MS Excel and MS Word.

[@bzflowerbee]

@@ERP-UP I know but I don't have the SAP GUI SCRIPTING API😭

[@EduardoAlonsoTroncosoGoche]

Which version of SAP do you have?

[@gauravkhurana4807]

Hi, can we use Power Automate to run the VB script at a scheduled time?

[@ERP-UP]

You can use Power Automate instead of SAP GUI Scripting: learn.microsoft.com/en-us/power-automate/guidance/rpa-sap-playbook/action-based-sap-gui-automation-recorder-overview You can use the Task Schedular to run the VB script at a scheduled time.

[@fatimabaiyent.]

Hi, is it possible to export to excel via a script, but to filter data and format the excel sheet also by way of a script?

[@ERP-UP]

This is possible. When you record the steps, a vbs file is created. In the vbs file you can program the format you need in the Excel file.

[@raine6510]

May I know if it's possible to run the script automatically daily so I can have the export in a certain folder everyday?

[@ERP-UP]

Technically it is possible. Therefore you have to set up a scheduled task within Windows Task Scheduler for the created vbs file. But the SAP GUI has to be open because SAP GUI Scripting runs in foreground. If you really want to export the data in background daily I recommend to create an ABAP program and set up a batch job in the transaction SM36. kzbin.info/www/bejne/aparnXyio91omtUfeature=shared

[@VedarthDesai]

Hi. Is it possible to execute this script via task scheduler? I was not able to do it.

[@ERP-UP]

That is possible. Depending on your VBS file you have to be logged into your SAP system. Try to run the vbs file without the task scheduler. If that is possible your vbs file can also be executed via the task scheduler.

[@VedarthDesai]

@@ERP-UP my vbs opens sap gui, logs in and executes the job and logs out. It's running fine if I run directly. But doesn't get executed while in the task scheduler. I tried almost everything but I'm still struggling.

[@ERP-UP]

@@VedarthDesai I have created a video for this. Have a look at this video: kzbin.info/www/bejne/aKaQoZeAjrqEaac

[@annaz9630]

👍👍

[@ERP-UP]

👍

[@faizsherrif3470]

Can anyone help me I have selected always use option in spreadsheet format now I want to uncheck that option.

[@ERP-UP]

I have created a video for you explaining the "tricks" to uncheck that option: SAP GUI Export: "Always Use Selected Format" Explained & How to Disable It kzbin.info/www/bejne/l3uzhGN9rdaojac

[@JohnSprofera]

Is there any way to automate SAP Data into my Excel Dashboard that is connected with Pivot Tables?

[@ERP-UP]

In this case you want to get SAP data into an existing excel file. This is possible with a connection directly to the database. In Excel see "Data > Get Data > From Database > SAP HANA". Then you also need to have "Acces Software Downloads in SAP for Me". You can also use ODBC. As an alternative you can download/extract the SAP data into the excel file and use this file as the data source of your excel file (Data > Get Data > From File > From Excel Workbook).

[@shadihemid9313]

If I do not have the record/play script buttons (greyed out) and I am not allowed to use RZ11 transaction, does this mean I am not going to be able to automate the transaction I am looking to?

[@ERP-UP]

Unfortunately, yes. But maybe you have access to the development or quality system to create the script and run it in the productive system. If in these systems the record/playback options are also not allowed, then you can align with your SAP Basis team if they can activate it in these systems.

[@shadihemid9313]

@@ERP-UP I tried checking it in the quality portal and it was active!! perfect, however I created the script and when I tried playing it back (I have an error in the very first step saying " A Script is attempting to access SAP GUI" I click Ok, nothing happens :( .. is there a way around this? (P.S. I tried this in both Qualtiy and production and same error came up on the screen)

[@ERP-UP]

@@shadihemid9313 Is SAP GUI Scripting active in the productive system? If "just" the record script button is greyed out, then you can't record SAP GUI scripts. If SAP GUI Scripting is deactive in the productive system, you are also not able to run SAP GUI Scripts (VBS files). Then you need to active the mentioned profile parameters in the transaction RZ11. To find the root cause for your problem, I recommend to record a simple SAP GUI script and get this running in the quality system. If this is also not possible, check the *scripting* profile parameters. You can also align with your SAP Basis department to active the *scripting* profile parameters in transaction RZ11.

[@shadihemid9313]

@@ERP-UP many thanks for your reply I will try it out. Much appreciated.

[@ERP-UP]

@@shadihemid9313 You're welcome

[@fame2144]

Can this be applied to individual SAP table data? If I apply it to different SAP table data, will it not apply to the same data? If so, what should I do? Should I start the record at the beginning of the table data specification?

[@ERP-UP]

What do you exactly mean with "individual SAP table data"? In this use case we are using the table EKKO. You can of course do it for other tables. Then you need to record another script or create an own VBA script in MS Excel to select different tables and selection criterias.

[@fame2144]

@@ERP-UP it is also possible to record the table search and selection methods?

[@fame2144]

@@ERP-UP Sorry for my inconvenience. I think I should make my own effort to solve this problem. Thx for your reply!

[@mewimi]

Great video :) Hmm I wonder how the boss gets those automatically sent to people's emails also.

[@ERP-UP]

For this you need to do a second step because sending the excel sheet out of Excel can't be recorded via SAP GUI Scripting and is therefore not in the created VBS file. You can send an excel sheet via e-mail out of excel to people's emails also. Have a look at this: techcommunity.microsoft.com/t5/excel/how-to-create-a-macro-that-allows-to-automatically-send-a/m-p/3932382

[@SirGG]

man my sap dont turn on the script recorder how can i change it

[@ERP-UP]

03:08 - Activate SAP GUI Scripting Also make sure you enable scripting by selecting the SAP GUI option "Enable scripting" under "Accessibility & Scripting > Scripting".

[@kristalynsantos8102]

i accidentally put deafult mhtml, how to clear this default

[@ERP-UP]

There are 2 options to remove the automatic setting: 1) Right-click the context button in the top left corner of the output (the button between where the row titles and columns meet) and choose "Spreadsheet". 2) Or right-click anywhere in the screen area and choose "Spreadsheet". When "Spreadsheet" is selected, the automatic setting is removed.

[@CrashCraft7]

I cannot change the value, there is no button to change it. With RZ10 I also cannot edit my profile no authorization

[@ERP-UP]

Can you please elaborate on this? To activate SAP GUI Scripting you have to activate the profile parameters in the transaction RZ11 as shown in the video (03:08 - Activate SAP GUI Scripting).

[@CrashCraft7]

@@ERP-UP I have no authorization to change the data from False to True. I work for a large company and have to request the authorization, but unfortunately I don't know which authorizations these are

[@ERP-UP]

@@CrashCraft7 You "just" need authorization for transaction RZ11 or request to change the mentioned profile parameters shown in the video. sapgui/user_scripting Also have a closer look at this video: SAP & Excel - 10 SAP GUI Scripting Tips 🚀 kzbin.info/www/bejne/oZzIYnyXo5mMhKMsi=BldqwpfXtO6g0qrJ&t=31

[@SrikanthPatelkhanna]

How to dowload data in to excel from Tcode: SOAMANAGER webservice configuration?

[@ERP-UP]

The transaction SOAMANAGER opens in the browser (web dynpro) and not in the SAP GUI. I don't see any export function in general. If you want to you can search to export the html page into excel and transform it to your needs.

[@beds1827]

How do I stop SAP from opening Excel file automatically?

[@ERP-UP]

Have a closer look at this video: kzbin.info/www/bejne/aWOYnZ-HpbmXbdU Excel inplace SAP GUI - Work with Excel in SAP GUI 🚀

[@kiranarana7274]

The problem we stil have here is that the export excel file cannot be closed using VBA

[@ERP-UP]

Have a look at those answers: answers.sap.com/questions/13523338/prevent-or-close-exported-files-from-sap-gui-to-ex.html stackoverflow.com/questions/64009373/close-sap-export-multiple-excel-file-with-vba

[@kiranarana7274]

Thank you is working

[@mdasifhassan]

What about user name and password .I am an enduser and I have to login every time to SAP

[@ERP-UP]

Have a look at this video: Log into SAP from Excel with SAP GUI Scripting API kzbin.info/www/bejne/p2qZfaN-aKp7bJIsi=NsU3xiaauZW3fZu7

[@geraldoribeiro8393]

Se utiliza o SAP GUI, ok, porém sendo o SAP4HANA(FIORI), não funciona!! Using SAP GUI, ok, but still SAP4HANA(FIORI), it doesn't work!!

[@ERP-UP]

SAP GUI Scripting only works in SAP GUI

[@mch3486]

Why the hell should a user use SE16N for export.

[@ERP-UP]

This is just an example to show the export functionalty in the ALV Grid Control. You can use the export functionality and SAP GUI Scripting in any transaction supporting ALV Grid Control and the export function.

[@loredanaguarino2796]

Automazione esecuzione di query sap in un orario specifoco

[@ERP-UP]

SAP GUI Scripting in Task Scheduler - Schedule SAP GUI Scripts kzbin.info/www/bejne/aKaQoZeAjrqEaac

[@szczesniakdariusz]

Except the fact it is limited to 1 milion rows.

[@ERP-UP]

😃

[@szczesniakdariusz]

​@@ERP-UP imagine i work on Citrix SAP, with data sets like 2mil rows, exports to csv fail every time, BI takes ages.. and no SQL access or GUI scripting 😅

[@ERP-UP]

@@szczesniakdariusz SAP GUI Scripting has its limitations 😅. If you regulary export a huge set of data I recommend to implement an ABAP report to use interfaces to export your data.