EQUI table performance issue

[sp0123]

Dear Expert ,

We are working on an interface where we are using EQUI table to get the Serial no. for Material and Batch as an input. Since Material and Batch are not primary keys, so it is taking ages to fetch the serial no. where there are million entries in EQUI.

Can anyone suggest any table or FM which can fetch the serial no. faster than EQUI or any other way to achieve this requirement?

Input Parameters: Material , Batch

Output: Serial no.

Note- We have a single serial no. for each batch.

[peter_atkin · Accepted solution]

Shiv Kumar

Have you tried a view table like V_EQUI (setting the DATBI = '99991231' value)?

PeteA

[sp0123 · Accepted solution]

Hi Pete,

Thanks a lot. It worked much faster. 2 secs (V_EQUI) vs 116 secs (EQUI) for the same no. of records