SAP Clean Temporary Table

Tools

Description

Use this tool to clean and delete data from the temporary SAP table used by xDI.

The SAP connector for xDI uses the temporary table ZSTB_TRANSF_TBL when extracting data from SAP. xDI tries to clean this table automatically but, if something interrupts the cleanup, some data can remain. You can use this tool at any point in a process to delete some or all data from the temporary table.

Usage

To use this tool, follow these steps:

Place the tool in a process.
Drag and drop an SAP server metadata object onto the tool’s SAP field.
Optionally, define which data you want to clean in the Where Clause parameter.
Connect the tool in the process flow.

Parameters

Name Default Description

Name	Default	Description
Where Clause	`SESSION_ID like '%'`	A condition, used in a `WHERE` clause, which determines what data to delete from the temporary table in SAP. The default condition removes all data from the temporary table by targeting entries with any session ID. Do not use this condition if another xDI process is currently using SAP.

Where Clause

SESSION_ID like '%'

A condition, used in a WHERE clause, which determines what data to delete from the temporary table in SAP.

The default condition removes all data from the temporary table by targeting entries with any session ID. Do not use this condition if another xDI process is currently using SAP.