rt table

[Former Member]

how to fetch data from RT (result table) in hr, where does it data get stored?

like i want to fetch net pay,which table i shud refer for this.

[Former Member]

Hello Dakshu,

PC00_M40_CLSTR

PC_payresult...

To view the RT data ... you have to double click on the

month...

then...

RT	Results Table

The payroll data for that particular month gets displayed

[Former Member]

Hi Aksh.

Use PNPCE LDB.

START-OF-SELECTION.

GET peras.

rp_provide_from_last p0001 space pn-endda pn-endda.

*For Getting Relid you use this function Module.

CALL FUNCTION 'PYXX_GET_RELID_FROM_PERNR'

EXPORTING

employee = wa_info-pernr

IMPORTING

relid = relid

molga = molga

• EXCEPTIONS

• ERROR_READING_INFOTYPE_0001 = 1

• ERROR_READING_MOLGA = 2

• ERROR_READING_RELID = 3

• OTHERS = 4

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

*For Reading RGDIR Structure You Use Below Function MOdule

CALL FUNCTION 'CU_READ_RGDIR'

EXPORTING

persnr = wa_info-pernr

• BUFFER =

• NO_AUTHORITY_CHECK = ' '

IMPORTING

molga = molga

TABLES

in_rgdir = t_rgdir

EXCEPTIONS

no_record_found = 1

OTHERS = 2

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

*Read Particular Record From Rgdir Stucture

READ TABLE t_rgdir INTO wa_rgdir WITH KEY

*For Reading Payroll cluster Ucan USe the Below One.

CALL FUNCTION 'PYXX_READ_PAYROLL_RESULT'

EXPORTING

clusterid = relid

employeenumber = wa_info-pernr

sequencenumber = wa_rgdir-seqnr

• READ_ONLY_BUFFER = ' '

• READ_ONLY_INTERNATIONAL = ' '

• ARC_GROUP = ' '

• CHECK_READ_AUTHORITY = 'X'

• FILTER_CUMULATIONS = 'X'

• CLIENT =

• IMPORTING

• VERSION_NUMBER_PAYVN =

• VERSION_NUMBER_PCL2 =

CHANGING

payroll_result = t_payresult

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

error_reading_archive = 8

error_reading_relid = 9

OTHERS = 10

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

*Count No.of Entries.

DESCRIBE TABLE t_payresult-inter-rt

LINES lines_a.

*for reading RT Table and Corresponding Wage type use *as shown Below.

DO count TIMES.

READ TABLE t_payresult-inter-rt INTO wa_rt INDEX sy-index.

*Add your Code

End do

Thanks & Regards,

Shiva vs.

[Former Member]

aksh,

U can view RT table values in PC00_M40_CLSTR...

U can fetch this way,

Use LDB...PNP.

START-OF-SELECTION.

GET PERNR.

• IMPORT ALL CLUSTER RESULTS.

CLEAR RGDIR.

CD-KEY-PERNR = PERNR-PERNR.

RP-IMP-C2-CU.

SORT RGDIR BY FPPER DESCENDING.

LOOP AT RGDIR WHERE FPBEG EQ PN-BEGDA AND FPEND EQ PN-ENDDA.

RX-KEY-SEQNO = RGDIR-SEQNR.

RX-KEY-PERNR = PERNR-PERNR.

RP-IMP-C2-IN.

LOOP AT RT.

ENDLOOP.

END-OF-SELECTION.

[Former Member]

Data will be stored in Cluster table

you can get this value using function module

PYxx_Read_Payroll_result

Best Regards