Skip to Content
avatar image
Former Member

rt table

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 01, 2008 at 11:41 AM

    Data will be stored in Cluster table

    you can get this value using function module

    PYxx_Read_Payroll_result

    Best Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 01, 2008 at 11:52 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 01, 2008 at 12:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 06:24 AM

    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




    Add comment
    10|10000 characters needed characters exceeded