跳转至

Extract long text from SAP（从 SAP 提取长文本）

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

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:

  1. Run the transaction /n/PALANTIR/DECOMPRESS

  2. In the configuration table, fill in the following Connector parameters:

  3. OBJECT TYPE: SLT, TABLE or REMOTETABLE (depending on your setup)
  4. OBJECT: STXL
  5. FIELD: CLUSTD
  6. ITEM NO: 1

  7. INTERFACE COMPONENT: DECOMPRESSION_LRAW

  8. 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:

type: magritte-sap-source-adapter
sapType: <slt>/<table>/<remotetable>
obj: STXL
context: <SLT_Context>/<Remote_Agent_Context>
filter: <filters>

An example sync:

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

中文翻译

从 SAP 提取长文本

长文本（也称为 SAPscript 文本或文本对象）是附加在 SAP ERP 对象上的容器，用于在 SAP 系统中容纳长文本。用户可以添加自由文本，甚至应用格式，而不会受到常见数据库或应用程序限制的阻碍。用户可以将长文本添加到常见的 SAP 对象中，例如销售订单、物料或通知。

长文本以压缩格式存储在 STXL 表中。该表保存了所有 SAP 对象的长文本。为了在 Foundry 中可读，需要对其进行解压缩。

前提条件

提取长文本

Foundry SAP Connector 具备在将 STXL 表发送到 Foundry 之前解压缩长文本的功能。需要在配置表中添加一条新记录以激活此功能。要添加新记录：

  1. 运行事务 /n/PALANTIR/DECOMPRESS

  2. 在配置表中，填写以下 Connector 参数：

  3. OBJECT TYPE：SLT、TABLE 或 REMOTETABLE（取决于您的设置）
  4. OBJECT：STXL
  5. FIELD：CLUSTD
  6. ITEM NO：1

  7. INTERFACE COMPONENT：DECOMPRESSION_LRAW

  8. 创建新的同步并摄取长文本表。由于 STXL 表通常非常大，最好按对象名称过滤该表。

同步配置的格式如下：

type: magritte-sap-source-adapter
sapType: <slt>/<table>/<remotetable>
obj: STXL
context: <SLT_Context>/<Remote_Agent_Context>
filter: <filters>

同步示例：

type: magritte-sap-source-adapter
sapType: table
obj: STXL
filter: TDOBJECT=QMEL

您可以按对象名称和文本 ID 过滤 STXL 表。例如：

  • 通知对象：TDOBJECT=QMEL
  • 通知对象标题长文本：TDOBJECT=QMEL;TDID=LTXT
  • 采购订单标题文本：TDOBJECT=EKKO
  • 采购订单行项目文本：TDOBJECT=EKPO