‎2007 Dec 06 2:38 PM
Hi people,
I have created a ztable. and now in that i want the field to execute and find out values for the range of values. ie if there is pernr i want to select only those values which lies within the range im selecting.
‎2007 Dec 06 2:40 PM
select * from <<ztable>> into table <<itab>>
where pernr IN r_pernr.
r_pernr is your RANGES.
‎2007 Dec 06 2:41 PM
You can use SE16 for that. Just put the range which you want on the selection screen of the table and you will get all the entries corresponding to that only.
Regards,
Naimesh Patel
‎2007 Dec 06 4:13 PM
hi,
If you want to find that range thru SE16n tcode give the lower range left side and higher range on right side and execute you will get contents.
Or If want to retrieve the data from program means you can give select stmt like
tables:ztable.
select-options:s_pernr like ztable-pernr.
data:begin of it_ztable occurs 0,
pernr like ztable-pernr,
end of it_ztable.
clear it_ztable.
select pernr from ztable into table it_ztable where pernr in s_pernr.
loop at it_ztable.
write:/ it_ztable-pernr.
endloop.
Please reward if useful
Thanks
Sivaparvathi