Ansicht
Dokumentation

RHCHECKRELATIONS_OLD - Delete relationships without existing objects

TXBHW - Original Tax Base Amount in Local Currency   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Title

CHECKING THE CONSISTENCY OF RELATIONSHIPS

Purpose

This report eliminates all inconsistent relationship records from the database. The process comprises two steps. Any inconsistent records are selected and displayed in an output list (only if you did not select 'Delete Direct' at the start). The second step involves cleaning the database of inconsistencies. Entries (relationship records) from HRP1001 (database table for infotype 1001) are deleted for which no source or target objects exist. At the same time, the inverse relationships of the inconsistent records are also deleted. 'P' objects (persons) for which no corresponding personnel numbers exist, are also deleted.

Integration

Prerequisites

If you only enter a few parameters, the runtime of the report can become quite long (depending on the number of entries in database table HRP1001). Sometimes, the permitted runtime for programs started in the foreground may be exceeded. This may lead to time interrupts in the report. If this is the case, you should run the report in the background. In most cases, restricting parameters are entered meaning that the runtime of the report is kept to minimum. In this case, it makes sense to start the report in the foreground.

Features

Selection

Standard Variants

Output

The output list contains all relationship objects that do not have a target or source object. At the same time, the inverse relationships of the inconsistent objects are found and displayed. For person objects, objects without personnel numbers are found.

The output results are displayed in the ALV (SAP List Viewer). A broad spectrum of configuration functions are available, for example:

- Select several rows at once (select the beginning of the block of rows by clicking the left mouse button once, press the shift key and select the end of the block of rows by clicking the left mouse button again).

- Select several independent blocks (select an individual block then press the ctrl. key to select the beginning of the next block. Press the ctrl. key again to select the end of this block, and so on).

- The 'Change Layout' icon allows you to show any hidden columns or hide any shown columns.

- The 'Sort' keys allow you to sort entries in ascending or descending order.

- The 'Select' key allows you to select or deselect all entries from the output list.

- The 'Detail' key allows you to display the details of an entry.

- The 'Delete' key allows you to delete selected list entries from the database table.

- The 'Text Processing' key allows you to transport all displayed list entries to MS Word or MS Excel.

- The 'Filter' key allows you to set a filter to filter out any entries you do not want to be displayed.

Activities

The template for entering parameters is intuitive to use. The input fields have the following meanings:

- Plan Version - the plan version in which the search is to take place

- Object Type - type of object that is to be examined, for example, P, C, O, S, and so on.

- Object ID / Pers.No. - ID of object or personnel number for P objects

- User Name - name of person who created the object

- Direct Delete - if value is set to X, all selected objects in the ALV list are deleted without first being displayed.

- if value is set to SPACE, all objects found are displayed in the ALV list.

All input fields (input parameters) are available as individual values or as intervals. This means that you can enter a single value or more than one value. To enter more than one single value, click on the arrow icon on the right of the desired input field and enter the relevant values in the column for single values. You can also enter one or more intervals. To do this, click on the arrow icon and enter the interval values in the intervals column.

Example

All relationship objects of

- Plan version 01

- Type P

- Personnel numbers from 10000 to 15000

should be found that do not have a personnel number.

CL_GUI_FRONTEND_SERVICES - Frontend Services   General Material Data  
This documentation is copyright by SAP AG.

Length: 4499 Date: 20240601 Time: 211939     sap01-206 ( 89 ms )