Skip to Content
0
Jul 22, 2020 at 07:25 AM

EQUI table performance issue

88 Views

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.