Create additional index for BSIS

[Former Member]

Hi

In our BSIS table there are more than 4 million records for GRIR account. The auto clearing job fails with error DBIF..., think we should create one more index based on the select query where clause. But BASIS is asking where SAP is suggesting creating additional index, can any body point it out to me that yes we should create additional index for BSIS table preferably by SAP ( OSS Note etc)

Thanks in advance

Sam

[Former Member]

It's better to find a programming solution. Adding an index creates overhead. I wouldn't do this to speed up a single SELECT.

What fields do you need to SELECT on?

Rob

[Former Member]

Rob

There are more than 4 million records for a single account , we want to extract company code, account ,fiscal year, posting date, open item indicator.

[Former Member]

Hi Sam,

Creating index on BSIS is never a fesible solution, as this table is very huge in size.

Also this is used at lots of places.

You can try to query the table first by going to BKPF. or some other logic.

Rob has written a good Blog related to BSEG data fetching, it may help you.

Regards,

Atish

[Former Member]

So posting date is the only field not already in the index.

There is an index on BKPF that uses the posting date.

Rob

[Former Member]

Rob / Atish,

Thanks for responding. I will consider using BKPF and then based on that I will extract from BSIS and then delete which are not open items but will that extract all the items from BSIS. This is just to make sure that I wont miss out anything from BSIS.

Also can I have the link of that blog?

Thanks

Sam

[Former Member]

Please see:

[Quickly Retrieving FI document Data from BSEG|/people/rob.burbank/blog/2007/11/12/quickly-retrieving-fi-document-data-from-bseg]

Rob