REPORT

[Former Member]

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.

[Former Member]

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

[aris_hidalgo]

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...

[Former Member]

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