topic Re: problem with BSEG table in Application Development and Automation Discussions

problem with BSEG table

Former Member — Wed, 04 Mar 2009 12:17:31 GMT

Hi All,

When select data from BSEG into it_bseg table and loop at it_bseg then system takes more time

and give the runtime error in the quality server.

to get data fast from BSEG into it_bseg table and run fast the loop at it_bseg.

WIPRO company did the one programe to my company , that programe displays the data very fast using

BSEG table.

Thanks.

Re: problem with BSEG table

Former Member — Wed, 04 Mar 2009 12:20:30 GMT

erm why dont you just analyse that program if you already have it?

BSEG is a clister table and it is HUGE, crapload of data in it.

you will not be possible to hold all its data within a internal table, so check that program for other strategies to use.

Re: problem with BSEG table

Former Member — Wed, 04 Mar 2009 12:32:59 GMT

For faster access of the BSEG table you should make the following fields mandatory in the select query where condition..

BUKRS

BELNR

GJAHR

other wise try to get above 3 field values from related tables and pass it here....

Like if you want to pass GL A/C's only to BSEG then get the belnr from BSAK, BSIK if it is vendor ..BSAD,BSID if its customers...

like that get frame a logic to get the primary key values of bseg and then pass...since its a very large table and moreover its cluster table so you cant have your secondary index also....

Re: problem with BSEG table

Former Member — Wed, 04 Mar 2009 12:34:55 GMT

Hi,

Instead of using BSEG table use these alternate tables....



Cleared items:
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)

Non-cleared items:
BSID Accounting: Secondary Index for Customers
BSIK Accounting: Secondary Index for Vendors
BSIM Secondary Index, Documents for Material
BSIP Index for Vendor Validation of Double Documents
BSIS Accounting: Secondary Index for G/L Accounts

Hope its helps

Re: problem with BSEG table

Former Member — Wed, 04 Mar 2009 12:38:34 GMT

Hi ,

work using primary index in select query

select * from bseg

client specified into table it_bseg

where mandt in ( select * from t001).

and use all keys

Re: problem with BSEG table

Former Member — Tue, 05 May 2009 12:44:40 GMT