FM not fetching all the CRT records

[Former Member]

Hi,

     I am using PYXX_READ_PAYROLL_RESULTS FM for fetching the CRT records.

     There are more than 430 records for a period, but while fetching the records from the FM i am getting only 196 records.

     I have tried above FM, HRCM_PAYROLL_RESULTS_GET and

     macro :

       rp-init-buffer.
       cd-key-pernr = pernr.
       rp-imp-c2-cu.

       rx-key-pernr = pernr.
       unpack rgdir-seqnr to rx-key-seqno.
       rp-imp-c2-ru.

     All the methods are fetching same output of 196 records

     Please help me in fetching all the records.

Thanks,

Laxmikanth

[JonathanM]

Hi Laxmikanth,

You should try something like:

rp-init-buffer. "reset buffer
 cd-key-pernr = PERAS-PERNR.
 RP-IMP-C2-CD.
 
 LOOP AT rgdir WHERE srtza EQ 'A'.  " only on active periods
     rx-key-pernr = PERAS-PERNR.
      rx-key-seqno = rgdir-seqnr.
      rp-imp-c2-ru. " import to buffer 
      CHECK rp-imp-ru-subrc = 0.
* Available Clusters:CRT, RT, WPBP, VERSC, ORB-VERSION
           LOOP AT crt WHERE LGART in S_LGART.
           MOVE-CORRESPONDING CRT to WA_DATA.
           APPEND WA_DATA TO IT_DATA.
           ENDLOOP.
      ENDLOOP.

Best regards,

Jonathan

[Former Member]

Hi Jonathan,

     I have tried your method it fetching the same 196 records.

Thanks,

Laxmikanth

[JonathanM]

Hi Laxmikanth,

You should also try to display the cluster data from transaction PC_PAYRESULT to really check what data are in the cluster on which IN/FOR periods.

Best regards,

Jonathan

[Former Member]

yeah Jonathan i have checked the results in PC_PATRESULT. There are 498 records for an IN/FOR period. when i am trying to fetch for the same it is fetching 196 records and that too upto cumulative year 2012, not beyond that.

Thanks,

Laxmikanth