Skip to Content
0
Sep 10, 2013 at 03:13 AM

Problem with select option and Index

36 Views

Hi Abapers,

Please see the below code, this behaves strange when it comes to picking up the index from JCDS table

when I am passing date in select-option - low it picks the correct index but when I am passing the same date in low and high it takes lot of time to execute ,

after i checked the trace I have found that it is not picking the correct index in second case ,

SELECT jcds~objnr
jcds~stat
jcds~chgnr
jcds~usnam
jcds~udate
jcds~utime
jcds~cdtcode
jcds~inact
FROM jcds
INTO (alv_grid_table_header-objnr ,
alv_grid_table_header-stat ,
alv_grid_table_header-chgnr ,
alv_grid_table_header-usnam ,
alv_grid_table_header-udate ,
alv_grid_table_header-utime ,
alv_grid_table_header-cdtcode ,
alv_grid_table_header-inact)
WHERE jcds~stat IN stat_table
AND jcds~usnam IN usnam
AND jcds~udate IN udate