XtractQL Explorer is a tool that is installed as part of ERPConnect Services and allows the execution of XtractQL statements. Launch the XtractQL Explorer from the Start menu -> ERP Connect Services.

ECS-XtractQL-Explorer

Select File -> Connection … to define the connection to your SAP system.

ECS-XtractQL-SAP-Connection

In the upper portion of the window, enter the XtractQL expression, then select Execute. The result will be shown in the lower portion of the window.

ECS-XtractQL-Explorer-Table

Templates

Select the template menu to insert commonly used XtractQL expressions.

ECS-XtractQL-Explorer-Template

Variables

Variables can be used for input and output parameters. In the following sample the variable @KUNNR is assignet to the Export parameter KUNNR. The result table CUSTOMER_T is saved into the table variable @RETVAL.

EXECUTE FUNCTION 'SD_RFC_CUSTOMER_GET' 
EXPORTS KUNNR= @KUNNR 
TABLES CUSTOMER_T INTO @RETVAL;

The input variables can be defined under File -> Parameters.

ECS-XtractQL-Explorer-Menu

ECS-XtractQL-Explorer-Function-Parameter

ECS-XtractQL-Explorer-Function