topic Re: SAP Query in Application Development and Automation Discussions

SAP Query

Former Member — Thu, 23 Nov 2006 12:48:17 GMT

Hi,

I have few selctions on fields in SAP Query.

Is there a possibility to make the select options fields as parameter field?

Thanks in advance.

Re: SAP Query

anversha_s — Thu, 23 Nov 2006 12:51:16 GMT

use no intervels

eg:

SELECT-OPTIONS : s_kunnr for kna1-kunnr no intervels.

Re: SAP Query

Former Member — Thu, 23 Nov 2006 12:52:19 GMT

its SAP Query. Where should I write so intervals?

I get the selection fields by just selecting from the fields groups of the infoset.

Re: SAP Query

Former Member — Thu, 23 Nov 2006 13:06:18 GMT

Hi Srikanth

I think this is not possible as fas as I have known. Just a suggestion. Just try to set variant for single field selection in the select option. I.E. Right the Select Option -> Option -> Single Value.

Regards

Kathirvel

Re: SAP Query

Former Member — Thu, 23 Nov 2006 13:14:17 GMT

Hi Srikanth

I remember we can make the Select-Option as Parameter and even Obligatory.

Am not on SAP to give you the exact details. Please continue exploring, hopefully you might get the solution. Will provide you more details when i get back to office tomorrow.

Kind Regards

Eswar

Re: SAP Query

Former Member — Thu, 23 Nov 2006 13:16:01 GMT

select-options : s_matnr for mara-matnr no-intervals no-extensions.

but this this looks like parameter but does not act like parameter when u leave that empty in selection screen

when u leave that empty it will take all the values when used in select , but for parameter if u leave empty it will not select any value

Re: SAP Query

Former Member — Fri, 24 Nov 2006 01:15:12 GMT

Hi Srikanth

As promised, please find the details below:

1. SQ01.

2. Select the query with Change Mode.

3. Use Menupath: Goto->Field Selection->Selections.

4. In this screen we need to check both the checkboxes i.e Column SV & 1Z for the Select-Option that we need to make as Parameter.

For your Info: Checking SV will remove the the extension will be removed, Checking 1Z will remove the intervals.

Hope the above info helps you.

Kind Regards

Eswar