slect statement.

[Former Member]

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

[Former Member]

Hi,

Use HKONT LIKE '3000%'...

Issa

[Former Member]

hi

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.