BSEG TABLE PERFORMANCE

[Former Member]

Dear Friend,

I am developing a finace report,

In this report i am using BSEG table but

the problem is that even i am trying to extract

the single record from this table .

reports takes lots of time and cause a dummp error,

due to time exceed.

Please help me out.

Thanks and Regards

vivek kumar srivastava

[Former Member]

Can you tell me the fields you are using in the select statement?.

[Former Member]

i want to extract the DMBTR field, data.

[former_member195383]

please paste the select statement...that u are using...

[Former Member]

Hello ,

Did you see the blog mentioned in the earlier reply.

It wont matter even if you extract one field or all the fields. Its the matter of number of records and in that blog you can see how to achieve faster performance with hundreds of thousands of records.

regards,

Advait

[Former Member]

Hi,

BSEG is a cluster table of the below specified transparent tables... instead of it retrieve the related data from the below tables

BSID Accounting: Secondary Index for Customers(Open Items)

BSIK Accounting: Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting: Secondary Index for G/L Accounts

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)

Check this blog aslo..

Regards,

Omkaram.

[Former Member]

THANKS ALOT TO ALL.