SAP HR analytics software package

  • Executive HR reporting, predefined HR and software content, customization if needed
  • Use it to track key HR Metrics through numbers and visualization (40+ key metrics)
  • 90+ measures
  • Communicates 1 clear/uniform message to executive
  • Improve decision making and HR strategies – reliable and accessible data
  • Expedite collaboration by easy sharing
  • Drill down into organization structure and cost center hierarchy to uncover trends
  • Custom reports already built can be integrated using Netweaver

Logged Changes in Infotype Data – RPUAUD00

Use

 

This report RPUAUD00 is used to display all changes that were made using infotype change documents (short: change documents ).

 

Prerequisites

 

So that changes to infotype fields (change, create, delete) are recorded as documents, you must make sure that these fields are maintained in the views HR Documents: Infotypes to be Logged (V_T585A), HR Documents: Field Group Definition (V_T585B) and HR Documents: Field Group Characteristics (V_T585C).

An archive can only be displayed if it has been created with Archive Administration (transaction SARA).

 

Features

 

You can create the following types of documents with this report:

* Long-term documents

Long-term documents are created for revision purposes. Changes made to infotypes are written to the database or can be archived. Long-term documents remain available until you delete them. The archiving object is called PA_LDOC.

Long-term documents evaluate data according to personnel numbers and infotypes. For this reason, the columns PersNo (personnel number) and Inftyp (infotype) are displayed at the top of the drilldown list.

* Short-term documents

Short-term documents are stored in the database. The data for short-term documents is selected according to date and time. In contrast to long-term documents, the columns Date and Time are displayed at the top of the drilldown list.

 

Selection

 

Specify the type of documents that you want to create under Read documents from database. To specify a document type, set the relevant indicator.

Under Selection, specify:

* which transaction classes are to be included in the selection with the relevant indicators
* which employees are to be selected, in the Personnel number field
* which data the system is to evaluate, in the Infotype field
* whether a specific change date, or a certain interval period is to be considered, in the Change date field
* whether you want to display the changes made by a specific user, in the User name field

 

Note

 

As a rule, the system reads the data from the database.

If you want additional archived data to be read, select Read from archive. Additional selection options are displayed under Archive selection:

* Also read from database

The documents currently in the database that belong to the archived data and meet the selection criteria are also displayed.

* Archive selection by user

This takes you to the Archive Administration: Read Data Selection screen. Select the required archive.

Specify how the documents are to be output, under Output options.

* Direct output of docs
* Output program selections
* New page per doc.

Only set this indicator if you have selected Direct output of docs..

* Sort

If you set one of the following indicators, the data is sorted in accordance with the indicators:

* Time
* Personnel number
* Infotype
* User
* Default currency

 

Output

 

The results are displayed in accordance with your Output options:

* Drilldown list

If you have not made any selections under Output options, the list contains an overview of the documents.

* Long-term documents

Thc columns at the head of the long-term documents are always displayed in this sequence: PersNo (personnel number), Inftyp (infotype), Date, Time, SqNo (sequence number) and Changed by.

* Short-term documents

Thc columns at the head of the short-term documents are always displayed in this sequence: Date, Time, SqNo (sequence number), PersNo (personnel number), Inftyp (infotype), and Changed by.

* Display program selections

If you have made a selection here, the output is in the form of a drilldown list. The selection options are also output.

* Detail List

* Documents

If you have selected Direct output of docs, the documents are displayed. The documents contain the information taken from the head of the drilldown table, and details on the changes made in an infotype.

If you have also selected New page per doc., each document is printed on a separate page.

 

SAP PA – Master data changes report – RPUAUD00

Report RPUAUD00 (Logged Changes in infotype Data) is used to track the master data changes.

Configuration required:

There are two different ways that can be followed for configuring the report.  This can be done either though IMG or directly configured through tables.

IMG Path:

Personnel Management -> Personnel Administration -> Tools -> Revision -> Set up change document

Tables:

V_T585A – HR Documents: Infotypes to be logged.

The infotypes that needs to logged for changes has to be maintained in this table.

V_T585B – HR Documents: Field Group Definition.

This table is needed for defining the field groups (for logging the changes together including all the fields). In addition, individual field can also be logged.

V_T585C – HR Documents: Field Group Characteristics

This table allows in setting up the document type as whether the document created for infotype log creation is short – term documents or long –term documents.

