SAP Query

[Former Member]

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.

[anversha_s]

use no intervels

eg:

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

[Former Member]

its SAP Query. Where should I write so intervals?

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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