data base table for HR data

[Former Member]

hi

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

[Former Member]

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]

Hi Smitha,

You can check the table -

UBEKL  - - Salary Classes for Non-Academic Employees

Regards

Pinaki

[GauthamV]

Table : PA0008.

[Former Member]

hi

thans for ur reply

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

[GauthamV]

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.