Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

select condition

Former Member
0 Kudos

Hi Friends,

In Select query, how to give the condition for

special procurement type MARC-SOBSL starting with 4.

useful points will be rewarded.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

6 REPLIES 6

Former Member
0 Kudos

hi,

U can write in Select query the condition as

select ---

where MARC-SOBSL like '4%'.

with Regards,

Dharmishta

nikhil_chitre
Active Participant
0 Kudos

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
0 Kudos

Hi

Try this way.

Select * from MARC into Itab

Where SOBSL like '4%'.

Former Member
0 Kudos

Hi,

Try like this..

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

Where SOBSL = '4%'.

Regards,

Sai

former_member212653
Active Contributor
0 Kudos


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
0 Kudos

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