SAP Function BC_EXECUTE_QUERY
With this data source, a query is made against the proprietary SAP function /WMD/BC_EXECUTE_QUERY. The query can be made either via the SAP .NET Connector, SAP NetWeaver or via a SOAP interface.
SAP .NET Connector and SAP NetWeaver
The prerequisites for using the SAP .NET Connector and SAP NetWeaver are identical to those listed in Output Systems "SapXSuiteInterfaceNCo", "SapXSuiteInterfaceNwRfc".
The connection string may include all standard SAP connection parameters.
Notice
Available key names include AppServerHost, SystemNumber, User, Password, Client, and Language.
This documentation does not include a complete list of the key names available. The list is stored in the Configurator.
The Provider key must be added to the connection string. This key has the fixed value SapWmdQueryNCo for the SAP .NET Connector, and SapWmdQueryNwRfc for the SAP NetWeaver.
SOAP Interface
Key | Description |
|---|---|
Provider* | Value |
Url* | Complete URL for calling the function module |
ProxyAddress ProxyUser ProxyPassword | Proxy server for communication to the web service (optional) Syntax: see Proxy Server Connection. |
RequestTimeout | Timeout value in seconds, determining how long to wait for a response from the web service before throwing an error Default value: |
SoapVersion | SOAP version for communication to the web service
|
User Password | User name and password for basic authentication against the web service Basic authentication is the only authentication procedure that is supported. |
Query command
The query command is almost identical for both connection types.
The actual queries are predefined by SAP, requiring you to only select the query you want. Specify the parameters in the same syntax as a connection string. The query command consists of any of these additional parameters:
Key | Description |
|---|---|
Function | Name of the SAP function to be called Default value: This key is only relevant when using the SAP .NET Connector or SAP NetWeaver. |
UserGroup | Name of the executing user group Default value: |
Query* | Name of the query to be executed |
Variant | Variant of the query to be executed Default value: |