optimizing queries to table BSEG

[mayra_cobo]

Hi,

I would like to know if there is a way of optimizing queries to tables BKPF and BSEG.

Thanks in advance.

Regards,

Mayra

[Former Member]

That depends on the query you execute against MKPF or MSEG.

As a general method, you may consider adding indexes on these tables accordingly to the most frequent queryes that manipulate their content.

Again, the index (its structure) depends on the structure of the corresponding queryes.

Bogdan

[Former Member]

Sorry, ofcourse I meant BKPF and BSEG (not MKPF and MSEG), the rest still remains true

[Former Member]

Mayra,

It depends on data you have to read those table. But you may consider to use so called secondary index tables:

BSAD Accounting: Secondary index for customers (cleared items)

BSAK Accounting: Secondary index for vendors (cleared items)

BSAS Accounting: Secondary index for G/L accounts (cleared items)

BSID Accounting: Secondary index for customers

BSIK Accounting: Secondary index for vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting: Secondary index for G/L accounts

regards,

Andrzej