ListQueries
Retrieves metadata about available SAP queries and their fields, helping users select the correct query structure for data extraction.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC ListQueries UserGroup = 'ZGROUP', Query = 'ZQUERY', Workspace = 'Global'
The UserGroup input specifies the SAP user group, and the Query input filters results to a specific query name.
Input
| Name | Type | Description |
| UserGroup | String | SAP user group for which to list available queries. User groups control access to queries in SAP Query (SQ01). |
| Query | String | Optional filter to return a specific query by name within the specified user group. |
| Workspace | String | Optional name of the workspace used to organize the query metadata results.
The allowed values are Global, Local. The default value is Global. |
Result Set Columns
| Name | Type | Description |
| QueryName | String | Name of the SAP query returned in the result set. |
| UserGroup | String | SAP user group associated with the returned query. |
| Variant | String | Default variant configured for the query, used to prefill selection criteria and layout options. |