Invokes the given BAPI, returning the result. This function is intended for reads only. To write to SAP, use a!sapInvokeWriter.

Syntax

a!sapInvoke( scsExternalSystemKey, usePerUserCredentials, hostname, clientNumber, systemNumber, bapi, importParameters, tableParameters)

Common Parameters:

scsExternalSystemKey: (Text) The key from the Third Party Credentials admin console page that corresponds to the set of credentials that should be used to authenticate.

usePerUserCredentials: (Boolean) If true the credentials set in the Third-Party Credentials settings page by the current user running the expression will be used. If false the site-wide credential values will be used.

hostname: (Text) The application server host of the SAP server (ASHOST). The value can be an IP address, a fully-qualified domain name, or SAP's router string format. For example, "/H/sap_router/W/password/H/app_host/S/service_port".

clientNumber: (Text) The SAP client. For example, "500".

systemNumber: (Text) The SAP system number. For example, "10".

connectionProperties: (Any Type) The connection properties to use when creating the connection to the SAP instance, given as a dictionary. The dictionary fields are the camel-cased names of the properties with '.'s removed, and the values are the properties values to use.

Specific Parameters:

bapi: (Text) The name of the SAP BAPI to invoke.

importParameters: (Any Type) The import parameters to send to the BAPI function, given as a dictionary. The dictionary fields are the import parameter names, and the values are the parameter values to send.

tableParameters: (Any Type) The table parameters to send to the BAPI function, given as a dictionary. The dictionary values can also be given as dictionaries, allowing for the requisite table structure to be defined.

Returns

The function returns the standard connector result dictionary described in the main Connectors page.

If successful, the function returns a dictionary representation of the return value of the invoked BAPI.

Notes

If called multiple times in the same expression with the same parameters, only one query is made to SAP when the expression is evaluated and the result is reused for each identical call. This caching only applies within a single expression evaluation. Return values are not cached in separate expressions, or in separate evaluations of the same expression.

Examples

Invoke a BAPI to Read Material Details

Copy and paste the expression into the INTERFACE DEFINITION in EXPRESSION MODE, save it, then call the interface in a Tempo Report to test.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
=a!localVariables(
  local!material: a!sapInvoke(
    scsExternalSystemKey: cons!SAP_SCS_KEY,
    usePerUserCredentials: true,
    hostname: cons!SAP_HOSTNAME,
    clientNumber: cons!SAP_CLIENT_NUMBER,
    systemNumber: cons!SAP_SYSTEM_NUMBER,
    bapi: "BAPI_MATERIAL_GET_DETAIL",
    importParameters: {MATERIAL: "MATERIAL NAME"}
  ),
  {
    a!textField(
      label: "Material Type",
      readOnly: true
      value: local!material.result[2].MATERIAL_GENERAL_DATA.MATERIAL_GENERAL_DATA.MATL_TYPE
    ),
    a!textField(
      label: "Material Description",
      readOnly: true
      value: local!material.result[2].MATERIAL_GENERAL_DATA.MATERIAL_GENERAL_DATA.MATL_DESC
    )
  }
)

Connection Properties

The table below lists the dictionary keys and their associated connection property.