topic Re: optimizing queries to table BSEG in Application Development and Automation Discussions

optimizing queries to table BSEG

mayra_cobo — Fri, 27 Aug 2004 22:45:04 GMT

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 — Sat, 28 Aug 2004 06:45:55 GMT

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 — Sat, 28 Aug 2004 06:51:12 GMT

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

Former Member — Sat, 28 Aug 2004 07:56:44 GMT

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