select

[Former Member]

hello all,

i need to do select to table mseg for all ebeln that start with 2.

is anyone know how can i do that?

thanks,

dana.

[Former Member]

try this

select * from mseg into table itab where ebeln like '2*'.

[Former Member]

Hi,

Try like this,

DATA : v_ebeln type ekko-ebeln value '2*'.

and use this in your select query.

data : v_ebeln type ekko-ebeln value '4*'.

data itab like table of EKKO with header line.

Select * from ekko into table itab where ebeln > v_ebeln.

Loop at itab.

write 😕 itab-ebeln.

endloop.

Hope it helps.

Prashanth

[Former Member]

Hello,

Try like this.

Data: a1(2).

Concatenate '2' '%' into a1.

select * from mseg into itab where ebeln like a1.

If useful reward.

Vasanth

[Former Member]

Have a look at below link. http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/content.htm.

Instead of '2*', You should use select * from mseg into table itab where ebeln like '2%'.

Best Regards,

Vibha Deshmukh

*Plz mark useful answers

[Former Member]

hi all,

thank you very much.

it work.