Power Platform + SAP - Calling SAP Tables

In a lot of cases you just want to lookup information from a table in your SAP system and display (some of) the result in a Power App or in other applications.
In addition to calling RFCs, the new SAP ERP Connector provides a functionality to call directly an SAP Tables.

In this video we show how you can leverage the on-prem data gateway to call directly a table in your SAP system directly from Power Automate.

#PowerPlatform #SAP #PowerAutomate

[Abhishja]

How about Join SAP Table in power automate? we are not using for loop action otherwise it will take a lot of time.

[remembernaveen]

Hi...can i use this plugin for sap ecc sir

[filipeataide]

Very good!
I'm having some difficulties with the filter. I got a list of orders from EKKO, and I want to use them as an input filter in EKKO, but either a character limit error occurs if I put it as a string, or when I put it as an array, it includes some \n that don't work in the filter. Do you know how to solve it?

[dineshm]

Super Helpful!!
Is it the same way to connect SAP BW system as well?

[edderwaddyzeincbobea]

Actually im getting this error: Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'saperp' operation 'GenerateTableResponseSchema' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "error": { "code": "InvalidProfileOrParameterValidation", "message": "Key 'Client' not found in connection profile.", "target": "ProfileInformation" } }

[pedromass]

Can create a sample in Power Apps? What format is x-ms-sap-system?

[AitorZapirain]

Tole Sachen Holger!!!! I see you always connect to S4/hanna. Any chance for those of us who are still in R3?