topic Re: Create additional index for BSIS in Application Development and Automation Discussions

Create additional index for BSIS

Former Member — Thu, 06 Mar 2008 20:03:01 GMT

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

Re: Create additional index for BSIS

Former Member — Thu, 06 Mar 2008 20:54:04 GMT

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

Re: Create additional index for BSIS

Former Member — Fri, 07 Mar 2008 01:50:04 GMT

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.

Re: Create additional index for BSIS

Former Member — Fri, 07 Mar 2008 01:56:34 GMT

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

Re: Create additional index for BSIS

Former Member — Fri, 07 Mar 2008 14:20:33 GMT

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

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

Rob

Re: Create additional index for BSIS

Former Member — Fri, 07 Mar 2008 16:18:29 GMT

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

Re: Create additional index for BSIS

Former Member — Fri, 07 Mar 2008 16:28:57 GMT

Please see:

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

Rob