Table Services
This page shows how to use the Table service type.
The Table service type can be used to extract data from SAP Tables and Views.
Supported SAP Objects
- Transparent tables
- Views
- ABAP CDS Views - CDS Views with parameters are not supported
- HANA CDS Views
- Pool tables - table joins are not supported
- Cluster tables - table joins are not supported
For information on restrictions by the SAP standard function module for table data extractions and how to avoid them, see RFC_READ_TABLE Restrictions.
Prerequisites
- A connection to an SAP system is available, see SAP Connection.
- The SAP user used in the SAP connection has sufficient user rights, see SAP Authority Objects.
Warning
Missing Authorization.
To use the Table service type, access to the designated authority objects (RFC) in SAP must be available. Adjust SAP Authority Objects accordingly.
Create a Table Service
To create a new Table web service in Xtract Universal.iQ:
- Open the Services menu.
- Click [Add Service].
- Enter a unique name and a description.
- Optional: Activate the checkbox Enable MCP Access and add an MCP description to expose the service via the Xtract Universal.iQ MCP Server.
- Select an existing SAP connection from the Connection dropdown. If no connection is available, create a connection, see Connect to SAP.
- Select Table from the Type dropdown.
- Select a target environment from the Destination dropdown. By default, Xtract Universal.iQ services return SAP data in HTTP response of the service (HTTP destination).
- Click [Save].
The service is now listed in the Services menu.
Next, select the SAP object you want to extract.
Look Up an SAP Table or View
To select an SAP Table or View from your SAP source system:
- Create a new service of service type Table or edit an existing service.
- In the Table or View section of the service, click [Add Table]. The "Search SAP tables and views" menu opens.
- Enter the technical name or description of an SAP Table or View. To look up CDS Views, enter the SQL name of the CDS View. Use wildcards ( * ) if needed.
- Click [Search] to display the search results.
- Select a table or view from the list of search results. The "Search SAP tables and views" menu closes.
Xtract Universal.iQ loads and displays the metadata of the table or view in the service.
Next, configure the remaining service settings.
Configure the Table Service
After creating the service, configure the service using the following workflow:
- Go to the output columns section and select the table columns you want to extract. By default all columns are selected.
- Optional: Join two or more tables and extract the result of the join. For more information, see Table Joins.
- Optional: Define a WHERE clause to filter table records. By default all data is extracted.
- Optional: Edit the Service Settings to define how the data is extracted from SAP.
- Optional: Edit the Destination Settings to define the output of the service.
For more information, see Table Settings.