topic Re: problem with select options while debugging in Application Development and Automation Discussions

problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:27:23 GMT

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

Re: problem with select options while debugging

kiran_k8 — Fri, 29 Jun 2007 11:29:50 GMT

Abhi,

Paste the code.

K.Kiran.

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:30:23 GMT

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.

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:32:20 GMT

using IN operator can solve ur problem i thk.

else

paste ur code to give more i/ps

thanks

kiran

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:32:30 GMT

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'.

Re: problem with select options while debugging

kiran_k8 — Fri, 29 Jun 2007 11:39:07 GMT

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.

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:40:49 GMT

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

kiran

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:43:52 GMT

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.

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:47:09 GMT

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

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 11:49:18 GMT

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 '

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 12:05:36 GMT

HI.

You should remove SIGN and OPTI from that value.

Reward all helpfull answers.

Regards.

Jay

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 12:20:03 GMT

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

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

Re: problem with select options while debugging

Former Member — Fri, 29 Jun 2007 12:25:43 GMT

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

Re: problem with select options while debugging

Former Member — Mon, 02 Jul 2007 14:04:49 GMT

i have done it and still im not getting the result

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

Re: problem with select options while debugging

Former Member — Mon, 02 Jul 2007 14:48:24 GMT

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