topic Re: slect statement. in Application Development and Automation Discussions

slect statement.

Former Member — Mon, 27 Apr 2009 12:17:59 GMT

hi experts,

i have one problem, i.e i select data from bseg through select BELNR GJAHR SHKZG DMBTR

HKONT from bseg. here i want condition where hkont = '3701120010' or hkont = 'starting with some series number ' just like hkont = '3000' after 3000 any number is comeing, for example first 3000103040 or 3000607090 for this requirement how select data from bseg table.

thanks,

Dasaradh

Thread locked for Postings, because of your vague subject line

Edited by: Vijay Babu Dudla on Apr 27, 2009 8:31 AM

Re: slect statement.

Former Member — Mon, 27 Apr 2009 12:21:52 GMT

Hi,

Use HKONT LIKE '3000%'...

Issa

Re: slect statement.

Former Member — Mon, 27 Apr 2009 12:26:18 GMT

you can first fetch data into itab than loop at itab and remove entries from itab.

loop at itab into wa.

if wa-hknot+0(4) ne '3000' or wa-hknot ne '3701120010'.

delete from itab.

endif.

endloop.