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: 

HR payroll

Former Member
0 Kudos

Hi,

i have a requirement that i have to retrieve data from payroll- RT table in enhancements with out using LDB'.

can any one help me regarding this.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hello,

To get data of result table from payroll there function module.pls check below coding and use below function module accordingly,u will get data of RT,CRT etc.

      • Processing for getting the salary

    • Read the Payroll Directory.

CALL FUNCTION 'CD_READ_RGDIR'

EXPORTING

persnr = ppernr

TABLES

in_rgdir = it_rgdir

EXCEPTIONS

no_record_found = 1

OTHERS = 2.

LOOP AT it_rgdir

WHERE void IS initial

AND ipend >= vmth_fr

AND ipend <= vmth_to

AND fpend >= vformth_fr

AND fpend <= vformth_to.

wa_rgdir = it_rgdir.

      • Read the current month Salary

  • PERFORM get_current_sal_for_seqno using ppernr.

CALL FUNCTION 'PYXX_READ_PAYROLL_RESULT'

EXPORTING

clusterid = 'IN'

employeenumber = ppernr

sequencenumber = wa_rgdir-seqnr

  • READ_ONLY_INTERNATIONAL = ' '

CHANGING

payroll_result = it_result

EXCEPTIONS

illegal_isocode_or_clusterid = 1

error_generating_import = 2

import_mismatch_error = 3

subpool_dir_full = 4

no_read_authority = 5

no_record_found = 6

versions_do_not_match = 7

OTHERS = 8.

regards,

vishal

2 REPLIES 2

Former Member
0 Kudos

Hello,

To get data of result table from payroll there function module.pls check below coding and use below function module accordingly,u will get data of RT,CRT etc.

      • Processing for getting the salary

    • Read the Payroll Directory.

CALL FUNCTION 'CD_READ_RGDIR'

EXPORTING

persnr = ppernr

TABLES

in_rgdir = it_rgdir

EXCEPTIONS

no_record_found = 1

OTHERS = 2.

LOOP AT it_rgdir

WHERE void IS initial

AND ipend >= vmth_fr

AND ipend <= vmth_to

AND fpend >= vformth_fr

AND fpend <= vformth_to.

wa_rgdir = it_rgdir.

      • Read the current month Salary

  • PERFORM get_current_sal_for_seqno using ppernr.

CALL FUNCTION 'PYXX_READ_PAYROLL_RESULT'

EXPORTING

clusterid = 'IN'

employeenumber = ppernr

sequencenumber = wa_rgdir-seqnr

  • READ_ONLY_INTERNATIONAL = ' '

CHANGING

payroll_result = it_result

EXCEPTIONS

illegal_isocode_or_clusterid = 1

error_generating_import = 2

import_mismatch_error = 3

subpool_dir_full = 4

no_read_authority = 5

no_record_found = 6

versions_do_not_match = 7

OTHERS = 8.

regards,

vishal

Former Member
0 Kudos

Hi,

Read the data from payroll clusters we are using Function modules and you will get data from RT and CRT ........

Processing for getting the salary Read the Payroll Directory.

CALL FUNCTION 'CD_READ_RGDIR'

EXPORTING

persnr = ppernr

TABLES

in_rgdir = it_rgdir

EXCEPTIONS

no_record_found = 1

OTHERS = 2.

LOOP AT it_rgdir

WHERE void IS initial

AND ipend >= vmth_fr

AND ipend <= vmth_to

AND fpend >= vformth_fr

AND fpend <= vformth_to.

wa_rgdir = it_rgdir.

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Read the current month Salary

PERFORM get_current_sal_for_seqno using ppernr.

CALL FUNCTION 'PYXX_READ_PAYROLL_RESULT'

EXPORTING

clusterid = 'IN'

employeenumber = ppernr

sequencenumber = wa_rgdir-seqnr

READ_ONLY_INTERNATIONAL = ' '

CHANGING

payroll_result = it_result

EXCEPTIONS

illegal_isocode_or_clusterid = 1

error_generating_import = 2

import_mismatch_error = 3

subpool_dir_full = 4

no_read_authority = 5

no_record_found = 6

versions_do_not_match = 7

OTHERS = 8.

Thanks&Regards,

Naresh