topic Re: regarding the data dictionary. in Application Development and Automation Discussions

regarding the data dictionary.

Former Member — Thu, 06 Dec 2007 14:38:55 GMT

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.

Re: regarding the data dictionary.

Former Member — Thu, 06 Dec 2007 14:40:31 GMT

select * from <<ztable>> into table <<itab>>
where pernr IN r_pernr.

r_pernr is your RANGES.

Re: regarding the data dictionary.

naimesh_patel — Thu, 06 Dec 2007 14:41:14 GMT

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

Re: regarding the data dictionary.

Former Member — Thu, 06 Dec 2007 16:13:44 GMT

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