cancel
Showing results for 
Search instead for 
Did you mean: 

Many records in BSIS table

Former Member
0 Kudos

Hi,

When the archivibng process is going to run it found many records on BSIS table, is it normal ?

The BSIS rows shoud be deleted or transfered to other table when the system is working normally. Why this is not happening.

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> The BSIS rows shoud be deleted or transfered to other table when the system is working normally. Why this is not happening.

Where did you get that information from?

BSIS is usually a big table with MANY entries.

Markus

Former Member
0 Kudos

I was thinking this table would be only for open items,

when an item was cleared, it would be copied to other table and deleted from BSIS.

Thanks,

Former Member
0 Kudos

Hi Rui,

Below is the extract from Data Management Guide which explains your concern.

BSEG and the secondary indexes are particularly affected by data growth. Document items are open line times in table BSIS and are converted into entries for table BSAS after incoming payment for example. This, however, is only true for entries for which the indicators Display Line Items and Open Item Management were set in the accounts master record. Table BSIS contains redundant data that is also found in table BSEG and which is processed in transaction FBL3.

You can download this from service.sap.com/ilm

Thanks and Best Regards,

Sunil.

Former Member
0 Kudos

Sorry forgot to mention that there are ways to reduce the number of entries in BSIS. Its given in the Guide

Thanks and Best Regards,

Sunil.

Former Member
0 Kudos

Hi Sunil,

One more question.

When are the BSIS records delete ?

Which parameter should be set for deleting BSIS records.

Thanks,

Former Member
0 Kudos

Hi Rui,

Its mentioned in the Guide itself as to how to prevent the growth of the table.

Use SAP Note 36353 (SAP R/3 Release 3.00 u2013 4.70) to reduce updating. Note, however, that this only affects entries in table BSEG. In table CKMI1 (Index for FI documents for articles) still only one line item is stored per reference document (for example goods movement) line item. There is also a link between table CMI1 and the tables RFBLG and ACCTIT: Article master data that is not contained in the accounting document is stored in the ACCT* tables. You can counteract the marked increase in data volume in tables BSIS and RFBLG by deactivating updating for line items in G/L accounts, as the line items they contain do not need to be updated: For example, for tax accounts, bank accounts, reconciliation accounts, all revenue accounts (if CO-PA is used) and all balance sheet accounts.

Thanks and Best Regards,

Sunil.

Answers (0)