Connectors Reference

SAP ERP

SAP ERP is an enterprise resource planning software developed by SAP SE. SAP ERP incorporates the key business functions of an organization. The SAP ERP connector for Power Automate and Power Apps allows you to invoke RFC and BAPI functions using on-premises data gateway.

 

Status: Preview

Tier: Premium

Version: 1.0

 

Actions:

Name

Summary

GetSchema (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop, string function)

Get SAP Function Schema

Invoke (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop, string function, string isSessionStateful, [Optional]InvokeParameterFunctionInput functionInput)

Call SAP function

RunDiagnostics (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop)

Run Diagnostics

Search (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop, string searchString)

Search SAP functions

TestConnection ()

Tests connection to SAP server

 

Triggers:

Name

Summary

 

Objects:

Name

Summary

DiagnosticsOutput

 

GetSchemaResponse

 

InvokeParameterFunctionInput

 

Output

 

 

Actions:

GetSchema

Summary: Get SAP Function Schema

Description: Get SAP Function Schema.

 

Syntax:

SAPERP.GetSchema (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop, string function)

 

Parameters:

Name

Type

Summary

Required

Related Action

AppServerHost

string

(AS Host)

The hostname of the SAP Application Server.

True

Client

integer

(Client)

The SAP client ID to connect to the SAP system.

True

SystemNumber

integer

(AS System Number)

The SAP System's System Number. It is a number ranging from 00 to 99.

True

UseSnc

boolean

(Use SNC)

When selected, the connections will be secured with SNC.

False

SncLibraryPath

string

(SNC library)

Path of the SNC library to be used.

False

SncSso

string

(SNC SSO)Values: [On, Off]

The SNC SSO specifies whether to use SNC identity or credentials provided on RFC level.

False

SncMyName

string

(SNC My Name)

Identity to be used for this particular destination/server (optional).

False

SncPartnerName

string

(SNC Partner Name)

The backend's SNC name.

False

SncQop

string

(SNC Quality of Protection)Values: [Authentication, Integrity, Privacy, Default, Maximum]

Quality of Service to be used for SNC communication of this particular destination/server.

False

function

string

 

 

True

 

Returns:

          Type:GetSchemaResponse

 

Invoke

Summary: Call SAP function

Description: Call SAP function.

 

Syntax:

SAPERP.Invoke (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop, string function, string isSessionStateful, [Optional]InvokeParameterFunctionInput functionInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

AppServerHost

string

(AS Host)

The hostname of the SAP Application Server.

True

Client

integer

(Client)

The SAP client ID to connect to the SAP system.

True

SystemNumber

integer

(AS System Number)

The SAP System's System Number. It is a number ranging from 00 to 99.

True

UseSnc

boolean

(Use SNC)

When selected, the connections will be secured with SNC.

False

SncLibraryPath

string

(SNC library)

Path of the SNC library to be used.

False

SncSso

string

(SNC SSO)Values: [On, Off]

The SNC SSO specifies whether to use SNC identity or credentials provided on RFC level.

False

SncMyName

string

(SNC My Name)

Identity to be used for this particular destination/server (optional).

False

SncPartnerName

string

(SNC Partner Name)

The backend's SNC name.

False

SncQop

string

(SNC Quality of Protection)Values: [Authentication, Integrity, Privacy, Default, Maximum]

Quality of Service to be used for SNC communication of this particular destination/server.

False

function

string

(SAP function name)

Specify SAP function name (case-sensitive).

True

Search

isSessionStateful

string

(Stateful Session)Values: [Yes, No]

Create stateful session. Select 'Yes' for write operations, 'No' for read operations.

True

functionInput

InvokeParameterFunctionInput

 

 

False

 

Returns:

          Type:Output

 

RunDiagnostics

Summary: Run Diagnostics

Description: Run Diagnostics.

 

Syntax:

SAPERP.RunDiagnostics (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop)

 

Parameters:

Name

Type

Summary

Required

Related Action

AppServerHost

string

(AS Host)

The hostname of the SAP Application Server.

True

Client

integer

(Client)

The SAP client ID to connect to the SAP system.

True

SystemNumber

integer

(AS System Number)

The SAP System's System Number. It is a number ranging from 00 to 99.

True

UseSnc

boolean

(Use SNC)

When selected, the connections will be secured with SNC.

False

SncLibraryPath

string

(SNC library)

Path of the SNC library to be used.

False

SncSso

string

(SNC SSO)Values: [On, Off]

The SNC SSO specifies whether to use SNC identity or credentials provided on RFC level.

False

SncMyName

string

(SNC My Name)

Identity to be used for this particular destination/server (optional).

False

SncPartnerName

string

(SNC Partner Name)

The backend's SNC name.

False

SncQop

string

(SNC Quality of Protection)Values: [Authentication, Integrity, Privacy, Default, Maximum]

Quality of Service to be used for SNC communication of this particular destination/server.

False

 

Returns:

          Type:DiagnosticsOutput

 

Search

Summary: Search SAP functions

Description: Search SAP functions.

 

Syntax:

SAPERP.Search (string AppServerHost, integer Client, integer SystemNumber, [Optional]boolean UseSnc, [Optional]string SncLibraryPath, [Optional]string SncSso, [Optional]string SncMyName, [Optional]string SncPartnerName, [Optional]string SncQop, string searchString)

 

Parameters:

Name

Type

Summary

Required

Related Action

AppServerHost

string

(AS Host)

The hostname of the SAP Application Server.

True

Client

integer

(Client)

The SAP client ID to connect to the SAP system.

True

SystemNumber

integer

(AS System Number)

The SAP System's System Number. It is a number ranging from 00 to 99.

True

UseSnc

boolean

(Use SNC)

When selected, the connections will be secured with SNC.

False

SncLibraryPath

string

(SNC library)

Path of the SNC library to be used.

False

SncSso

string

(SNC SSO)Values: [On, Off]

The SNC SSO specifies whether to use SNC identity or credentials provided on RFC level.

False

SncMyName

string

(SNC My Name)

Identity to be used for this particular destination/server (optional).

False

SncPartnerName

string

(SNC Partner Name)

The backend's SNC name.

False

SncQop

string

(SNC Quality of Protection)Values: [Authentication, Integrity, Privacy, Default, Maximum]

Quality of Service to be used for SNC communication of this particular destination/server.

False

searchString

string

(Search String)

Input string to search functions.

True

 

Returns:

          Type:array of (string)

 

TestConnection

Summary: Tests connection to SAP server

Description: Tests connection to SAP server.This methods invokes STFC Rfc Call.

 

Syntax:

SAPERP.TestConnection ()

 

Returns:

 


 

DiagnosticsOutput

Summary:

Description:

 

          Properties:

Name

Type

Summary

GatewayRunningStatus

boolean

 

 

GatewayVersionSupportsRunDiagnostics

boolean

 

 

CredentialCheck

boolean

 

 

CanPerformRfcFunctionSearch

boolean

 

 

CanInvokeSTFC_CONNECTION

boolean

 

 

DiagnosticsStatus

DiagnosticsStatus

 

 

 

DiagnosticsStatus

Summary:

Description:

 

          Properties:

Name

Type

Summary

 


 

GetSchemaResponse

Summary:

Description:

 

          Properties:

Name

Type

Summary


 

InvokeParameterFunctionInput

Summary:

Description:

 

          Properties:

Name

Type

Summary


 

Output

Summary:

Description:

 

          Properties:

Name

Type

Summary