problem with BSEG table

[Former Member]

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]

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]

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]

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]

ok