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: 

How to improve performance by pulling data instead of BSEG table?

subodhmarathe
Participant
0 Kudos

Hi,

We are facing issue in which we have to pull material no for some non copa postings.

But if we use BSEG table then serious performance issues are coming up..

so are there any other tables / combination of tables that we can look for instead of BSEG?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

BSEG is Cluster table, you can only select with key fields.

if you have a select:

select belnr budat wrbtr from bseg

into table it_bseg

where bukrs = bukrs

and belnr = belnr

and gjahr = gjahr

and bschl = 31.

it's much better to select of this way:

select belnr budat wrbtr from bseg

into table it_bseg

where bukrs = bukrs

and belnr = belnr

and gjahr = gjahr.

delete it_bseg where bschl ne '31'.

Regards,

Fernando

4 REPLIES 4

Former Member
0 Kudos

hi,

BSEG is a cluster table of the below specified transparent tables... instead of it retrieve the related data from the below tables

BSID Accounting: Secondary Index for Customers(Open Items)

BSIK Accounting: Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting: Secondary Index for G/L Accounts

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)

Regards,

Santosh

0 Kudos

Since we are pulling material based on G/L acct no.

We are thinking of using 2 tables

BSIS & BSIM...

But how can we connect these 2 tables also connect logic for the extractor?

Any idea?

rodrigo_paisante3
Active Contributor
0 Kudos

/people/rob.burbank/blog/2007/11/12/quickly-retrieving-fi-document-data-from-bseg

Former Member
0 Kudos

Hi,

BSEG is Cluster table, you can only select with key fields.

if you have a select:

select belnr budat wrbtr from bseg

into table it_bseg

where bukrs = bukrs

and belnr = belnr

and gjahr = gjahr

and bschl = 31.

it's much better to select of this way:

select belnr budat wrbtr from bseg

into table it_bseg

where bukrs = bukrs

and belnr = belnr

and gjahr = gjahr.

delete it_bseg where bschl ne '31'.

Regards,

Fernando