/SAPAPO/PPM_CLEAN_UP - Program /sapapo/PPM_CLEAN_UP

BAL Application Log Documentation   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Title

ppm_clean_up

Purpose

Deletion report to remove all data records in the PPM that have no connection to superordinate data (tables) and therefore have no function.

The following tables are checked:

PPM:

/sapapo/plan,

/sapapo/pltext,

/sapapo/planopr,

/sapapo/planoprt,

/sapapo/planact,

/sapapo/planactt,

/sapapo/planactz,

/sapapo/comp,

/sapapo/compalt,

/sapapo/compaltz,

/sapapo/actrel,

/sapapo/mode,

/sapapo/reqcap.

Material flow and container resources:

/sapapo/prodflow,

/sapapo/compalts,

/sapapo/reqcaps.

Time-dependent process parameters:

/sapapo/tdpp.

Sources of supply and model:

/sapapo/trprod,

/sapapo/ppmt,

/sapapo/prodverz,

/sapapo/s_trpmod.

Characteristics tables:

/sapapo/tmc01c,

/sapapo/tmc01a,

/sapapo/tmc01abc,

/sapapo/tmc01c0,

/sapapo/tmc01ab,

/sapapo/tmc01ca,

/sapapo/tmc01cpa,

/sapapo/tmc01an,

/sapapo/tmc01ob,

/sapapo/tmc01rl,

/sapapo/tmc01rlt,

/sapapo/tmc01ar.

The deletion report works hierarchically from top to bottom. If you delete data records, the associated data records in the dependent tables are also deleted.

Integration

Prerequisites

Features

Selection

Standard Variants

Output

Activities

To read and check the selected data, select the field 'Display data'.

To carry out the check, copy random data records from the list issued and check if they actually existin the table you checked or if they do not exist in the superordinate table (for example, using the data browser - transaction SE16).

To delete and later check the selected data, select the field 'Delete data'.

After confirming the warning with 'Yes', the data is deleted. The list of data selected for deletion is displayed again afterwards.

If an error occurs when reading or deleting the data, the program terminates and the following message appears: 'An error occurred when deleting the data'.

Example

In the table /sapapo/pltext that contains the short texts for plans of the table /sapapo/plan, there are still short texts for plans that were already deleted in table /sapapo/plan.

You can read these entries that have no connection to the superordinate table /sapapo/plan first, and then delete them after a check.

rdisp/max_wprun_time - Maximum work process run time   BAL Application Log Documentation  
This documentation is copyright by SAP AG.


Length: 2626 Date: 20120523 Time: 202651     triton ( 98 ms )