SAP® Documentation

Single view

/SAPAPO/PPM_CLEAN_UP - Program /sapapo/PPM_CLEAN_UP

rdisp/max_wprun_time - Maximum work process run time   PERFORM Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

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 exist in 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.






BAL Application Log Documentation   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 3064 Date: 20191014 Time: 210848     sap01-206 ( 25 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.