topic BSEG TABLE PERFORMANCE in Application Development and Automation Discussions

BSEG TABLE PERFORMANCE

Former Member — Fri, 03 Oct 2008 06:24:55 GMT

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

Re: BSEG TABLE PERFORMANCE

Former Member — Fri, 03 Oct 2008 06:27:12 GMT

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

Re: BSEG TABLE PERFORMANCE

Former Member — Fri, 03 Oct 2008 06:30:21 GMT

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.

Re: BSEG TABLE PERFORMANCE

Former Member — Fri, 03 Oct 2008 06:37:17 GMT

i want to extract the DMBTR field, data.

Re: BSEG TABLE PERFORMANCE

former_member195383 — Fri, 03 Oct 2008 06:38:27 GMT

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

Re: BSEG TABLE PERFORMANCE

Former Member — Fri, 03 Oct 2008 06:40:44 GMT

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

Re: BSEG TABLE PERFORMANCE

Former Member — Sat, 04 Oct 2008 07:18:30 GMT

THANKS ALOT TO ALL.