Perfomance issue with BSIS Table

[Former Member]

Hi all,

I am encountering a performance issue when seelcting from BSIS table.

The requirement is I have Internal Orders extracted from a Master table, based on these internal orders and company code I need to go to BSIS table and do an extraction for other fields. When I am doing a Select on BSIS with the above conditions, the performance is very bad. Is there any other better ways to handle this.

Thanks in advance.

GK

[Former Member]

Hi all,

I am encountering a performance issue when seelcting from BSIS table.

The requirement is I have Internal Orders extracted from a Master table, based on these internal orders and company code I need to go to BSIS table and do an extraction for other fields. When I am doing a Select on BSIS with the above conditions, the performance is very bad. Is there any other better ways to handle this.

Thanks in advance.

GK

[alpesh_saparia3]

Hi,

Try creating index on fields which you are passing in where condition.

There is only one index with name "1" which is on BUKRS,BELNR,GJAHR and BUZEI.

[Former Member]

How do I create an index?

[Former Member]

Hello

For the best - address to BASIC.

[Former Member]

Hi,

Se11-->Indexes->Create->Give Index ID say Z01 -

---

>Give key fields & activate.

Regards

Raju Chitale

[Former Member]

I did not get you..

[Former Member]

hi gunjan,

to improve the performance on BSIS fetch,

then first of check your fields in where condition..

then go to se11. and display BSIS table.

In application tool bar there is push button named 'Indexes'

click on it.

and see if there is any index already present there which contains all your fields in where condition clause.

if not then ask your senior if you can create a seconadry index on it.

if he allows you to create then go for it.

hope this will help u..

[Former Member]

Hi Manisha,

Thanks for the response.

If I create a secondry index, should I take care of this index while coding?

Thanks

GK

[Former Member]

Hi,

Even if you create seconday index, you will not improve the performance,atleast make sure that you use BELNR, GJAHR, HKONT.

Better to consult your Functional person, how can you use this fields in your select statement for BSIS.

Thanks,

Sriram Ponna.