Ansicht
Dokumentation

IUUC_CREATE_NONSAP_TRIGGERS - Create DB Triggers in a non-SAP system

Vendor Master (General Section)   General Material Data  
This documentation is copyright by SAP AG.

Purpose

The reports allows to create DB triggers on tables in a nonSAP system (referred to as source system) using a DB connection that is defined in the system where this report is executed. This DB connection must be assigned to the mass transfer ID which you specify. As a prerequisite, logging tables must have been created in the source system, which you can do by means of report IUUC_CREATE_NONSAP_TABLES

The DB triggers will then make sure that any further DML operations on the specified tables will be recorded in the logging tables..

Integration

Prerequisites

Features

Selection

The triggers will be created for all tables which are part of the specified mass transfer ID, unless you further restrict the selection using the "Table Name" selection.
You need to define the DB schema to which the tables (and then also the triggers) belong.

In case Oracle, MaxDB or HDB is used as DB system, sequence objects are required for supplying the fields of the logging tables by means of the triggers. In order to increase the performance, sequence numbers should be cached. You can specify the sequence cache size for this purpose.

Standard Variants

Output

Activities

Example

Fill RESBD Structure from EBP Component Structure   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 1562 Date: 20240531 Time: 144745     sap01-206 ( 36 ms )