select condition

[Former Member]

Hi Friends,

In Select query, how to give the condition for

special procurement type MARC-SOBSL starting with 4.

useful points will be rewarded.

[Former Member]

hi,

U can write in Select query the condition as

select ---

where MARC-SOBSL like '4%'.

with Regards,

Dharmishta

[nikhil_chitre]

Hi

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

[Former Member]

Hi

Try this way.

Select * from MARC into Itab

Where SOBSL like '4%'.

[Former Member]

Hi,

Try like this..

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

Where SOBSL = '4%'.

Regards,

Sai

[Former Member]

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.

[Former Member]

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