topic problem with BSEG table in Application Development and Automation Discussions

problem with BSEG table

Former Member — Sat, 28 Feb 2009 06:04:22 GMT

Hi All,

in myprograme, select data from BSEG table based upon conditions ,it takes more time and give the runtime error.

to get select data fast from BSEG ,what can i do?

Thanks.

Former Member — Sat, 28 Feb 2009 06:20:07 GMT

hi.

BSEG is a cluster and huge table.

Our BI Consultant was facing the same error.

But he made some changes in PROFILE -> rdisp/max-wprun_time and changed its value to 3600.

meanz now program will run continually for one hour and did not show run time error.

plz say ur BASIS team to change profile as i mentioned above

suredarreddy_pulimamidi — Sat, 28 Feb 2009 06:29:10 GMT

Hi,

BSEG is Cluster Table.It holds 9 tables Data.

Instead of using BSEG tables use other tables which are relevent from those 9 tables (BSIS,BSAS,BSAK,BSIK,BSID,BSAD).

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

BSIS Accounting: Secondary Index for G/L Accounts

Regards,

Surendar Reddy.

Former Member — Sat, 28 Feb 2009 06:49:17 GMT

Hello,

it depends on your situation what is the main purpose of your requirement. Please can you let me know your scenario where you faced the problem?

Ahmed

Former Member — Wed, 24 Jun 2009 13:32:10 GMT