GitHub - AkashKobalTechM/SAP_automation_python: Automate SAP-Excel interaction with Python.

😄 😀 😪 😌 😕 😮 😲 👍

SAP-Excel Automation using Python

Hi,  my name is Ray Kim. I am here to share my experience in SAP automation. 
I am the furtherest thing from an expert but I hope my codes can help you.
You can contact me at rainmankim@gmail.com for further details.

This repository will explain how you can automate SAP log-in and execute T-code.
If you can do that, you can easily figure out the rest, using Stefan's recorder.
I am keeping things simple here to avoid confusion

In this use-case, I am not using PyAutoGui or OpenCV.
Those things can be used by all means.
But Stefan's recorder shortens development time for SAP automation at zero cost.

Before starting, I recommend that you prepare two things

(1) Ensure your scripting is enabled on your SAP.

You might need to request your IT department to allow this.

(2) Download Stefan Schnell's SAP Script Recorder.

SAP has a built-in recorder. But if you use that you will need to change the syntax to be used in Python.

Using Stefan's Recorder generates Python-friendly syntax along with many other powerful features.

https://tracker.stschnell.de/

Next, open any Python IDE/code editor.

I recommend Jupyter Notebook so that you can slice data in-action.

Below is an example of recorded scripts which are modified to suit my needs (*for loops + various conditions)

I have two main functions in my file — def sap_automate() and def enter_data()

sap_automate(df) is the main function that will establish connection/session and automate log-in

enter_data(session,df) is a nested function that will execute actions within SAP

Dealing with Excel

If you are writing to an existing excel, Pandas library would be not be enough

Use Excel modules such as xlwings or xlsxwriter

Credits

- Stefan Schnell
- SAP community (https://answers.sap.com/index.html)     
- https://guides.github.com/features/mastering-markdown/
- Secular saints of StackOverFlow

Name	Name	Last commit message	Last commit date
Latest commit History 15 Commits 15 Commits
images	images
README.md	README.md
SAP automation basics.ipynb	SAP automation basics.ipynb

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

SAP-Excel Automation using Python

Before starting, I recommend that you prepare two things

(1) Ensure your scripting is enabled on your SAP.

You might need to request your IT department to allow this.

(2) Download Stefan Schnell's SAP Script Recorder.

SAP has a built-in recorder. But if you use that you will need to change the syntax to be used in Python.

Using Stefan's Recorder generates Python-friendly syntax along with many other powerful features.

Next, open any Python IDE/code editor.

I recommend Jupyter Notebook so that you can slice data in-action.

Below is an example of recorded scripts which are modified to suit my needs (*for loops + various conditions)

I have two main functions in my file — def sap_automate() and def enter_data()

sap_automate(df) is the main function that will establish connection/session and automate log-in

enter_data(session,df) is a nested function that will execute actions within SAP

Dealing with Excel

If you are writing to an existing excel, Pandas library would be not be enough

Use Excel modules such as xlwings or xlsxwriter

Credits

About

Uh oh!

Releases

Packages

Uh oh!

Contributors

Uh oh!

Languages

Search code, repositories, users, issues, pull requests...

Folders and files

Latest commit

History

Repository files navigation

SAP-Excel Automation using Python

Before starting, I recommend that you prepare two things

(1) Ensure your scripting is enabled on your SAP.

You might need to request your IT department to allow this.

(2) Download Stefan Schnell's SAP Script Recorder.

SAP has a built-in recorder. But if you use that you will need to change the syntax to be used in Python.

Using Stefan's Recorder generates Python-friendly syntax along with many other powerful features.

Next, open any Python IDE/code editor.

I recommend Jupyter Notebook so that you can slice data in-action.

Below is an example of recorded scripts which are modified to suit my needs (*for loops + various conditions)

I have two main functions in my file — def sap_automate() and def enter_data()

sap_automate(df) is the main function that will establish connection/session and automate log-in

enter_data(session,df) is a nested function that will execute actions within SAP

Dealing with Excel

If you are writing to an existing excel, Pandas library would be not be enough

Use Excel modules such as xlwings or xlsxwriter

Credits

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages