problem with select options while debugging

[Former Member]

hi friends,

i have 4 select optins for my program, if i give all the select options , im not getting the out put. so i run debugging mode and i found that while selecting the options itz selecting the options starting with IEQ ( plant : 0050, but itz taking as IEQ0050)

so how to rectify this problem

thanx in advance

abhilash

[kiran_k8]

Abhi,

Paste the code.

K.Kiran.

[Former Member]

TABLES : Z_DELIVARY_TABLE.

SELECT-OPTIONS : PLANT FOR Z_DELIVARY_TABLE-WERKS,

SALESDOC FOR Z_DELIVARY_TABLE-VBELN,

CODGRUPE FOR Z_DELIVARY_TABLE-OTGRP,

MATERIAL FOR Z_DELIVARY_TABLE-MATNR.

DATA : ITAB TYPE Z_DELIVARY_TABLE OCCURS 0 WITH HEADER LINE.

DATA : CONTAINER TYPE REF TO CL_GUI_CUSTOM_CONTAINER,

GRID TYPE REF TO CL_GUI_ALV_GRID,

gt_fieldcat TYPE lvc_t_fcat.

SELECT * FROM Z_DELIVARY_TABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE WERKS IN PLANT

AND VBELN IN SALESDOC

AND OTGRP IN CODGRUPE

AND MATNR IN MATERIAL

AND SPRAS = 'D'

AND MNCOD = '3050'.

[kiran_k8]

Abhi,

You are using a ztable.First check the where clause fields are primary key fields or not or in the index in the same sequence, if any.

K.Kiran.

[Former Member]

there is no problem here.

chk if there is data for plant specified.

and 1 caution... try not to use corresposndig fld. this will surely reduce the performance at any cost.

if u dont require all, selct only those u wann.

if u req most of them, select * and then move all those req into a separate table

lemme know

tx

kiran

[Former Member]

Hi Abhi,

Check whether any data exists in the database table for the select-options data thta u r entering on selection screen.

As you are giving all the selct-options on selection screen,there may not be any data in ur table.

check once.

Reward points if useful

Regards,

Sasi.

[Former Member]

the point is i am using a view.

i called all the data from that view itself as it is clear in the code.

so what should i do now ????

it also taking a lot of time when executing, after that i m getting an error that 'memory low '

[Former Member]

can u post the code

use IN instead of =

select * from ztable where field1 <b>IN</b> S_field1 and

field2 <b>IN</b> S_FIELD2.

[Former Member]

using IN operator can solve ur problem i thk.

else

paste ur code to give more i/ps

thanks

kiran

[Former Member]

There is no problem in the coding. You check the table entries with that plant.

when you click on selectoption you will see that IEQ0050 only.

Regards

Vijay

[Former Member]

HI.

You should remove SIGN and OPTI from that value.

Reward all helpfull answers.

Regards.

Jay

[Former Member]

i could'nt understand what is SIGN and OPTI!!!!!!

could you xplain me clearly??????????

[Former Member]

deffine the select options from the table. not from the view. then try it...

[Former Member]

i have done it and still im not getting the result

what to do now***?????

[Former Member]

go to the table(from which you are retriving data) and check whether data is there not by giving all the data as you are giving in the program selection screen