Ansicht
Dokumentation

RNUDNKIP - IS-H: Delete Duplicate Entries in Table NKIP for Unique Index

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Description

The program lists all of the records in the table NKIP (pre-approved insurance/default values) for all clients in the system. If the program detects the same sequential number NKIP (internal key) more than once in a client, it selects all duplicate records.

You can run the program in test mode or in live mode.

Important Note

In live mode, the program deletes, without requesting confirmation, records with the same sequential number NKIP, with the exception of the first record found for a number.

If you don't wish deletion to be automatic, proceed as follows:

1. Run the program in test mode.
2. Process the result list manually using the transaction NK30 (change pre-approved insurance) and NK35 (change default values) as follows:
1. Call one of the two transactions.
2. First copy the incorrect entry, since the copy contains a new sequential numebr NKIP.
3. Then delete the incorrect entry.
3. After you have processed all duplicate entries, you should run the program RNUDNKIP again.
4. When no further duplicate entries with the same sequential number are found, you can create the secondary index as described in the release note Unique Index for Pre-Approved Insurance/Default Values.

Requirements

Output

Example

PERFORM Short Reference   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 1656 Date: 20240531 Time: 113752     sap01-206 ( 29 ms )