Kontakt

Ansicht
Dokumentation

RLMDB_CLEAR_CHANGELOG - Clear Change Log with Job

RLMDB_CLEAR_CHANGELOG - Clear Change Log with Job

Addresses (Business Address Services)   General Material Data  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

The data volume in the table LMDB_P_CHANGELOG is very large, and you want to reduce it.

Integration

Prerequisites

In the table LMDB_P_CHANGELOG, all change operations are recorded so you can subsequently determine how objects were changed in the LMDB, and the data volume in the table grows over time.

Features

Use this report to delete entries that are old and no longer required, from the table LMDB_P_CHANGELOG.

To be able to track the most recent changes, retain the history of recent months.

You can schedule the process to be executed periodically in a background job, for example you can clear all entries older than three months, every month, using dynamic date calculation.

Selection

  • Local Namespace: LMDB namespace from which the change log entries are to be removed
  • Remove entries older than: The date limit (UTC) of the change log entries to be removed
  • Choose Countto show the number of change log entries which will be removed. (see the result in field No. of entries to be removed)

Standard Variants

Output

Activities

To schedule the report in a periodic background job, with dynamic date calculation, proceed as follows:

  1. In SE38, define a variant for the Remove entries older than field to use dynamic date calculation.
    Note: Enter a minus sign (-) for a date in the past. For example, to remove entries older than 30 days, enter "-30". For more details on defining a dynamic date variant, see http://wiki.scn.sap.com/wiki/x/T4V9Fw.
  2. Schedule the report as a background job, using the variant.

Example

This example shows how to define this report to run every month, to clean change log entries older than 3 months (90 days).

  1. Define a new variant in the variant maintenance of the RLMDB_CLEAR_CHANGELOG report. You have two options:
  • In SE38, enter the report name, choose Variants and choose Change. Enter a new variant name and choose Create.Fill the required fields: Select the namespace and enter any date (the date will be calculated dynamically). Choose Attributes and define the variant.

  • In SE38, start the report and fill the required fields: Select the namespace and enter any date (the date will be calculated dynamically). Choose Save.

  1. Define the attributes of the variant:
    1. In the variant maintenance screen, in the Remove entries older than row, in the Selection variable column, choose D: Dynamic Date Calculation (Local Date).
    2. In the Name of Variable column, select the expected value from the input help, in this example Current date +/- ??? days.
    3. Enter "-90" (older than 3 months) as the value for ???. Do not forget the minus sign.
    4. Save the variant.
  2. Start the report using the predefined variant, and schedule it periodically:
    1. Start the report.
    2. Choose System > Services > Jobs > Define Job.
    3. Enter the job name, choose Stepto apply the variant.
    4. Choose Date/Time, then choose Monthlyto run the job every month.
      Fill the Scheduled start time and No Start After time.
    5. Save the job definition.






rdisp/max_wprun_time - Maximum work process run time   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 4735 Date: 20240531 Time: 113204     sap01-206 ( 63 ms )