Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

problem with BSEG table

Former Member
0 Kudos
861

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.

5 REPLIES 5

Former Member
0 Kudos
174

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
0 Kudos
174

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
0 Kudos
174

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
0 Kudos
174

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
0 Kudos
174

ok