Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

table is taking more time for execution

Former Member
0 Kudos
108

hi all,

i'm passing eban-banfn to ekpo-banfn to ebeln,

but when give banfn value in ekpo, table its is taking lot

of time for execution....

if i use select its taking lot of time..

how to over come this problem

regards

suprith

3 REPLIES 3

Former Member
0 Kudos
61

Hi pass eban-konnr to ekpo-ebeln, eban-ktpnr to ekpo-ebelp, eban-banfn to ekpo-banfn.

former_member589029
Active Contributor
0 Kudos
61

You mean you are doing a select on table EKPO with WHERE BANFN EQ some value? Since there is no key field in the where condition and no index to use this will always be a full table scan and depending on the size of your table this could be a significant performance impact.

If there is no way for you to pass in a value for EBELN in the where condition as well, the only option to speed up the access to the table would be to add a new index to the table for field BANFN.

Hope that helps,

Michael

0 Kudos
61

Hi, suprith kumar

As they wrote, You must use index to access EKPO. Try use the fields banfn and bnfpo.

Regards

Paulo Afonso Codeiro

Do reward points for useful answers.