XQL - Xtract Query Language
A few years ago I developed XQL, the Xtract Query Language (XtractQL), which got integrated in various Theobald products in the meatime in order to dynamically retrieve SAP business data by using a simple query language. The XtractQL syntax combines elements from the SQL and ABAP languages and can be used on:
- SAP tables/objects and their metadata
- Funktion modules (BAPIs)
- BW cubes
- SAP queries
- MDX statements
A XtractQL .NET Data Provider is supported by the ERPConnect library from Theobald Software.
The following examples show how XtractQL can be used.
Select the first five records from table T001W where the field FABKL has a value of US. Select all records from table MARA. In SAP, the XQL query is executed using the custom function module Z_XTRACT_IS_TABLE. 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.
XQL query to discover the metadata for the Export parameter collection of function module SD_RFC_CUSTOMER_GET. XQL query to discover the metadata for the FIELDS of SAP Query ZTHEOSQUERY. XQL query to execute SAP function module SD_RFC_CUSTOMER_GET using the Export parameter KUNNR. The SAP table CUSTOMER_Twilldurch die Syntaxbeschreibung INTO @RETVAL definiert. See link below for more XtractQL examples.
The Syntax of XtractQL and Examples (for ERPConnect Services)