Problem with Selection-Option tables..

Former Member — Fri, 12 Mar 2010 01:51:03 GMT

Hi Experts,

i have developed a report in that i am using select-option fields (tables) in select statement like below,

But this statement is taking long time while running, is there any alternative for this.

below is my code :

SELECT ebeln ebelp bwart budat menge belnr buzei bewtp charg bwtar matnr werks

FROM ekbe INTO CORRESPONDING FIELDS OF TABLE

it_sto WHERE ebeln IN s_ebeln

AND ebelp IN s_ebelp

AND budat IN s_budat

AND matnr IN s_matnr

AND bwart <> space .

Thanks in Advance,

Sudha.

Re: Problem with Selection-Option tables..

venkat_o — Fri, 12 Mar 2010 01:58:23 GMT

HI Sudha, <li>There is no problem with SELECT-OPTIONS, we use like that. But the problem I believe is that you are not passing full key of EKBE table only two keys out of 7 key fields. To improve performance better to create secondary indexes for BUDAT and MATNR so that it gets improved performance wise. Thanks Venkat.O

topic Re: Problem with Selection-Option tables.. in Application Development and Automation Discussions

Problem with Selection-Option tables..

Re: Problem with Selection-Option tables..