Frequently asked questions about SAP procurement integration with Power Platform
This article provides answers to some of the most frequently asked questions (FAQs) about SAP integration with Microsoft Power Platform.
Versions and licensing
What versions of SAP are supported by the SAP ERP connector?
The SAP ERP connector supports all SAP versions from R/3 (early 1990s) forward, including SAP ECC and SAP S4/HANA.
What licensing is required to integrate SAP with Power Platform?
At a minimum, you need the following for each user:
- A Power Apps Premium license
- An SAP indirect named user license
If you already have SAP direct named user licenses, you can use these licenses with Power Apps. It's worth noting, however, that SAP indirect named user licenses cost less than direct named user licenses.
Will this work with other SAP core products like BW, SRM, and CRM?
Yes, Power Platform's SAP ERP connector works with any SAP product that runs on the NetWeaver stack.
How can we connect to SAP's other products that have come via acquisition?
For products such as SuccessFactors, Ariba, Concur, and any other SAP product that doesn't run on the NetWeaver stack, you can use our custom REST and SOAP connectors.
If we integrate Power Platform with SAP ECC and then upgrade to S4/HANA, will our integrations break?
No, we've had hundreds of customers upgrade from SAP ECC to S4/HANA without any issues. Some of the core data models do change in S4/HANA (customer, vendor, financial posting), but we've accounted for data model changes in our prebuilt Power Automate flows. Additionally, SAP ensures their published APIs are carried over to new versions.
Data and integration
How does Power Platform access SAP data?
The SAP ERP connector utilizes the message server to invoke APIs that create, read, and update SAP data. This traffic typically flows over port 33XX for single application servers or port 39XX for load-balanced connections, where XX is the system number of the SAP instance.
Can Power Platform consume OData services in SAP?
The Open Data Protocol (OData) connector is currently only in private preview. However, you can create a custom connector in Power Automate to consume OData services.
Can Power Platform access views in S4/HANA?
Yes, the SAP ERP connector can read Core Data Services views via the action, Read SAP Table with Parsing.
Can Power Platform access custom SAP tables (Z-tables)?
Yes, the SAP ERP connector can read custom tables via the action, Read SAP Table with Parsing.
What if SAP doesn't provide an API for a data object?
In this case, there are several options:
- Intermediate Document (IDoc) – we provide a generic API that can synchronously invoke an IDoc for any object type.
- Batch input – we have a generic API that can synchronously process a batch input recording.
- Legacy System Migration Workbench (LSMW) – Power Automate can create a file that can be dropped on the SAP application server and processed within transaction LSMW.
- Custom Function Module – a custom remote-enabled function module can be created in SAP and called by a Power Automate cloud flow.
Will Power Platform affect the performance of our SAP system?
The SAP ERP connector runs on SAP's API layer, which typically has better system performance than running the same activity in the SAP GUI. As more users transition off the SAP GUI and to an external user interface like a canvas app, CPU consumption on the SAP servers drops significantly.
Are there any performance bottlenecks in the SAP ERP connector?
No, typically the bottleneck is in the SAP system itself. We can configure the number of concurrent API threads to match the session limits on your SAP servers. We can also arrange clusters for the on-premises data gateway.
Can Power Automate flows be used by other applications like Dynamics CRM?
Yes, the Power Automate flows that integrate with SAP can be triggered by your own custom applications or any software capable of REST integration.
Will the SAP ERP connector work with non-UNICODE systems?
Yes.
How are errors in SAP handled?
Errors are displayed to users in a canvas app using Power Apps in a similar fashion to SAP's red text with the details of the error that occurred. Canvas apps users can correct errors if they're data-related and resubmit their work to SAP.
How are file attachments handled?
Power Automate can attach files to objects in SAP using Generic Object Services (GOS) and/or via ArchiveLink based on your requirements.
Security
How does authentication happen against SAP?
The Power Platform currently supports two of the three authentication methods for SAP:
- Username/Password - a user is prompted for their SAP username and password on the canvas app screen in Power Apps, which is sent to SAP.
- SSO (Kerberos) - the On-premises Data Gateway requests a Kerberos ticket on behalf of the Power Apps user and this ticket is sent to SAP.
- SSO (SAML/X.509) - NOT CURRENTLY SUPPORTED. We plan to support SAML in the future. However, SAP can support both X.509 and Kerberos authentication on the same SAP instance.
How do we make sure Power Apps users can't do things they can't do in SAP?
SAP's published APIs perform the same security checks that are performed in the SAP GUI. Also, Power Automate flows can be configured to query user authorization objects so apps, fields, and buttons are conditionally hidden or revealed to match the user experience in SAP.
How do we ensure traffic between Power Platform and SAP is encrypted?
We recommend using SAP's Secure Network Communication (SNC), which is available via a connection setting when configuring authentication.
Customization
How does Power Platform handle custom fields in SAP?
The answer depends on where the custom fields reside in SAP:
- Appended to SAP-Standard Table - The fields are populated by using Business Application Programming Interface (BAPI) Extension Structures in the Power Automate flows.
- Custom SAP Table - The function modules updating these tables need to be remote-enabled to allow our SAP connector to invoke them.
How easy is it to add custom fields to canvas apps?
Fields in canvas apps can easily be inserted and copy/pasted in our WYSIWYG (What You See Is What You Get) editor.
Can Power Platform call custom function modules?
Yes, if a function module is remote-enabled, our SAP connector can invoke that function module. However, SAP doesn't respond to a support ticket if your custom function module isn't working correctly, since that is your own code.
How can Power Platform handle custom processes that we built in SAP because we had no other option?
Your custom database tables can be read using Read SAP Table with Parsing action for all read operations. For create and update operations, you'll need to remote-enable your custom function modules used to maintain this data. Once the function modules are remote-enabled, the SAP ERP connector can call them.
Implementation and support
Where can I get started?
You can review the documentation: SAP integration.
Where can I get a demo SAP environment to test the SAP integration solutions?
You have a couple options:
- SAP Cloud Appliance Library. Create your own SAP demo instances on Azure by following the instructions here: Deploy with SAP Cloud Appliance Library.
- SandboxSAP. Be sure to select the add-on for RFCs/BAPIs to allow Power Automate to connect to their instances. Microsoft isn't affiliated with IDES Remote, these services are used at your own risk.
Where do I turn if I get stuck with SAP integration with Power Platform?
Nearly 100% of the issues encountered are due to a step or prerequisite being overlooked in the SAP integration documentation. If you're still having issues, you have a couple of options:
- Submit a question on our forum at: Power Platform Community
- Send an email to: sap_ecc_powerapps@service.microsoft.com.
Do we need to install anything on our SAP servers to get Power Platform to work with SAP?
No.
Do we need to install anything on our users' PCs for SAP integration with Power Platform?
No, all canvas apps are accessed through a web browser.
Is there anything we need to provision to set up SAP integration with Power Platform?
Yes, a Windows virtual machine (VM) with at least 8 GB of RAM needs to be provisioned for the on-premises data gateway, which acts as a proxy server to listen for requests from your Power Platform tenant and relays them to SAP. One Windows machine is sufficient for testing, but a cluster of Windows VMs should be set up for deployment to production to avoid single points of failure.
How quickly can a canvas app on SAP be up and running?
The prebuilt canvas app on SAP can transaction against your SAP system immediately; however, you'll likely want to modify these canvas app templates by adding your custom fields or any SAP-standard fields that aren't included in our solution templates. Typically, within a few weeks you can have something ready for your business users to test.
Can we build mobile canvas apps on top of SAP?
Yes, canvas apps can be built using Power Apps for mobile devices, but we also allow native canvas apps to be built on Power Platform as well.
Can Fiori Apps coexist with Power Apps?
Yes, Fiori Apps can be embedded in canvas app menus and canvas apps can also be embedded in the Fiori launchpad.