Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

REPORT

Former Member

‎2007 Sep 04 6:58 AM

0 Likes
500

In a table I have many codegroups like QVT1..,QEAP...,ODC.... I want to extract values other than 'QV%' and 'QE%'. how can i code this in select stat.ie only 'ODC'ETC must be retrieved.

In a table I have many codegroups like QVT1..,QEAP...,ODC.... I want to extract values other than 'QV%' and 'QE%'. how can i code this in select stat.ie only 'ODC'ETC must be retrieved.

Reply
3 REPLIES 3
Read only

Former Member

‎2007 Sep 04 7:01 AM

0 Likes
468

Hi,

you need to change the excepted values in the domain or/and to change the checking table. Both inside SE11.

You can also do it on this way:

http://help.sap.com/saphelp_di46C2/helpdata/en/9f/dbaa3a35c111d1829f0000e829fbfe/frameset.htm

Regards

Nicole

Message was edited by:

Nicole Lorenz

Read only

aris_hidalgo
Contributor

‎2007 Sep 04 7:06 AM

0 Likes
468

Hi Veera,

You can try using LIKE statement in your SELECT statement.

where field1 like 'ODC%'.

or what you can do is to delete all records in your internal table not containg the string 'ODC'.

Hope it helps...

P.S. Please awatrd points if it helps...

Read only

Former Member

‎2007 Sep 04 7:09 AM

0 Likes
468

Hello,

You can do it 2 ways depending on the number of criterions needs to be selected using ranges

RANGES : r_field FOR table-field. "BSEG-UMSKZ.

DATA:wa_field LIKE LINE OF r_field.

<b>eg:if you need to get 'ODC1','ODC2'.....upto 'ODC20'

and not include 'QA1' and 'QA2'</b>

<b>firstway you</b> can append 'QA1' and 'QA2' to r_field and do

wa_field-sign = 'I'.

wa_field-option = 'EQ'.

wa_field-low = 'QA1'.

APPEND wa_field TO r_field.

clear wa_field.

wa_field-sign = 'I'.

wa_field-option = 'EQ'.

wa_field-low = 'QA2'.

APPEND wa_field TO r_field.

clear wa_field.

select * from table where XYZ <b>not in r_field</b>. "<u>But this is available only from specific ABAP versions like above 4.6 coz it didnt work in 4.6</u>

<b>second way</b> is append from 'ODC1','ODC2'.....upto 'ODC20'

wa_field-sign = 'I'.

wa_field-option = 'EQ'.

wa_field-low = 'ODC1'.

APPEND wa_field TO r_field.

wa_field-sign = 'I'.

wa_field-option = 'EQ'.

wa_field-low = 'ODC2'.

APPEND wa_field TO r_field.

and do

select * from table where XYZ <b>in r_field</b>.

hope it proved useful

Rewards if helpful

Regards

Byju