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
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,