Fetch PERNR with Future BEGDA

[Former Member]

Hi Gurus,

My requirement is to fetch the PERNR using GET PERNR, but when i fetching the records for current date

Eg : PERNR BEGDA AEDTM

[Former Member]

Hi,

Your Que? is not clear.

[Former Member]

Hi Gurus,

My requirement is to fetch the records of employees, I am using GET PERNR, but when i fetching the records for current date

Eg : PERNR BEGDA AEDTM

1000 25.05.2009 26.05.2009

1001 01.07.2009 26.05.2009

GET PERNR is fetching only one record(PERNR = 1000)

Please let me know how to pick the other record as well(There BEGDA is in Future date)

Thanks&Regards,

Mohamed

[Former Member]

Hi ,

in your report program in the Attributes Tab provide the Logical Database as PNP and do the following

*& Tables declaration
TABLES: PERNR.

*& Infotypes declaration
INFOTYPES: 0001,                       " Org Assignment
           0002,                       " Personel Data
           0006,                       " Addresses
           0003 MODE A.                " Payroll status

*& START-OF-SELECTION EVENT
START-OF-SELECTION.

GET PERNR.

 PROVIDE * FROM P0001
          * FROM P0002
          * FROM P0006
    BETWEEN PN-BEGDA AND PN-ENDDA.

  IF P0001_VALID EQ 'X'.
      WRITE:
        / P0001-PERNR, P0001-BEGDA, P0001-ENDDA.
    ENDIF.

now when u run the report select the date as current date.

hope this help.... try out

best of luck!!

thanks

Ravi Aswani

[Former Member]

Hi Gurus,

My requirement is to fetch the records of employees, I am using GET PERNR, but when i fetching the records for current date

Eg : PERNR BEGDA AEDTM

1000 25.05.2009 26.05.2009

1001 01.07.2009 26.05.2009

GET PERNR is fetching only one record(PERNR = 1000)

Please let me know how to pick the other record as well(There BEGDA is in Future date)

Thanks&Regards,

Mohamed

[jayanthi_jayaraman]

Hi,

If you want all the records for the pernr, don't enter any date in selection screen and then in program use provide statement if you want to use GET PERNR(Using LDB).

tables : pernr.
infotypes 0001.
start-of-selection.
get pernr.
provide pernr orgeh plans stell from p0001 between pn-begda and pn-endda.
 write : / p0001-pernr, p0001-begda, p0001-endda.
endprovide.
end-of-selection.

[Former Member]

Hi,

If you use LDB PNP then you will get all records at GET PERNR event.

If you use LDB PNPCE then you will get all records at GET PERNR event only when you select the reporting period as 'ALL'.

Regards,

Kumar Bandanadham