Skip to content

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

Before creating extractions, make sure to meet the following requirements:

Tip

You can fetch the names and descriptions of the 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}

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

{
"Table": "MARA",
"Where": "MATNR = 000000000001",
"Source": "s4hana",
"Destination": "azure",
"Columns": ["MATNR", "MANDT"],
"ResultName": "materials",
"FunctionModule": "/THEO/READ_TABLE"
}

curl -X POST \
     -d '"Table": "MARA", "Where": "MATNR = 000000000001", "Source": "s4hana", "Destination": "azure", "Columns": ["MATNR", "MANDT(1)"], "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(1)"], "ResultName": "materials", "FunctionModule": "/THEO/READ_TABLE")"
});
[Content-Type: application/json] [Content-Length: 190]

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: September 1, 2025