09-11-2008 11:46 AM
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.
09-11-2008 12:02 PM
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
09-11-2008 12:02 PM
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
09-11-2008 12:12 PM
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