topic Re: select condition in Application Development and Automation Discussions

select condition

Former Member — Fri, 27 Jun 2008 05:10:16 GMT

Hi Friends,

In Select query, how to give the condition for

special procurement type MARC-SOBSL starting with 4.

useful points will be rewarded.

Re: select condition

Former Member — Fri, 27 Jun 2008 05:12:07 GMT

hi,

U can write in Select query the condition as

select ---

where MARC-SOBSL like '4%'.

with Regards,

Dharmishta

Re: select condition

nikhil_chitre — Fri, 27 Jun 2008 05:12:49 GMT

Try this way.

Select * from MARC into Itab

Where SOBSL = '4%'.

Regards,

Nikhil

Edited by: Nikhil A Chitre on Jun 27, 2008 3:16 PM

Edited by: Nikhil A Chitre on Jun 27, 2008 3:17 PM

Re: select condition

Former Member — Fri, 27 Jun 2008 05:18:33 GMT

Try this way.

Select * from MARC into Itab

Where SOBSL like '4%'.

Re: select condition

Former Member — Fri, 27 Jun 2008 05:19:13 GMT

Hi,

Try like this..

Select * from MARC into table Itab(your internal table)

Where SOBSL = '4%'.

Regards,

Sai

Re: select condition

Former Member — Fri, 27 Jun 2008 05:20:42 GMT



data: r_sobsl type range of sobsl,
         wa_r_sobsl like line of r_sobsl.

wa_r_sobsl-sign = 'I'.
wa_r_sobsl-option = 'CP'.
wa_r_sobsl-low = '4*'.
append wa_r_sobsl to r_sobsl.

select * from marc
into table i_marc
where sobsl in r_sobsl.
if sy-subrc = 0.

endif.

Re: select condition

Former Member — Fri, 27 Jun 2008 05:20:59 GMT

Hi Friend,

You can give the condition as:

Select * from MARC into itab

Where SOBSL = '4%'.

Here 4% implies that all the records starting with 4.

'%' means all.

Hope this helps you.

Regards,

Chandra Sekhar