SAP HR Reports – by Module

SAP HR REPORTS / PAYROLL PROGRAMS

Find below the comprehensive list of SAP HR related reports including commonly used Payroll reports and time management reports etc.

PA reports

RPLACTJ0 Employee Actions List
RPLEHSU0 Employee Job/Salary History
RPLINFC0 Infotype Overview for Employees
RPLMIT00 Employee List
RPLPAY00 Payments and Deductions List
RPLREF00 Reference Personnel Numbers
RPUAUD00 Infotype Audit Report

PA Integration Reports

RHINTE00 Transfer data from PA to OM
RHINTE10 Prepare Tables for transfer of data from

OM to PA
RHINTE20 Check all the fields are configured in both
OM and PA tables
RHINTE30 Transfer data from
OM to PARecruitment

RPAPL001 Applicants by Name
RPAPL002 Applications
RPAPL003 Vacancy Assignments
RPAPL004 Applicants by action
RPAPL005 Applicant Statistics
RPAPL006 Job Advertisements
RPAPL008 Evaluate Recruitment Instruments
RPAPL009 Applicants by Activity
RPAPL010 Vacancies
RPAPL011 Applicants’ Education and Training
RPAPL012 Variable Applicant List

Time Reports

RPTQTA10 Display Leave Quotas
RPTQTA00 Bulk Leave Quotas Update
RPLTIM00 Time Recording Overview
RPTABS20 Attendance/Absence Data: Overview
RPTABS50 Attendance/Absence Data: Calendar View
RPTABS60 Attendances/Absences: Multiple Employee View
RPTENT00 Time Recording for Multiple Persons and Infotypes
RPTLEA40 Overview Graphic of Attendances/Absences
RPTTYYCA Extract employee data into spread sheet
RPTLEACONV Transfer of Remaining Leave from Infotype 0005 to Infotype 2006
RPLABSG0_ABSENCE_HISTORY Absence history
RPLABSG0_ENTITLEMENT_DETAILS Entitlement Details


Payroll Programs / Payroll Reports
Schemas and PCRs

RPUCTF00 Change Attributes for Schemas and PCRs (change owner)
RPUCTI00 Lists Subschemas not called up in any other schema
RPUCTJ00 Lists Personnel Calculation Rules which are not called up
RPUCCOSE Source text search in PC rules
RPUCTX00 Copy Personnel Calculation Rules from client 000 to other clients
RPUSCD10 Schema directory – useful after LCP to see changed schemas, also shows who changed it last and when
RPUCTC00 Displays PCRs full source text
RPUDEL20 Deletes payroll results

Wage Type Utilities

RPU12W0C (HR utility 512W-classes) allows you to reload backups of specific processing classes,
cumulations and evaluation classes created with RPU12W0S in T512W
RPU12W0S Creates a backup of T512W in T599U or reloads the backup into T512W.
RPU99U0V Displays T599U
RPU5XX0D Generically deletes entries in T599U, T512W or T512T<
/span>

OM Reportsorganisation
SAP Report RHCDOC_DISPLAY To view the change document on OM,
SAP Report RHXSTAB0 Staff Functions for Organizational Units
SAP Report RHSTEL00 Job Index-search with object id/type/plan version
SAP Report RHXSTEL0 Job Index
SAP Report RHXDESC0 Job Description
SAP Report RHXSCRP0 Complete Job Description
SAP Report RHSBES00 staff Assignments
SAP Report RHXDESC1 Position Description
SAP Report RHXSTAB1 Staff Functions for Positions
SAP Report RHFILLPOS Periods for Unoccupied Positions
SAP Report RHXHFMT0 Authorities and Resources
SAP Report RHSOLO00/RHXSOLO00) Planned Labor Costs
SAP Report RHVOPOS0 Vacant Positions
SAP Report RHVOPOS1 Obsolete Positions
SAP Report RHXSCRP1 Complete Position Description
SAP Report RHSTR04 Reporting Structure with Persons
SAP Report RHSTR05 Reporting Structure without Persons
SAP Report RHXSTRU06 Work Centers per Organizational Unit
SAP Report RHXSTR02 Organizational Structure with Persons
SAP Report RHXSTR03 Organizational Structure with Work Centers
SAP Report RHXSTR07 Activity Profile of Positions
SAP Report RHXSTR08 Activity Profile of Positions with Persons
SAP Report RHEXIST0 Existing Objects
SAP Report RHXEXI00 Existing Organizational Units
SAP Report RHXEXI02 Existing Jobs
SAP Report RHXEXI03 Existing Positions
SAP Report RHXEXI04 Existing Tasks
SAP Report RHXEXI05 Existing Work Centers
SAP Report RHSTRU00 Structure Display/Maintenance
SAP Report RHINFAW0) Reporting on an Infotype
SAP Report RHPNPSUB) Starting an HR Report

