Skip to Content
Author's profile photo Suman Poddar

How to Configure Payroll Info types to Facilitate Payroll Reporting

The definition and configuration of the payroll info types provides a unique reporting solution and functional person can easily create very sophisticated HR reports using the ad hoc query tool and the HR master data can be displayed using transaction PA20.

 

Business Scenario: One report for PF details has to be developed with the help of ad hoc query.

 

Configuration Steps:

1.      Evaluation Wage Types: In this step, you define the ID and description of evaluation wage type and specify the fields that are created with this evaluation wage type when you generate a payroll info type. An evaluation wage type consists of one or more wage types. It is used to define accounting info types.

 

Node: Personnel Management->Human Resource Information System->Payroll Results->Define Evaluation Wage Types (T52IC)

image

 

Creating the following Evaluation Wage Types:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Eval Wage Type

 

 

Cuml type

 

 

Amount

 

 

Number

 

 

Description

 

 

EV_EEPF           

 

 

M

 

 

X   

 

 

 

Ee PF contribution

 

 

EV_EEPF_Q     

 

 

Q

 

 

X   

 

 

 

 

 

Ee PF contri Quaterly

 

 

EV_EEPF_Y      

 

 

Y

 

 

X   

 

 

 

 

 

Ee PF contri Annual

 

 

EV_EEVPF        

 

 

M

 

 

X   

 

 

 

 

 

Ee VPF contribution

 

 

EV_EEVPF_Q   

 

 

Q

 

 

X   

 

 

 

 

 

Ee VPF contri Quaterly

 

 

EV_EEVPF_Y    

 

 

Y

 

 

X   

 

 

 

 

 

Ee VPF contri Annual

 

 

EV_ERPF           

 

 

M

 

 

X   

 

 

 

 

 

Er PF contribution

 

 

EV_ERPF_Q

 

 

Q

 

 

X   

 

 

 

 

 

Er PF contri Quaterly

 

 

EV_ERPF_Y

 

 

Y

 

 

X   

 

 

 

 

 

Er PF contri Annual

 

 

EV_ERPEN        

 

 

M

 

 

X   

 

 

 

 

 

Er Pension contribution

 

 

EV_ERPEN_Q   

 

 

Q

 

 

X   

 

 

 

 

 

Er Pension contri Quaterl

 

 

EV_ERPEN_Y    

 

 

Y

 

 

X   

 

 

 

 

 

Er Pension contri Annual

 

 

EV_EEPFB        

 

 

M

 

 

X   

 

 

 

 

 

PF basis for Ee contrib

 

 

EV_EEPFB_Q   

 

 

Q

 

 

X   

 

 

 

 

 

PF basis for Ee contrib Q

 

 

EV_EEPFB_Y     

 

 

Y

 

 

X   

 

 

 

 

 

PF basis for Ee contrib A

 

 

EV_ERPFB         

 

 

M

 

 

X   

 

 

 

 

 

PF basis for Er contrib

 

 

EV_ERPF_Q

 

 

Q

 

 

X   

 

 

 

 

 

Er PF contri Quaterly

 

 

EV_ERPF_Y

 

 

Y

 

 

X   

 

 

 

 

 

Er PF contri Annual

 

image

 

2.      Assign Wage Types: In this step you assign evaluation wage types to one or more wage types

from the payroll results (cluster table RT for periodic wage types and cluster table CRT for cumulation wage types).

 

Node: Personnel Management->Human Resource Information System->Payroll Results-> Assign Wage Types (T52IE)

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Eval Wage Type

 

 

Cuml type

 

 

Wage Type

 

 

Negative

 

 

EV_EEPF           

 

 

M

 

 

/3F1

 

 

 

 

 

EV_EEPF_Q     

 

 

Q

 

 

/3F1

 

 

 

 

 

EV_EEPF_Y      

 

 

Y

 

 

/3F1

 

 

 

 

 

EV_EEVPF        

 

 

M

 

 

/3F2

 

 

 

 

 

EV_EEVPF_Q   

 

 

Q

 

 

/3F2

 

 

 

 

 

EV_EEVPF_Y    

 

 

Y

 

 

/3F2

 

 

 

 

 

EV_ERPF           

 

 

M

 

 

/3F3

 

 

 

 

 

EV_ERPF_Q

 

 

Q

 

 

/3F3

 

 

 

 

 

EV_ERPF_Y

 

 

Y

 

 

/3F3

 

 

 

 

 

EV_ERPEN        

 

 

M

 

 

/3F4

 

 

 

 

 

EV_ERPEN_Q   

 

 

Q

 

 

/3F4

 

 

 

 

 

EV_ERPEN_Y    

 

 

Y

 

 

/3F4

 

 

 

 

 

EV_EEPFB        

 

 

M

 

 

/3FA

 

 

 

 

 

EV_EEPFB_Q   

 

 

Q

 

 

/3FA

 

 

 

 

 

EV_EEPFB_Y     

 

 

Y

 

 

/3FA

 

 

 

 

 

EV_ERPFB         

 

 

M

 

 

/3FB

 

 

 

 

 

EV_ERPF_Q

 

 

Q

 

 

/3FB

 

 

 

 

 

EV_ERPF_Y

 

 

Y

 

 

/3FB

 

 

 

 

image

 

3.      Set Up Payroll Info types: In this step,you define and generate the required payroll info types. When payroll infotypes are generated, the entries for the structure are made in the database,and the info type-specific screens 2000 and 3000 are created, along with the evaluation wage type fields. To be able to use the info type after you have defined and generated it, the status must be left on active.

 

Node: Personnel Management->Human Resource Information System->Payroll Results-> Set Up Payroll Info types

image 

Here we will develop following info types-

9402             Payroll Results

9403             Payroll Results Quarterly

9404             Payroll Results Annually

 

Copy from standard configuration for your country version with new info type 9042 and assign Evaluation Wage Types. After that Press ‘Generate payroll Info type’ button.

 

image

 

Info type 9402

image

 

Info type 9403

image

 

4.      Set Up Assignment to Payroll: In this step, you determine which payroll info types are automatically filled with data when payroll is run. If you do not fill a payroll info type automatically, you can use report RPABRI00 to fill the payroll info types with payroll data.

 

Node: Personnel Management->Human Resource Information System->Payroll Results-> Set Up Assignment to Payroll (T52IF)

image

 

Settings for automatically filling with data when payroll is running.

image

 

Testing Steps:

1.      Run Payroll: Run payroll for one employee

image

2.      Check data in PA20: Check the info types from PA20.

image

3.      Payroll data can also be updated using report RPABRI00.

4.      Now Payroll results could be extracted using ad hoc query.

 

Important Tables and Notes:

Tables

 

 

 

 

 

 

 

 

 

 

 

 

 

Tables

 

 

Description

 

 

T52IC

 

 

Define evaluation wage types

 

 

T52IE

 

 

Assign wage  types to evaluation wage types

 

 

T52IA

 

 

Payroll info types overview

 

 

T52IB

 

 

Assign  evaluation wage types to payroll info types

 

 

T52IF

 

 

Set up assignment to payroll

 

Notes

 

 

 

 

 

 

 

 

 

Notes

 

 

Description

 

 

523221

 

 

Problems with payroll info types (402, 403, etc.)

 

 

125921

 

 

Problems when filling the payroll info type

 

 

541127

 

 

Improvements on RPABRI00 and its function modules

 

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Keabetswe Moerane
      Keabetswe Moerane

      Very helpful!