Skip to main content

SAP Data Retrieval and Processing Library for IBP

Project description

Ibp2py - Python library for SAP IBP

This is a Python library designed to make it easier to interact with the SAP Integrated Business Planning (IBP) API.

Installation

You can install ibpy using pip:

pip install ibpy2py

Usage

To use ibpy, first create an instance of the ibpy class using your SAP IBP username and password:

from ibpy import ibpy  
username = "YOUR_IBP_USERNAME" 
password = "YOUR_IBP_PASSWORD" 
host = 'YOUR_HOST_URL' 
connection = Ibp2py(username, password, host)

Extracting Master Data

Here is an example of how to extract master data: Method -> MASTER_DATA_API_SRV

PlanningAreaID = 'SAP01' 
VersionID = "BASE" 
MasterDataTypeID = "M3LOCATION" 
PlanningAreaDescr = "Planning" 
VersionName = "Base Line" 
select = '*' 
data = connection.masterdata(MasterDataTypeID, select=select, PlanningAreaID=PlanningAreaID, VersionID=VersionID, PlanningAreaDescr=PlanningAreaDescr, VersionName=VersionName)

Extracting Telemetry Data

Method -> AddInLogon (MtrgActyExcelAddInLogon) Method -> AddInLogon (MtrgActyExcelAddInPlanningView)

module -> Method

Here is an example of how to extract telemetry data:

data = connection.telemetry('PlanningView', module)

Extracting Key Figure Data

Method -> 1 (PLANNING_DATA_API_SRV) Method -> 2 (EXTRACT_ODATA_SRV)

modulo -> Method

Here is an example of how to extract key figure data:

filters="(PERIODID0_TSTAMP ge datetime'2023-04-01T00:00:00' and PERIODID0_TSTAMP lt datetime'2023-07-02T00:00:00')"+ " and CONSENSUSDEMAND gt 0" 
PlanningAreaID = 'SAP01' 
MasterData = 'PRDID,CUSTID' 
KeyFigures = 'CONSENSUSDEMAND' 
data = connection.keyfigure(PlanningAreaID, MasterData, KeyFigures,modulo = modulo,filters=filters)

Contact Information

For any issues or queries related to ibpy2py, feel free to reach out:

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

Apache License 2.0

Note: This library is open source and is not sponsored or supported by SAP.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

ibp2py-1.0.6.tar.gz (13.0 kB view hashes)

Uploaded Source

Built Distribution

ibp2py-1.0.6-py3-none-any.whl (21.5 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page