Extract long text from SAP

Overview

Long texts (also referred to as SAPscript texts or text objects) are the containers attached to SAP ERP objects to accommodate long text in SAP systems. Users can add free text and even apply formatting without being blocked by common database or application restrictions. Users can add long texts to common SAP objects such as sales orders, materials, or notifications.

Long texts are stored in the STXL table in a compressed format. This table holds the long texts for all SAP objects. It needs to be decompressed in order to be readable in Foundry.

Prerequisites

Palantir Foundry Connector 2.0 for SAP Applications SP16 or above

Extracting long text

The Foundry SAP Connector has the functionality to decompress long texts before sending the STXL table to Foundry. A new record needs to be added to the configuration table to activate this functionality. To add a new record:

Run the transaction /n/PALANTIR/DECOMPRESS
In the configuration table, fill in the following Connector parameters:
1. OBJECT TYPE: SLT, TABLE or REMOTETABLE (depending on your setup)
2. OBJECT: STXL
3. FIELD: CLUSTD
4. ITEM NO: 1
5. INTERFACE COMPONENT: DECOMPRESSION_LRAW
Create a new sync and ingest the long texts table. Since the STXL table is typically very large, it is best to filter the table by object name.

The format of the sync config is as follows:
```
Copied!1
2
3
4
5
type: magritte-sap-source-adapter
sapType: <slt>/<table>/<remotetable>
obj: STXL
context: <SLT_Context>/<Remote_Agent_Context>
filter: <filters>
```
An example sync:
```
Copied!1
2
3
4
type: magritte-sap-source-adapter
sapType: table
obj: STXL
filter: TDOBJECT=QMEL
```
You can filter the STXL table by object names and text ids. For example:
- Notification Object: TDOBJECT=QMEL
- Notification Object header long texts: TDOBJECT=QMEL;TDID=LTXT
- Purchase Order header texts: TDOBJECT=EKKO
- Purchase Order item texts: TDOBJECT=EKPO