Infotype Audit Logs
to track master data changes to Infotypes

RPUAUD00 track (PA) master data infotype changes/Infotype audit log
RHCDOC_DISPLAY (PD) Infotypes audit log configure it in table T77CDOC_CUST

OTHER HR Utility Reports
RPLMUT00 List of Maternity Data
RPLICO10 Flexible Employee Data
RPPSTM00 HR Master Data Sheet
RPLREF00 Reference Personnel Numbers
RPLTRF10 Defaults for Pay Scale Reclassifications
RPLTRF00 Time Spent in Pay Scale Group/Level
RPLTEL00 Telephone Directory
RPSTRF00 Assignment to Wage Level/list of the pay scale classification of employees.

RSUSR006 List users last login

SAP HR MASS DATA CHANGES/MASS DATA DELETION Utilities/Reports

RPUP1D00/10 View/Delete data from PCL1 Cluster
RPUP2D00/10 View/Delete data from PCL2 Cluster
RPUP3D00/10 View/Delete data from PCL3 Cluster
RPUP4D00/10 View/Delete data from PCL4 Cluster

RHGRENZ0 Delimit Objects
RHGRENZ1 Set New End Date
RHGRENZ2 Delimit Infotypes
RHGRENZ4 Set New End Date


RPUDELPN Delete all info for an employee number, including cluster data and infotypes

RPCDELM1 Deletion of temporary data occured during the payroll run
RPUAUDDL HR Report to delete audit data from the PCL4 Audit Cluster.
RPUDEL20 Delete Payroll results

RPTIME00 and RPTQTA00

RPTIME00 and RPTQTA00 are used in Time Management module to generate absence quotas. These absence quotas are stored in infotype IT2006.

RPTIME00

For Running Time evalaution, Time and Attendance Accrual.

is used for +Ve and -Ve Time both

RPTQTA
Specifically for Quota balance creation


With RPTIME00 we can see the entire log. But we could not see the log with RPTQTA00

Examples:

  • Accrued absence quotas are one which needs to be credited to employee account, say if he completes six months from his date of joining and this is achieved by running RPTIME00 using PT60 transaction.
  • Advance absence quotas are one which gets credited to employee account on his first date of joining and these are generated through RPTQTA00 program.

Settings to be maintained in IMG: Table: V_556A_B

  • Increase should be maintained for RPTIME00
  • No generation should be maintained for RPTQTA00

In addition to generation of absence quotas, RPTIME00 also generates Time wage types, Time balances etc.  

Report RHINTECHECK

