topic Re: REPORT in Application Development and Automation Discussions

REPORT

Former Member — Tue, 04 Sep 2007 05:58:09 GMT

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.

Re: REPORT

Former Member — Tue, 04 Sep 2007 06:01:13 GMT

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

Re: REPORT

aris_hidalgo — Tue, 04 Sep 2007 06:06:10 GMT

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

Re: REPORT

Former Member — Tue, 04 Sep 2007 06:09:53 GMT

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.

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

and not include 'QA1' and 'QA2'

firstway you 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 not in r_field. "But this is available only from specific ABAP versions like above 4.6 coz it didnt work in 4.6

second way 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 in r_field.

hope it proved useful

Rewards if helpful

Regards

Byju