topic Re: Queries in Application Development and Automation Discussions

Queries

Former Member — Mon, 13 Nov 2006 11:59:50 GMT

Hi experts,

1.When we define select-options in program..

We see From and To options...in the selection screen.In the same row if i want to put some more selections...How can we do it?...

2. Are the variants are Client Dependent or independent?..

Regards

Re: Queries

Former Member — Mon, 13 Nov 2006 12:02:54 GMT

1.When we define select-options in program..

We see From and To options...in the selection screen.In the same row if i want to put some more selections...How can we do it?...

Sorry did not understand your question..a select-option always the user to define the from and to values with different operations. eg. U can even just enter multiple single value and/or from and to values with BT as the option and/or define patterns.

Regards

Anurag

Re: Queries

Former Member — Mon, 13 Nov 2006 12:03:11 GMT

1) You cannot do that. See what the sap documentation says in this regard:

<b>"You cannot include SELECT-OPTIONS between SELECTION-SCREEN BEGIN OF LINE and SELECTION-SCREEN END OF LINE , since the system generates more than one object on the selection screen in a SELECT-OPTION (like fields for lower and upper limits).

You cannot use any variants of SELECTION-SCREEN that generate a new line (like SELECTION-SCREEN SKIP) between SELECTION-SCREEN BEGIN OF LINE and SELECTION-SCREEN END OF LINE. "</b>

2) Variants are Client Dependent.

Regards,

Ravi

Re: Queries

Former Member — Mon, 13 Nov 2006 12:03:35 GMT

Kiran,

you can use following code for define parameters in same line giving positions..

SELECTION-SCREEN BEGIN OF LINE.

SELECTION-SCREEN COMMENT 01(30) text-003 FOR FIELD p_monat MODIF ID fi.

SELECTION-SCREEN POSITION 33.

PARAMETERS p_gjahr LIKE bkpf-gjahr MODIF ID fi.

PARAMETERS p_monat LIKE bkpf-monat MODIF ID fi.

SELECTION-SCREEN COMMENT 52(04) text-005 FOR FIELD p_monat MODIF ID fi.

SELECTION-SCREEN POSITION 58.

PARAMETERS p_bgjahr LIKE bkpf-gjahr MODIF ID fi.

PARAMETERS p_bmonat LIKE bkpf-monat MODIF ID fi.

SELECTION-SCREEN END OF LINE.

variants are client dependent.

-Anu

Message was edited by:

Anupama Reddy

Re: Queries

Former Member — Mon, 13 Nov 2006 12:03:36 GMT

u need to put the select-options in a single line using positions.

Firts write begin of line....then position ur select options one by one with positions...then write end of line...

Variants are client dependent...

Re: Queries

Former Member — Mon, 13 Nov 2006 12:03:48 GMT

Hi,

1. you can clicl on the interval button provided next to the from and to select option which is represented by arrow. u can give your values there.

2. The variants are client Dependent.

Madhavi

Re: Queries

Former Member — Mon, 13 Nov 2006 12:04:16 GMT

Hello Ravi,

U can use the COMMENT statement BEGIN OF LINE AND END OF LINE for the Ist question.

Varaiants are <b>CLient dependent.</b>

If useful reward.

Vasanth

Message was edited by:

Vasanth M

Re: Queries

Former Member — Mon, 13 Nov 2006 12:06:58 GMT

Select-options are being used to take input for a range frm user.For exp

u want to display all matnr numbers bet 100 to 500

so declare like this

select-options: zmatnr for mara-matnr

then start-of-selection.

select * from mara into corresponding fields of table itab where matnr in zmatnr.

for multple selctions u have to click on the arrow mark which is in right hand side of the select-options in the execute screen ang provide the value.

Mark points if helpful

Regs

Manas Ranjan Panda

Re: Queries

Former Member — Mon, 13 Nov 2006 12:16:59 GMT

Hi all,

Thanks.