problem with BSEG table

[Former Member]

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.

[Former Member]

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.

[Former Member]

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....

[Former Member]

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

[Former Member]

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

[Former Member]

ok