topic Re: acessing BSEG cluster table in Application Development and Automation Discussions

acessing BSEG cluster table

Former Member — Mon, 26 May 2008 10:54:40 GMT

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

Re: acessing BSEG cluster table

Former Member — Mon, 26 May 2008 11:10:39 GMT

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

while reading the data from the internal table

use the syntax ..

read table with binary search or with key...

plz don't use select * state ment ..

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

rewards if useful

sachhidananda

Re: acessing BSEG cluster table

Former Member — Mon, 26 May 2008 15:25:46 GMT

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

Re: acessing BSEG cluster table

Former Member — Mon, 26 May 2008 15:29:01 GMT

Hi,

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

Regards,

Himanshu Verma

Re: acessing BSEG cluster table

ThomasZloch — Mon, 26 May 2008 20:07:22 GMT

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

Re: acessing BSEG cluster table

Former Member — Tue, 27 May 2008 13:15:35 GMT

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

Re: acessing BSEG cluster table

Former Member — Wed, 28 May 2008 04:17:23 GMT

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.