Table

This section shows how to set up a reusable SAP Table extraction.

Supported SAP Objects

Transparent tables
Views
ABAP CDS Views - CDS Views based on entities are not supported
HANA CDS Views
Pool tables
Cluster tables

Prerequisites

A valid connection to an SAP system is available.
The SAP user of the SAP connection has sufficient user rights, see Knowledge Base Article: SAP Authorization Objects
A valid connection to a data destination is available.
Know the technical name of the SAP table you want to extract / the SQL name of the CDS View you want to extract.

Tip

You can fetch the names and descriptions of tables in your SAP source system using the Xtract Core API.

Create Table Extractions

Use the following endpoint to create a new table extraction:

POST /v1/extractions/table/{name}

example curl javascript

POST /v1/extractions/table/mara HTTP/1.1
Host: localhost:1337
Content-Type: application/json
Content-Length: 342

{
"Table": "MARA",
"Where": "MATNR = 000000000001",
"Source": "s4hana",
"Destination": "azure",
"Columns": [
    [
    "MATNR",
    "MANDT"
    ]
],
"FolderPath": "abcdefgh-1234-ijkl-5679-ijklmnopqrst/SOMETABLE/year=2025/month=12/day=19",
"ResultName": "resultset",
"FunctionModule": "/THEO/READ_TABLE",
"ColumnNameStyle": "PrefixedCode"
}

curl -X POST \
     -d '"Table": "MARA", "Where": "MATNR = 000000000001", "Source": "s4hana", "Destination": "azure", "Columns": ["MATNR", "MANDT"], "ResultName": "materials", "FunctionModule": "/THEO/READ_TABLE"' \
     'http://localhost:1337/v1/extractions/table/mara'

fetch('http://localhost:1337/v1/extractions/table/mara', {
  "method": "POST",
  "body": JSON.stringify("Table": "MARA", "Where": "MATNR = 000000000001", "Source": "s4hana", "Destination": "azure", "Columns": ["MATNR", "MANDT"], "ResultName": "materials", "FunctionModule": "/THEO/READ_TABLE")"
});

Tip

The Content-Length property in the header represents the byte size of the JSON string in the request body. When using curl, the Content-Length can be determined automatically. The -v (verbose) option returns the request details, including Content-Length.

For more information about mandatory and optional parameters, refer to the API Reference: Table Extraction.

Last update: December 19, 2025

Table

Supported SAP Objects

Prerequisites

Create Table Extractions

Related Topics