topic Re: select options in Application Development and Automation Discussions

select options

Former Member — Tue, 15 Apr 2008 16:19:35 GMT

As per my requirement when select option contain only exclude parameter(Not equal to) dont want to execute the select statment.

suppose s_matnr contain only one value is ne 'Robert' then i dont want execute the select statment. Can any one let me know the logic for this plsease.

select matnr from mara where matnr in s_matnr.

Regards

Raj.

Re: select options

Former Member — Tue, 15 Apr 2008 16:25:15 GMT

Hi Kumar Raj,

You have to code the logic before the select query in your report using the Select options internal table. In the table contains "NE" don't execute the select statement.

Hope this helps.

Thanks,

Greetson

Re: select options

Former Member — Tue, 15 Apr 2008 16:26:30 GMT

hi,

do this way ...


loop at s_matnr.
   if s_matnr-option = 'NE'.
      v_flag = 'X'.
     exit.
   endif.
endloop.

if v_flag is initial.
select matnr from mara where matnr in s_matnr.
endif.

Re: select options

Former Member — Tue, 15 Apr 2008 16:34:00 GMT

Try with the below.

select matnr

from mara

into i_matnr

where matnr in s_matnr

and matnr CN 'ROBERT.

Thanks,

Srinivas

Re: select options

Former Member — Tue, 15 Apr 2008 16:39:29 GMT

Hi,

Please try this.

If s_matnr-option = 'NE'.

write any error or information or status message

else.

write the select statement from MARA.

endif.

Regards,

Madhu

Re: select options

matt — Tue, 15 Apr 2008 16:41:52 GMT

> Hi

> As per my requirement when select option contain only exclude parameter(Not equal to) dont want to execute the select statment.

> suppose s_matnr contain only one value is ne 'Robert' then i dont want execute the select statment. Can any one let me know the logic for this plsease.

> select matnr from mara where matnr in s_matnr.

The problem is not so simple, I think. For example, how can you tell the difference beween someone selecting NE Robert' and someone selecting between A to Q AND between S and Z. Or if patterns are used: e.g. A* and B* and C... AND Q AND S* AND... Z*.

You need to think carefully about what you are trying to achieve. Are you simply trying to ensure that the selected range of data is not "too large".?

If that's the case, you'll have to do a test SELECT, using SELECT COUNT. And only if the count exceeds a level, then deny the operation.

matt

Re: select options

rahul2000 — Tue, 15 Apr 2008 17:01:02 GMT

Hi mat,

excellent ans...

u r hit the nail on the head there i guess.

The problem is not as simple as it looks as during the range it is bound to give problems..

so it depends as u have said as to what exactly is tried to be done here.

cheers mat

Re: select options

matt — Tue, 15 Apr 2008 17:21:50 GMT

You're welcome! The trick is to go beyond what's asked and think about why the poster is asking. ( I did many years ago do 1st line user support, so it's a skill I picked up ).

matt

Re: select options

Former Member — Wed, 16 Apr 2008 04:04:56 GMT

Hi,

Check this link.

http://help.sap.com/saphelp_nw04s/helpdata/en/9f/dba71235c111d1829f0000e829fbfe/content.htm

Regards,

Muneesh Gitta.