topic BSEG table performance issues in Application Development and Automation Discussions

BSEG table performance issues

Former Member — Wed, 19 May 2010 05:37:22 GMT

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

Re: BSEG table performance issues

gerd_rother — Wed, 19 May 2010 06:45:05 GMT

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

Re: BSEG table performance issues

Former Member — Wed, 19 May 2010 07:36:24 GMT

Hi,

Mention all key fields in SELECT statement

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

Re: BSEG table performance issues

ThomasZloch — Wed, 19 May 2010 07:46:30 GMT

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

Thread locked.

Thomas