Ansicht
Dokumentation

IUUC_DEL_OUTDATED_LOGTAB_ENTR - Delete Logging Table Entries created before the last Trigger was creat

TXBHW - Original Tax Base Amount in Local Currency   General Material Data  
This documentation is copyright by SAP AG.

Title

Purpose

If the database system you are using requires multiple triggers for each table (this is the case for all DB systems except for Oracle), it might happen that some time elapses between the creation of the first and the last trigger for a certain table. Especially if the corresponding DB table undergoes many changing operations while the triggers are being created. In such a case, the following problem might occur (T n mean subsequent points in time):

T1: Insert trigger is created

T2: A record is inserted to the table

T3: The same record is deleted from the table

T4: Delete trigger is created

This means, we now have only one logging table entry for the corresponding original table record. This logging table record suggests an insertion. For the deletion of that record which happened before the delete trigger was created, we do not have a logging table record. If this situation is detected in the delta replay, this would be interpreted as an inconsistency, because the record in the original table does not exist. However, the logging table entries that were created before the last of the necessary triggers for this table became active can and should be disregarded

For this report, execute this report. To be on the safe side, you should not restrict the range of processed objects by means of any selection. Schedule a batch job for this report.

Integration

Prerequisites

Features

Selection

Standard Variants

Output

Activities

Example

CPI1466 during Backup   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 1838 Date: 20240520 Time: 073655     sap01-206 ( 64 ms )