Skip to Content
Technical Articles
Author's profile photo Ramesh Vodela

ABAP developer edition & Python Interface development


Python has grown in popularity and the number of use cases has rapidly increased from Finance, big data and machine learning.   For those of us in the SAP it will be helpful to use the power of processing provided by Python at the same time retain the benefits and advantages of working in SAP.

In this blog, we will see how to use python and query odata from the ABAP developer edition using IntellJ PY Charm and show case the power of python in data analysis using a simple example  I There are many blogs that describe how to set up python and IntelliJ for development. One such blog is Python with Intellij.

To query odata you need to install pyodata from GitHub.  This is available from SAP Pyodata package.  Install the library as mentioned

It is assumed that you have SAP ABAP developer edition up and running. I am using Developer edition 7.52.

Once your setup is complete you can create new Python project in Py Charm and add a python file name it  The  following code shows how to query ABAP system odata service.

# Import the requirements
import pyodata 
import pandas as pd
import requests

# Create a PyOData client instance

service_url = "http://vhcalnplci.dummy.nodomain:8000//sap/opu/odata/sap/EPM_REF_APPS_SHOP_SRV"
#we are querying Shopping service to analyse the review information
session = requests.Session()
session.auth = ('Developer', 'Down1oad')  
#username and password for ABAP developer edition
client = pyodata.Client(service_url, session)
# Get the Products entity set and its entity type

entity_sets = client.entity_sets
scalar_properties = set()
for es in client.schema.entity_sets:
        if == "Reviews":
            proprties = es.entity_type.proprties()

            for prop in proprties:
                if == 'ProductId' or ==  'Rating' or == 'HelpfulCount':
reviews = client.entity_sets.Reviews.get_entities().execute()

# Create an empty list to store the dictionaries for each reviews
review_list = []

# Loop through each review entity and create a dictionary
for review in reviews:
    review_dict = {}
    for property_name in scalar_properties:
        review_dict[property_name] = getattr(review, property_name)

# Convert the list of dictionaries to a pandas DataFrame
df = pd.DataFrame(review_list)
df2= df.groupby('ProductId').sum()


When you run the program you the output shown below

The above output shows the power of python for data analysis using a simple example. If we had to write an ABAP to do the same we would have to loop thru the output and sum reviews by product.

It will help if readers can comment and provide feedback and suggestions for future blogs.  If you are interested in ABAP connectivity please follow the ABAP Connectivity environment topic page (,  Post and answer questions (, and read other posts on the topic (

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ulrich Schmidt
      Ulrich Schmidt

      Just as a side-node for those who are interested: this blog highlights, how to access SAP data that is exposed as an OData Service using Python. There is also a GitHub project that provides Python access to SAP data that is exposed via RFC protocol:

      GitHub - SAP/PyRFC: Asynchronous, non-blocking SAP NW RFC SDK bindings for Python

      So no matter whether you need to call OData Services or remote-enabled Function Modules to get the data you are interested in, you can do both from Python!

      Author's profile photo Ramesh Vodela
      Ramesh Vodela
      Blog Post Author


      Thanks for providing an additional method,  I wish to point out you should have a valid S user id and download authorization to install the prerequisite libraries. I did not have the authorization and hence it was not possible for me to test the RFC adapter for Python. If it is possible to get the prerequisite library on GitHub or other download sites please let us know so that we can benefit from the RFC adapter from python


      Best regards