acessing BSEG cluster table

[Former Member]

Will any one please tell ! any way other than standard ways to access BSEG efficently or (by passing or by some sap standard or other ways ) bseg to make it efficent at it most ! is there such method or tecnique exist please explain n give links , reward points will begiven to most appropriate answer

[Former Member]

Will any one please tell ! any way other than standard ways to access BSEG efficently or (by passing or by some sap standard or other ways ) bseg to make it efficent at it most ! is there such method or tecnique exist please explain n give links , reward points will begiven to most appropriate answer

[Former Member]

hi

generally bseg tables have very high volume of data.

so while writing prog plz go through the following points.

1 in the global dta declaration always write the "TABLES : BSEG." statement

2.

while reading the data from the internal table

use the syntax ..

read table with binary search or with key...

3

plz don't use select * state ment ..

use select <f1> < f2> < f3>... statements.

rewards if useful

sachhidananda

[Former Member]

Hi,

it is better you go through many threads that are created for BSEG related performance issues. it will give you an idea of how to write an efficient query on the same.

Regards,

Madhumitha

[Former Member]

Hi,

You can try to use one of the LDB's if they meet your requirment.

Regards,

Himanshu Verma

[ThomasZloch]

no need to look any further than this blog by Mr. Burbank:

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

(which can be found by anyone searching for blogs with "BSEG" in the title...)

[Former Member]

Ali - there is a section in this blog that shows how to get document numbers when you have the order number (AUFNR). I think that is what you are looking for.

Rob

[Former Member]

try to avoid 'use of BSEG table'.

Its a clustor table, so definately it will take time to fetch data.

1) Using primary key condition u can use BSEG

2) Use other table BSAD,BSID,BSAK,BSIK,BSAS,BSIS etc.