topic Re: Problem while selecting BELNR from BSEG in Application Development and Automation Discussions

Problem while selecting BELNR from BSEG

Former Member — Wed, 11 Jul 2007 12:22:22 GMT

Hi Experts,

I have a report performance problem while fetching BELNR from BSEG table.

I have to print latest BELNR from BSEG where BUZID = ‘M’ but at the time of execution of report, It is taking too much time (More that hour and sometimes it gets hanged).

I have also gone through the comments provided by experts for previous problems asked in this forum e.g. BSEG is a cluster table that is why data retrieval takes long time etc.

Can any one has any other idea or suggestion or any other way to solve this problem

Regards,

Neeraj

Re: Problem while selecting BELNR from BSEG

Former Member — Wed, 11 Jul 2007 12:26:11 GMT

Hi neeraj,

1. One thing which can be done is to create a secondary index on BUZID field.

2. Also i assume that the select query is a simple one without any join.

regards,

amit m.

Re: Problem while selecting BELNR from BSEG

Former Member — Wed, 11 Jul 2007 12:26:14 GMT

Hi,

BSEG is basically clusture table.

Use relevenat table instead of that

BSAD

BSAK

BSAS

BSID

BSIK

BSIM

BSIP

BSIS

etc.

Reward if useful!

Re: Problem while selecting BELNR from BSEG

Former Member — Wed, 11 Jul 2007 12:28:10 GMT

Hi,

Try using the keys(BUKRS,BELNR,GJAHR,BUZEI) of the table BSEG in the where condition.

Generally the performance does improve if you utilize as many keys as possible in the where condition while selecting from a database table.

Thanks,

Sandeep.

Re: Problem while selecting BELNR from BSEG

Former Member — Wed, 11 Jul 2007 12:43:50 GMT

Hi,

1) Try to create an index on BUZID field

2) Don't use SELECT/ENDSELECT statement. Instead of that extract all the concerned entries from BSEG into an internal table :

select belnr from bseg appending table itab where buzid = 'M'.

then do this :

sort itab by belnr.

describe itab lines n.

read table itab index n.

Please reward if helpful.

Regards,

Nicolas.

Re: Problem while selecting BELNR from BSEG

che_eky — Wed, 11 Jul 2007 12:51:00 GMT

Use a combination of Sandeep and Nicolas's suggestions.

Definately try to narrow the selection by BUKRS,BELNR,GJAHR,BUZEI and read the result into an internal table before sorting for latest BELNR.

Re: Problem while selecting BELNR from BSEG

Former Member — Wed, 11 Jul 2007 13:26:41 GMT

Well, BSEG is a cluster table, so you probably can't create a secondary index on it. I don't think there's much you can do here except run it in the bachground overnight when system load is light.

Rob