Regarding HR data retrival

[Former Member]

Hi,

when I am trying to retrive data from four infotypes ( 0000, 0001, 0016, 0105 ) with single provide statement & with selection screen fields( aedtm, bukrs, massn) then it is giving incorrect data.

why like this.

Its very urgent , give me reply.

Regards

Anil

[Former Member]

Hi,

when I am trying to retrive data from four infotypes ( 0000, 0001, 0016, 0105 ) with single provide statement & with selection screen fields( aedtm, bukrs, massn) then it is giving incorrect data.

why like this.

Its very urgent , give me reply.

Regards

Anil

[Former Member]

Hi Anil,

Provide.....Endprovide is mainly used where it is needed to get different rows based on time periods sequentially. Suppose you are dealing with these 4 tables 0000, 0001, 0016, 0105 and the time periods of the records in the data base are as follows:

0000 01/01/2006 31/12/9999

0001 01/01/2006 31/12/9999

0016 01/01/2007 31/12/9999

0105 01/01/2007 31/12/9999

and you write as below:

******************************************

tables : pernr.

INFOTYPES: 0000, 0001, 0016, 0105.

Start-of-selection.

GET PERNR.

PROVIDE * FROM P0000

• from p0001

• from p0016

• from p0105 between pn-begda and pn-endda.

write:/ P0000-begda, P0000-endda.

ENDPROVIDE.

end-of-selection.

******************************************

then in the result you will get two records

01/01/2006 31/12/2006

01/01/2007 31/12/9999

you can accordingly analyse your query and result, you can know why it is displaying like that.

Else you can send us the query that you have written and the database records and what result you are getting.

Regards

Purna Chandra