Title
CHECKING THE CONSISTENCY OF RELATIONSHIPS

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

Prerequisites
If you only enter a few parameters, the runtime of the report can becomequite long (depending on the number of entries in database tableHRP1001). Sometimes, the permitted runtime for programs started in theforeground may be exceeded. This may lead to time interrupts in thereport. If this is the case, you should run the report in thebackground. In most cases, restricting parameters are entered meaningthat the runtime of the report is kept to minimum. In this case, itmakes sense to start the report in the foreground.

Features

Output
The output list contains all relationship objects that do not have atarget or source object. At the same time, the inverse relationships ofthe 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 broadspectrum of configuration functions are available, for example:
- Select several rows at once (select the beginning of the block of rowsby clicking the left mouse button once, press the shift key and selectthe end of the block of rows by clicking the left mouse button again).
- Select several independent blocks (select an individual block thenpress the ctrl. key to select the beginning of the next block. Press thectrl. key again to select the end of this block, and so on).
- The 'Change Layout' icon allows you to show any hidden columns or hideany shown columns.
- The 'Sort' keys allow you to sort entries in ascending or descendingorder.
- The 'Select' key allows you to select or deselect all entries from theoutput list.
- The 'Detail' key allows you to display the details of an entry.
- The 'Delete' key allows you to delete selected list entries from thedatabase table.
- The 'Text Processing' key allows you to transport all displayed listentries to MS Word or MS Excel.
- The 'Filter' key allows you to set a filter to filter out any entriesyou do not want to be displayed.

Activities
The template for entering parameters is intuitive to use. The inputfields 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 ALVlist are deleted without first being displayed.
- if value is set to SPACE, all objectsfound are displayed in the ALV list.
All input fields (input parameters) are available as individual valuesor as intervals. This means that you can enter a single value or morethan one value. To enter more than one single value, click on the arrowicon on the right of the desired input field and enter the relevantvalues in the column for single values. You can also enter one or moreintervals. To do this, click on the arrow icon and enter the intervalvalues 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.