Some other SAP HR utility report which can be more useful for us are as below:
1. RPDKON00 (wage type assignment – GL/Account display
Use for the Posting to Accounting: Display Assignment of Wage Types to G/L Accounts report (RPDKON00), to display the assignment of wage types to G/L accounts. This assignment is not made directly, but is always made using a symbolic account and the employee grouping for the account determination.
You must assign wage types to G/L accounts in Payroll Customizing under Reporting for Posting Payroll Results to Accounting.
- To assign symbolic accounts to the wage types, choose Activities in the HR System -> Maintain Wage Types -> Define Posting Characteristics of Wage Types. Here you can enter a processing type in order to assign posting characteristics of a wage type to the following business processes:
- Posting payroll results to Accounting
- Posting month end accruals
- Sending personnel cost data to Cost Planning
- To define the employee grouping for the account determination, choose Activities in the HR System -> Employee Grouping/Symbolic Accounts -> Define Employee Grouping .
- To assign G/L accounts to the symbolic accounts based on the employee grouping for the account determination, choose Assign Accounts
2. RPDLGA20 (Wage Type Documentation)
Uuse this report to get an overview of the wage type characteristics for all primary and secondary wage types that you use in your system. In this way, you can compare the wage type characteristics for different wage types.
You can only use this report to evaluate the wage type characteristics that determine the behaviour of a wage type in Payroll, and not the wage type characteristics which define the behaviour of a wage type in online processing.
The report displays the following:
- the meaning of the wage type characteristics
- wage types, for which one wage type characteristic is used
- wage types, for which one wage type characteristic has the same specification
- personnel areas, which belong to the selected country grouping
3. RPDLGA00 (Wage Types from Table T511 or T512T)
Report RPDLGA00 Lists the wage types defined in tables T511 or T512T. Permitted infotypes and the definitions in table T512W can also be displayed for each wage type.
The basic list contains some of the features from table T511 if the wage type is defined in T511. The text from T512T is also shown. In the interactive mode, you can also display additional information on a particular wage type using the appropriate function key.
DISPLAYING PERMITTED INFOTYPES
Select a wage type with F9 and display the permitted infotypes. You can change the entry if you have activated the ‘Call table’ function.
WAGE TYPES FROM T511 OR T512T?
You can define whether wage types for the basic list should be taken from T511 or T512T. The report reads only those entries of T512T which correspond to the logon language. If the required wage types are in both T511 and T512T, use T511 because access is faster.
You can preselect data by entering the country grouping. Lists or value ranges can also be specified. Report data can also be delimited by entering search terms for wage types or wage type texts. INCL, EXCL, MASK, SCAN functions can also be used for selection criteria.
INTERACTIVE OR AUTOMATIC MODE ?
If you select the automatic mode by marking the ‘Mode of operation’ checkbox, you cannot use the function keys. Specific information is automatically included in the basic list. Use this mode of operation to create printouts.
4. RPDLGA40 (T512W: Cumulations, Evaluation Classes and Processing Classes)
Report RPDLGA40 can be used to set up and manage wage types. It provides information on
- the cumulation wage types and evaluation and processing classes of the individual wage types
- the wage types of each cumulation wage type and the processing or evaluation class.
The report can therefore be used to answer the following questions:
- Which cumulations and evaluation and processing classes are available for a particular wage type or group of wage types?
- Which wage types use a specific cumulation wage type or specification of an evaluation or processing class?
Report RPDLGA40 uses table T512W ‘Wage Type Valuation’. Wage type texts are read from table T512T.
The basic list shows an overview of the selected wage types. If the ‘Text for cumulation wage types’ parameter is set, the report lists the cumulations for each wage type. If not, the report displays a string of processing classes and, if available, cumulations for each wage type. Additional information can be displayed using the function keys.
- Evaluation classes of each wage type
F5 allows you to display the evaluation classes for the selected wage type.
- Processing classes of each wage type
F6 allows you to display the processing classes for the selected wage type.
- Overview of the cumulation wage types that have been read
F7 allows you to display the wage types that have been read for each cumulation.
- Overview of the processing classes that have been read
F13 allows you to display the wage types that have been read for each processing class. The list contains only those processing classes and features for which at least one wage type was read.
- Overview of the evaluation classes that have been read
F8 allows you to display the wage types that have been read for each evaluation class. The list contains only those evaluation classes and features for which at least one wage type was read.
Delete Data Records from Personnel Planning Database
This program enables you to delete records from the HRPnnnn file.
WARNING: Please consider the consequences of such deletions, especially if you do not use parameters to restrict the selection.
You can restrict the objects selected for deletion using the following parameters:
Object name (OBJID)
Display deleted objects
‘X’: The objects deleted from the database are displayed.
‘X’: The objects to be deleted are locked. The system also determines whether the objects are currently being edited by other users, in which case they cannot be deleted.
Display deleted records
‘X’: All records deleted from the database are displayed.
‘X’: The database is not changed. You can use a test run to display the records that would be affected by your selection if a live run were performed.
Delete Individual Personnel Planning Records
This report lists all info type records found. You can select individual records and choose “Delete” to delete records.
However, you cannot use this report to delete records with time constraint 1, such as records assigned to infotype 1000.
If you need to delete such records, use report RHRHDL00 or transactions PP01/PP02.
Delete Superfluous Entries in PD Tables. his program specifically deletes the SAP delivered sample objects that cannot be removed with the above mentioned programs.
P.S. Search for this program name on OSS to find a few other tricks related to this method.
Delete relationships without existing objects
CHECKING THE CONSISTENCY OF RELATIONSHIPS
This report removes all inconsistent R/3 relationship records from the database. This takes place in two steps. Unless you have chosen “direct delete” at the start, the inconsistent records are selected and displayed in an output list. The second step is the actual removal of inconsistencies from the database, in that the entries (relationship records) in HRP1001 (DB table for infotype 1001) that do not have a source or target object are deleted. At the same time, the system deletes the inverse relationships of the inconsistent records. Logically, ‘P’ objects (people) whose personnel numbers do not exist are also deleted.
If you enter only a few parameters, you should note that the report can have a very long run time (depending on the number of entries in the database table HRP1001). This can sometimes exceed the permitted run time for programs run in the foreground and may lead to an interruption (time interrupt) in the report. In such cases you should run the report in the background. In most cases restrictive parameter entries are made which keep the report’s run time to a minimum, so that it makes sense to run the report in the foreground.
The output list contains all relationship objects that have no source or target object. At the same time the system finds and displays inverse relationships of the inconsistent objects. In the case of people objects, the system finds objects without personnel numbers.
The system displays the output results in the ALV (ABAP List Viewer) There, you will find a wide range of configuration functionalities. You can, for example:
– Select several lines as one block (click with the left mouse button at the beginning of the block, then hold down the shift key and click with the left mouse button at the end of the block).
– Select several independent blocks (select a single block, then press the Ctrl key as you click at the beginning of the second block, hold down Ctrl again as you click the end of the second block and so on)
– Show hidden columns or hide visible ones using the ‘Change Layout’ icon
– Sort all entries in ascending or descending order using the ‘sort keys’
– Select or deselect all entries in the output list using the ‘select keys’
– Display details of an entry using the ‘detail key’
– Delete selected list entries from the database using the ‘delete key’
– Transport all displayed list entries to MS-Word or MS-Excel using the ‘word processing key’
– Set a filter using the ‘filter key’, for example to filter out unwanted entries
The parameter entry screen is easy and intuitive to use. The entry fields have the following meanings:
– Plan version – the plan version in which you wish to search
– Object type – type of object you want to examine, for example P, C, O, S …
– Username – name of the person who created the object
– Direct delete – if you insert an ‘X’ here, the system will delete all the objects selected in the ALV list without displaying them first – if you leave a blank, the system will display objects found in the ALV list
All entry fields (entry parameters) are available as single values or as ranges. You therefore have three possibilities: you can enter a single value; you can enter several single values by clicking on the arrow icon next to the entry field you are working on and making your entries in the column for single values; you can enter one or more ranges by clicking the arrow icon and entering the range values in the range column.