topic Re: select in Application Development and Automation Discussions

select

Former Member — Thu, 05 Oct 2006 07:30:01 GMT

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 — Thu, 05 Oct 2006 07:32:27 GMT

try this

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

Former Member — Thu, 05 Oct 2006 07:38:51 GMT

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 — Thu, 05 Oct 2006 07:43:06 GMT

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 — Thu, 05 Oct 2006 07:47:23 GMT

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 — Thu, 05 Oct 2006 08:28:31 GMT

hi all,

thank you very much.

it work.