Performance issue in fething records from BSEG

Dear All

I am fetching few fields from BSEG table for all entries I get from BKPF. I get around 8000 records from BKPF for select options.

When fetching records from BSEG table, its taking long time to execute and finally resulting in time out error.

I tried checking secondary tables for BSEG:

GL Secondary table

BSAS

BSIS

Vendor Table

BSAK

BSIK

Customer Table

BSAD

BSID

but couldnt find this field : BSEG-KOART in any of these tables.

Is there any other way to get the query resolved? Is this table BSE_CLR of use in this case?

Kindly help. Thanks in advance...

Regards

Dinesh