Infotype 41

[Former Member]

Hi All,

In the HR Infotype 41.. in the table pa0041 we have date type fields which vary from 01 to 12. Now my requirement is i have to check for one record in which field the date type is '01'. how to check it?

Thanks in advance,

Swapna.

[Former Member]

Hi,

Fetch the data to an internal table and filter the data by using DO... VARYING while looping the internal table.

[manuel_murmann]

Is something like this possible in the SAP DWV / Datapshere? I need to get specific dates out of PA0041 and possibly sort them into a better table. I've tried everything in SQL / SQLScript but nothing seems to work

[Former Member]

sample code :

DO 12 TIMES VARYING i_dates-dar FROM p0041-dar01 NEXT p0041-dar02
            VARYING i_dates-dat FROM p0041-dat01 NEXT p0041-dat02.
    CASE i_dates-dar.
      WHEN '01'.
        IF i_dates-dat > i_start_date.
          i_start_date = i_dates-dat.
        ENDIF.
*      when '08'.
*        i_terminationdate = i_dates-dat.
      WHEN '09'.
        IF i_dates-dat > i_start_date.
          i_start_date = i_dates-dat.
        ENDIF.
      WHEN OTHERS.
    ENDCASE.
  ENDDO.

[Former Member]

Use Like that

do 40 times varying lga from p0008-lga01 next p0008-lga02

varying bet from p0008-bet01 next p0008-bet02 .

case lga.

when '1BAS'.

disp_body-bas_rate = bet.

when '1VDA'.

disp_body-vda_rate = bet.

when '1FDA'.

disp_body-fda_rate = bet.

endcase.

enddo.

Regards

rajesh