Problem with Selection-Option tables..

[Former Member]

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.

[venkat_o]

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