Many are familiar with Integration Reports between PA – OM/PD such as below

  • RHINTE00 – Transfer PA Records To PD Positions. In another world, it creates the HRP1001 between P to S in the OM side of the world. When you view a record via IT0001, you see this person holds the position, however via HRP1001, that relationship isn’t so.
  • RHINTE10 – Generates the required relevant tables. (T513 – Jobs, T513S – Jobs, T528B – Positions, T528T – Work Center, T527X – Org Unit
  • RHINTE20 – checks for all objects for integration between PA and OM. This is a big one and will take awhile to run. What it does is look at table T513/T513T – Jobs, T528/T528T – Position, and T528X – Org Unit. It will then compare it against the HRPxxxx table to find missing objects. If there are any missing objects, it will create the record.
  • RHINTE30 – Transfer OM to PA. This will create infotype 0001. If the conversion strategy is to have SAP auto inherit factor to kick in for IT0001, often time jobs and org unit are missing via IT0001 during the inital conversion load. RHINTE30 will find the relationship and push it through IT0001.
For more information on these reports for OM-PA integration, Click here
But not everyone are familiar with Report RHINTECHECK, Which is a very useful report,highly neglected.Most consider that Running Integration Reports mentioned above completes the Integration Process,but not until one runs report RHINTECHECK,which if comes out error free does actually one complete Integration Process successfully.RHINTECHECK reports checks for any inconsistancies that occur during the PA-OM integration, so it is advised to run this report after you are done running your other Integration reports.
Most likely the errors that are brought about are often solved by running either RHINTE00 or RHINTE30 report. Also the other useful report is RHCHECKV – Which Checks all inverse relationships.

Recruitment – Letters

Letters of Correspondence

Unlike Training and Events, with Recruitment you can only generate your correspondence in either Word or SAP Script. The following items should be considered:

  • If you company uses a particular font set, does it exist within SAP Script – if not it will have to be added.
  • Would you need to use the “send to” mail recipient in Word if you are going to email applicants using Outlook (which may not be integrated with SAP Office using SAP Connect)
  • Does Word provide sufficient functionality in terms of programming functions to enable you to do everything you need to. You may wish to include IF, THEN, ELSE statements etc, in your letter. SAP Script provides many whilst standard Word provides a bit less.
  • Are all the mail merge fields available in Word?

If you would like to hold more expansive details about interview venues you can do so in Word or SAP Script using a few programming commands. SAP allows you to store 6 characters for both the room and building which is great if you are all familiar with them and where they are etc. If you need to store an address for them, then that becomes a lot more difficult. You can use IF statements in both Word and SAP Script to retrieve much more expansive and descriptive texts.

Fields available for Letters

The following fields are available to be inserted into letters of correspondence

This table contains fields which can be used in letters of correspondence

Field Field Description
ADRS-ANRED Title
ADRS-NAME1 Name 1 of an address
ADRS-NAME2 Name 2 of an address
ADRS-NAME3 Name 3 of an address
ADRS-NAME4 Name 4 of an address
ADRS-STRAS House number and street
ADRS-PFACH PO box
ADRS-PSTL2 PO Box postal code
ADRS-PFORT PO Box city
ADRS-LAND1 Country key
ADRS-PSTLZ Postal code
ADRS-ORT01 City
ADRS-ORT02 City
ADRS-REGIO Region (State, Province, County)
ADRS-SPRAS Language Key
ADRS-INLND Country key
ADRS-ANZZL Number of lines in the address
ADRS-PRIOR Address lines priority
ADRS-WAREN Delivery address ID
ADRS-LINE0 Address line
ADRS-LINE1 Address line
ADRS-LINE2 Address line
ADRS-LINE3 Address line
ADRS-LINE4 Address line
ADRS-LINE5 Address line
ADRS-LINE6 Address line
ADRS-LINE7 Address line
ADRS-LINE8 Address line
ADRS-LINE9 Address line
ADRS-LINEK Address line
ADRS-LINED Address line
ADRS-LINED0 Address line
CONTR-CTART Text for contract type (Contract Elements infotype)
CONTR-PERSG Name of employee group
CONTR-PERSK Name of employee subgroup
CONTR-RETEXT Text for Work Schedule Rule (Planned Working Time Infotype)
CONTR-SZTXT Text for time recording status (IT Planned Working Time)
CONTR-WWTXT Name of Working Week (Planned Working Time Infotype)
CONTR-PREAS Text on reason for change (Basic Pay infotype)
CONTR-TARTX Name of pay scale type (Basic Pay infotype)
CONTR-TGBTX Name of pay scale area (Basic Pay infotype)
CONTR-CTRBE Contract start date (Infotype Contract Elements)
CONTR-CTREN Contract temporary until (Infotpye Contract Elements)
CONTR-WRKPL Work location (Contract Elements infotype)
CONTR-LFZFR Number of continued pay periods (IT Contract Elements)
CONTR-LFZZH Continued pay period unit (IT Contract Elements)
CONTR-KRZFR No. of sick pay supplements periods (IT Contract Elements)
CONTR-KRZZH Sick pay supplement unit (IT Contract Elements)
CONTR-PROFR Number probationary period (IT Contract Elements)
CONTR-PROEH Probationary period unit (IT Contract Elements)
CONTR-KAGFR Notice period for employer (IT Contract Elements)
CONTR-KANFR Notice period for employee (IT Contract Elements)
CONTR-ARBEN Expiration of work permit (Infotype Contract Elements)
CONTR-AZANT Employment percent (Infotype Planned Working Time)
CONTR-ASTTG Working hours per day (infotype Planned Working Time)
CONTR-ASTWK Working hours per week (Infotype Planned Working Time)
CONTR-ASTMO Working hours per month (Infotype Planned Working Time)
CONTR-ASTJA Working hours per year (Infotype Planned Working Time)
CONTR-WKWTG Weekly workdays (Infotype Planned Working Time)
CONTR-BZART Payment type (Infotype Basic Pay)
CONTR-TRFGR Pay scale group
CONTR-TRFST Pay scale level
CONTR-JAGEH Annual salary (Infotype Basic Pay)
CONTR-CURKY Currency key
CONTR-LGA01 Wage type (Infotype Basic Pay)
CONTR-LGA02 Wage type (Infotype Basic Pay)
CONTR-LGA03 Wage type (Infotype Basic Pay)
CONTR-LGA04 Wage type (Infotype Basic Pay)
CONTR-LGA05 Wage type (Infotype Basic Pay)
CONTR-LGA06 Wage type (Infotype Basic Pay)
CONTR-LGA07 Wage type (Infotype Basic Pay)
CONTR-LGA08 Wage type (Infotype Basic Pay)
CONTR-LGA09 Wage type (Infotype Basic Pay)
CONTR-BRG01 Amount (Infotype Basic Pay)
CONTR-BRG02 Amount (Infotype Basic Pay)
CONTR-BRG03 Amount (Infotype Basic Pay)
CONTR-BRG04 Amount (Infotype Basic Pay)
CONTR-BRG05 Amount (Infotype Basic Pay)
CONTR-BRG06 Amount (Infotype Basic Pay)
CONTR-BRG07 Amount (Infotype Basic Pay)
CONTR-BRG08 Amount (Infotype Basic Pay)
CONTR-BRG09 Amount (Infotype Basic Pay)
CONTR-LGTX1 Wage type long text (Infotype Basic Pay)
CONTR-LGTX2 Wage type long text (Infotype Basic Pay)
CONTR-LGTX3 Wage type long text (Infotype Basic Pay)
CONTR-LGTX4 Wage type long text (Infotype Basic Pay)
CONTR-LGTX5 Wage type long text (Infotype Basic Pay)
CONTR-LGTX6 Wage type long text (Infotype Basic Pay)
CONTR-LGTX7 Wage type long text (Infotype Basic Pay)
CONTR-LGTX8 Wage type long text (Infotype Basic Pay)
CONTR-LGTX9 Wage type long text (Infotype Basic Pay)
CONTR-LGAW1 Wage type (Infotype Recurring Payments/Deductions)
CONTR-LGAW2 Wage type (Infotype Recurring Payments/Deductions)
CONTR-LGAW3 Wage type (Infotype Recurring Payments/Deductions)
CONTR-LGTW1 Wage type long text (Infotype Recurring Payments/Deductions)
CONTR-LGTW2 Wage type long text (Infotype Recurring Payments/Deductions)
CONTR-LGTW3 Wage type long text (Infotype Recurring Payments/Deductions)
CONTR-BRGW1 Amount (Infotype Recurring Payments/Deductions)
CONTR-BRGW2 Amount (Infotype Recurring Payments/Deductions)
CONTR-BRGW3 Amount (Infotype Recurring Payments/Deductions)
CONTR-AZDW1 1st payment date (Infotype Recurring Payments/Deductions)
CONTR-AZDW2 1st payment date (Infotype Recurring Payments/Deductions)
CONTR-AZDW3 1st payment date (Infotype Recurring Payments/Deductions)
CONTR-DZANZ1 Interval between payment dates (IT Recurring Pymts/Deduction
CONTR-DZANZ2 Interval between payment dates (IT Recurring Pymts/Deduction
CONTR-DZANZ3 Interval between payment dates (IT Recurring Pymts/Deduction
CONTR-WBEH1 Unit (Infotype Recurring Payments/Deductions)
CONTR-WBEH2 Unit (Infotype Recurring Payments/Deductions)
CONTR-WBEH3 Unit (Infotype Recurring Payments/Deductions)
CONTR-EHZP1 Payment date unit (IT Recurring Payments/Deductions)
CONTR-EHZP2 Payment date unit (IT Recurring Payments/Deductions)
CONTR-EHZP3 Payment date unit (IT Recurring Payments/Deductions)
CONTR-ANZW1 Number (Infotype Recurring Payments/Deductions)
CONTR-ANZW2 Number (Infotype Recurring Payments/Deductions)
CONTR-ANZW3 Number (Infotype Recurring Payments/Deductions)
CONTR-LGAE1 Wage type (Infotype Additional Payments)
CONTR-LGAE2 Wage type (Infotype Additional Payments)
CONTR-LGAE3 Wage type (Infotype Additional Payments)
CONTR-LGTE1 Wage type long text (Infotype Additional Payments)
CONTR-LGTE2 Wage type long text (Infotype Additional Payments)
CONTR-LGTE3 Wage type long text (Infotype Additional Payments)
CONTR-BRGE1 Amount (Infotype Additional Payments)
CONTR-BRGE2 Amount (Infotype Additional Payments)
CONTR-BRGE3 Amount (Infotype Additional Payments)
CONTR-ANZE1 Number (Infotype Additional Payments)
CONTR-ANZE2 Number (Infotype Additional Payments)
CONTR-ANZE3 Number (Infotype Additional Payments)
CONTR-EZEH1 Unit (Infotype Additional Payments)
CONTR-EZEH2 Unit (Infotype Additional Payments)
CONTR-EZEH3 Unit (Infotype Additional Payments)
CONTR-EDAT1 Date of origin (Infotype Additional Payments)
CONTR-EDAT2 Date of origin (Infotype Additional Payments)
CONTR-EDAT3 Date of origin (Infotype Additional Payments)
MEMOACT-INDIC Indicator: Completed/planned
MEMOACT-ACTID Identification number for applicant activity
MEMOACT-APACT Applicant activity type
MEMOACT-DATUM Last changed on
MEMOACT-UZEIT Time
MEMOACT-UNAME User name
MEMOACT-OTYPE Object type (vacancy)
MEMOACT-OBJID Vacancy
MEMOACT-REFID Reference activity ID
MEMOACT-IDTXT Standard text
MEMOACT-RECTK Status of recurring task: Print letter
MEMOACT-PERNR Personnel Number
MEMOACT-PLDAT Date of action
MEMOACT-PLTIM Time of action
MEMOACT-LETEX Indicator: Letter saved
MEMOACT-NOTEX Indicator for notes
MEMOACT-LEMOD Indicator: Letter changed
MEMOACT-REMEM Date of last time mail sent
MEMOACT-GEBNR Building number for action
MEMOACT-ZIMNR Room number for action
MEMOACT-RCTK2 Send mail
MEMOACT-RCTK3 Format of letter for action
MEMOACT-RCTK4 Format of note on action
MEMOACT-ENAME Formatted name of employee or applicant
MEMOACT-LANGT Day of action
MEMOACT-WWDAT Date of action
MEMOACT-WWTIM Time of action
PTXT1-TIME1 Time of reference action
PTXT1-NRES1 Person responsible for activity
PTXT1-NRES2 Person responsible for vacancy
PTXT1-NRES3 Person responsible for reference activity
PTXT1-NCLE1 Personnel officer from infotype 0001 (Org.Assignment)
PTXT1-NCLE2 Personnel officer for unsolicited application group
PTXT1-NCLE3 Personnel officer for action vacancy
PTXT1-SIGN1 Signature of person responsible for vacancy
PTXT1-SIGN2 Signature of person responsible for reference action
PTXT1-SIGN Signature of pers.off. from Org.Assignment (infotype 0001)
PTXT1-SIGN4 Signature of pers.officer for unsolicited application group
PTXT1-SIGN5 Signature of personnel officer for action vacancy
PTXT1-SIGN6 Signature of person responsible for action
PTXT1-SALUT Attribute for form of address (e.g. Dear)
PTXT1-TEL00 Pers.officer’s tel.no. from infotype 0001, Org.Assignment
PTXT1-TEL01 Tel.no. of pers.officer for unsolicited application group
PTXT1-TEL02 Tel.no. of pers.off. for action vacancy
PTXT1-GEBNR Building number for reference action
PTXT1-GEBNR Building number for reference action
PTXT1-ZIMNR Room number for reference action
PTXT1-ANRED Form of address (e.g. Mr/Mrs/Ms)
PTXT1-NACHN Last name
PTXT1-VORNA First name
PTXT1-ENAME Formatted name (e.g. Dr Jones)
PTXT1-BEGDA Date of receipt of application
PTXT1-PERNR Applicant number
PTXT1-PLSTX Name of position
PTXT1-DATUM Date and time, current (application server) date
PTXT1-WWBEGDA Date of receipt of application
PTXT1-TODAY System: Current date
PTXT1-ASHTX Short text for applicant activity type
PTXT1-ACTTX Long text for applicant activity type
RFACT-INDIC Indicator: Completed/planned
RFACT-ACTID Identification number for applicant activity
RFACT-APACT Applicant activity type
RFACT-DATUM Last changed on
RFACT-UZEIT Time
RFACT-UNAME User name
RFACT-OTYPE Object type (vacancy)
RFACT-OBJID Vacancy
RFACT-REFID Reference activity ID
RFACT-IDTXT Standard text
RFACT-RECTK Status of recurring task: Print letter
RFACT-PERNR Personnel Number
RFACT-PLDAT Date of reference action
RFACT-PLTIM Time of reference action
RFACT-LETEX Indicator: Letter saved
RFACT-NOTEX Indicator for notes
RFACT-LEMOD Indicator: Letter changed
RFACT-REMEM Date of last time mail sent
RFACT-REMEM Date of last time mail sent
RFACT-GEBNR Building number for reference action
RFACT-ZIMNR Room number for reference action
RFACT-RCTK2 Send mail
RFACT-RCTK3 Format of letter for action
RFACT-RCTK4 Format of note on action
RFACT-ENAME Formatted name of employee or applicant
RFACT-LANGT Day of reference action
RFACT-WWDAT Date of reference action
RFACT-WWTIM Time of reference action

SAP HR Reports

SAP HR Reports

For list of HR reports by Module Click here

Using Mail Merge

If you would like to use mail merge with results obtained from SAP, you can do so after having run a report in SAP.

  • Once you have the results on the screen, choose the download –> Word Processor option.
  • A dialogue will then prompt you to enter certain choices. Choose the form processing option.
  • Choose new Word document or existing Word document if you have one already set up.
  • Change the password option to “No password” unless of course you really do wish to have a password set.
  • Word should then be opened up and the data source transferred to Word. Enter your text for the letter and insert the mail merge fields from the drop-down button on the top left hand side.
  • Click on the <> button to toggle between the data fields and the actual data.

You can now print or email off the results of the mail merge.

Key Reports within SAP HR

This table contains commonly used SAP HR Reports

Report Name Report Description
RDDKOR54 Customer naming conventions for SAP tables etc
RPCDTFG0 Data Medium Exchange: Cancelling Transfers
RFBVALL_0 Loads bank sort codes, branches etc
RHBEGDA0 The report sets a new start date for the records found using the selection screen. It primarily serves to correct the start date of records retrospectively. To access the correct selection of records, enter the old start date. All records with the old start date are given the new start date. All other records remain unchanged.
RHINTE00 Transfer Org Assignment from PA to PD
RHINTE10 Prepare Integration (OM with PA)
RHINTE20 Check program for PA-OM Integration
RHINTE30 Creates batch input session for IT 0001 – using PD relationships.
RHMARP00 Returns the material requirements per business event
RHMOVE00 Outputs a sequential file – PD_DATASET
RHMOVE30 Used to manually transport objects in Org Mgt
RHMOVE40 Display and edit sequential PD Dataset
RHSTRU00 useful report for displaying all related objects in a structure (hierarchy) according to the defined evaluation path. Can be used for any PD object in any database HRPnnnn.
RPCDTFG0 DME – cancelling transfers
RPCGTNG0 New Gross to Net Control Report for the UK
RPCSC000 Payroll batch scheduler for breaking up the payroll run into jobs allowing payroll to be processsed in parallel as a number of batches
RPDASC00 Explodes the whole schema – ctrl+F to find items. For PCR’s and sub-schemas use 0000 to zzzz as the “from” and “to” values.
RPDKON00 Assignment of wage types to G/L accounts (chart of accounts)
RPDLGA00 Wage type statement – shows the permissibility of wage types.
RPDLGA20 Use of wage types in payroll accounting – very useful. Shows the inner workings of how all the wage types are passed through the PCR’s and what processing classes are accessed. Enter your country version. I always find it easier to us the “tree” option rather than the “table” option.
RPDLGA40 Similar to RPDLGA20. Gives each wage type and shows each PC, EC and CC for each.
RPDSYS00 Takes you to all the documentation in the SAP system
RPIBRT00 Evaluation of Appraisals – creates a batch session to update IT 0008 based on the employees IT 0025 record.
RPIBRT01 Group value of Appraisal criterion
RPINCL10 Search for specific text in any report
RPLEAT00 Starters and Leavers Report
RPLINFC0 Infotype overview for an employee – very useful and much better than using the Personnel File on PA10. Shows all the infotypes for an employee.
RPLNHRU0 New Hire Report
RPLNICG0 Displays NI and CNIC values from the payroll results
RPPCUPG0 Batch update for infotype 0071 – pensions GB
RPSDEV00 Headcount report – quite good. Gives EE numbers per organisation entity
RPSEEOU1 Equal Employment Opportunities – US driven report for statutory legislation
RPTIME00 Time Evaluation
RPTKOK00 Used to identify inconsistencies with absence quotas
RPTBPC10 Used to correct inconsistencies – takes ages to run – rather correct them manually
RPTQTA00 Used to generate absence quotas
RPU12W0S Saves backup and allows you to restore T512W from a previously saved copy
RPU51000 Updates the values in table T510 – pay scale data
RPUAUD00 Logged Changes in Infotype Data
RPUAUDDL Deletes documents from the database that were created
RPUAUDW0 Allows you to view the records created from the above reports – have to have table T585A maintained as well
RPUCC000 Check PCRs – allows you to run checks on PCR’s
RPUCCCQ0 Check Personnel Calculation Rules
RPUCCCX0 Check Personnel Calculation Rules (International Version)
RPUCCOSE Allows you to search for text in any PCR
RPUCTC00 Lists PCR’s for any ESG and the associated processing steps
RPUCTE00 Environment Analyzer: Functions, Operations, Schemas, PCRs
RPUCTER3 Environment Analyzer: Functions, Operations, Schemas, PCRs
RPUCTF00 Change attributes for schemas and PCR’s (especially if you have executed the IMG step by mistake)
RPUCTI00 Lists subschemas not called up in any other schema
RPUCTJ00 Lists PCR’s not called up in the schemas or PCR’s
RPUCTP00 Generation of payroll periods
RPUCTP10 Generates calendars
RPUCTP20 Generate further date specifications
RPUCTX00 Copy PCR’s from client 000 to other clients on the same server
RPUDEL20 Delete payroll results. After deletion you must perform at least one retroactive accounting run for the earliest deleted payroll run
RPUDELPN Allows you to delete personnel numbers as a batch
RPUDIR00 Restores the payroll results directory
RPUDNIG0 Update table T5G_DTONI. Format can be a pain to get right. Rather maintain the table directly or cut and paste from Excel. Another alternative is to use a CATT procedure or LSMW to update the table.
RPUDPSM0 Download source text of a program (type “PROG” in TADIR)
RPUDRQQ0 Payroll Results (RQ) – originals and differences from retro periods
RPUDTEM0 Downloads table entries
RPUDTSM0 Downloads table structures
RPUGCC00 Generates calculation rule check
RPUMKD00 Features Directory – lists all available features
RPUMKG00 Generates features
RPUMKS00 Feature structure
RPUPROTD Log of report starts
RPUPROTU Maintain log
RPUPRRM0 Pension report
RPUREP00 Submit country-specific report in the info system
RPUSCC00 Compare schemas
RPUSCD00 Schema directory
RPUSCD10 Schema directory
RPUSCG00 Generate/check schemas
RPUSCGT0 Generate/check schemas
RPUSTD00 Used to transfer master data
RPUTAXU0 Delete/insert tax table entries
RPUTCUG0 HR-GB: Batch Input: Tax code uplift
RPUTMSE0 TemSe files display
RPUTMSG0 HR-GB: TemSe view and download program
RPUTMSI0 Program for TEMSE catalog display
RPUTRBK0 Update any field on IT 0003 – payroll status
RPUTSD00 Download a TemSe object to presentation server
RPUTSV00 List of HR TemSe objects
RPUTSVDD Download from data medium to Disk
RPUTTUU0 Wage type update program
RPUTXT00 Comparison of text elements
RPUWGTX0 Used to create/delete new wage types
RSAQR3TR Transports queries, user groups & functional areas
RSCLCCOP Offers slightly more functionality than the transaction SSC1. You can run jobs in background mode – using SCC1 for a really big transport causes the system to time-out after a certain period
RSCMPADJ View / table comparison
RSTXTRAN Allows you to transport SAP Scripts – eg letters in Recruitment
RSUSR006 List users last login