Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding HR data retrival

Former Member
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

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