Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

data base table for HR data

former_member342013
Contributor
0 Kudos

hi

in which table i wil get the salary details of all Employees

5 REPLIES 5

Former Member
0 Kudos

Hello Smitha KB

Salary of employee you will not get from any database table . As we have to retrieve from various cluster table.

Try this program : EXAMPLE_PNP_GET_PAYROLL

It will really help for you! As I have also made the the same program!

Hope it would help you more!

Former Member
0 Kudos

Hi Smitha,

You can check the table -

UBEKL  - - Salary Classes for Non-Academic Employees

Regards

Pinaki

GauthamV
Active Contributor
0 Kudos

Table : PA0008.

0 Kudos

hi

thans for ur reply

is there any function module to get the current salary by passing my personnel number?

GauthamV
Active Contributor
0 Kudos

This Fm will give you all wage type details of employee.

RP_FILL_WAGE_TYPE_TABLE_EXT



DATA: BEGIN OF PPBWLA OCCURS 20.
        INCLUDE STRUCTURE PBWLA.
DATA:   END OF PPBWLA.

 CALL FUNCTION 'RP_FILL_WAGE_TYPE_TABLE_EXT'
        EXPORTING
          PERNR                        = final_table-PERNR
          INFTY                        = '0008'
          SUBTY                        = T_0008-SUBTY
          OBJPS                        = T_0008-OBJPS
          BEGDA                        = T_0008-BEGDA
          ENDDA                        = T_0008-ENDDA
          DLSPL                        = ' '
        TABLES
          PPBWLA                       = PPBWLA
          PP0001                       = P0001
          PP0007                       = P0007
          PP0008                       = P0008
          PP0230                       = P0230
        EXCEPTIONS
          ERROR_AT_INDIRECT_EVALUATION = 1.

Also you can try BAPI_WAGETYPE_EMPLOYEEGETLIST FM.