BSEG table performance issues

[Former Member]

Hi All.

Iam fetching data of 15 fields from BSEG table,

iam getting performance issues, please provide

some technics to solve performance issues related to BSEG table?

saimedha

[gerd_rother]

Hi,

When reading BSEG you might consider reading the 'index' tables BSIS, BSAS, BSID, BSAD etc. instead.These are transparent tables so you can even define indexes on them.

Please note that each table holds different data - open and close line items (the I and the A in the names) and general ledger accounts (S) or customer accounts (D for debit) and so on.

Regards,

Gerd Rother

[Former Member]

Hi,

Mention all key fields in SELECT statement

Create secondary index's in BSEG Table with ur parameters in SELECT stmt.

[ThomasZloch]

FAQ, please look around in the ABAP performance forum, what made you post this in UI programming...

Thread locked.

Thomas