The goal of this project is to automate the process of retrieving material master data from SAP using the MM03 transaction. This is done through GUI scripting, driven by material data listed in an Excel file. The automation simulates user actions to extract views like Basic Data, Plant Data, and Sales Org Data, and logs results into an Excel workbook.
- win32com.client — to interact with SAP GUI via COM automation.
- pandas — for reading material and plant data from Excel files.
- openpyxl — for creating and styling Excel output reports.
- os, time, traceback, logging — for utility operations, error tracking, and delay management.
- SAP GUI — GUI client used to simulate user interactions.
- Excel File — Input for Material Number and Plant, and output for storing results.
-
SAP GUI Launch and Login A function start_sap() is used to programmatically start sapshcut.exe for launching the SAP GUI system with predefined credentials.
-
SAP MM03 Navigation
- After successful login, automate_sap_tcode() simulates the SAP GUI interactions:
- Opens the MM03 transaction.
- Enters material number and selects the desired views (like Basic Data 1, Plant Data/Storage 1, etc.)
- Loops through each material and plant combination to extract data.
- Excel Integration
- Input Excel is read using pandas.read_excel() to extract Material and Plant combinations.
- Output Excel is generated using openpyxl, with formatting (merged cells, borders, fonts).
- Result includes structured tables representing key SAP MM03 data per material.
- Logging
- Logs for success/failure are captured in a log file logs.log to help trace failures or SAP GUI errors.
- Python 3.7 or higher
- SAP GUI installed and scripting enabled
- Clone the repository
git clone https://github.com/chiragx16/SAP-LOGON-GUI-Automation.git-
Install Dependencies mentioned above
pip install pywin32 pandas openpyxl notebook -
Open 'cmd' in the project directory and run this
jupyter notebook