Select the first five records from table T001W where the field FABKL has a value of US.
Select all records from table MAKT. The results table includes columns with the names ShortText, MANDT and Language.
Execute SAP Query S\ZTHEO02\ZLIKP with workspace Standard, user group ZTHEO02 and name ZLIKP. The results table will return up to 30 records. XtractQL provides expanded syntax options for SELECT statements for SAP Query executions. For example, you can specify the return fields in the form LIPS-LFIMG or you can specify a WHERE clause as you typically would in SAP ABAP.
In order for ERPConnect Services to utilize a custom function module (e.g. Z_XTRACT_IS_TABLE) instead of the standard SAP function module to avoid restrictions by reading SAP tables, you will use WITH-OPTIONS to set the CustomFunction property.
Select all records from table MARA. In SAP, the XQL query is executed using the custom function module Z_XTRACT_IS_TABLE.
In the section Table restrictions you can find more information about the restrictions and how to install the custom function module Z_XTRACT_IS_TABLE to avoid them.