Since the product has been created the following indexes that it is recommended to create in the systems where the B + SII solution is installed to speed up the search of data and thus to have more efficient searches.
The indexes created are as follows:
| Table | Index Name | Description | Field | Index Type |
|---|---|---|---|---|
| /EDGE/SII_CO_001 | 001 | Index for reconciliation Master | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_CO_005 | SI1 | Index for EDOC_GUID | MANDT EDOC_GUID | Non-unique index: Index of all database systems. |
| /EDGE/SII_AL_002 | ED1 | Index for alarm On | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_AL_002 | EG1 | Search for alarm instances by guid | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_AL_008 | EN1 | Index for bringing notification-related alarms | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_ID_FAC | I1 | Index by eDocument GUID | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_ID_FAC | I2 | Index by NIF and invoice number | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_ID_FAC | I3 | Index by ID and invoice number | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_ID_FAC | I4 | Index by invoice date | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_LOTHCO | EL1 | Count of Batches | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_NUMLOT | 01 | GUID identification of batch by number | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_VLNIFC | I1 | Index for validated NIF | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_VLNIFP | I1 | Index for validated NIFs | MANDT | Non-unique index: Index of all database systems. |
| /EDGE/SII_OA_001 | I01 | Index by transaction data by counterparty | TIPO_OPERACION | Non-unique index: Index of all database systems. |
| EDOCUMENT | Z03 | Search for expiration alarms | MANDT | Non-unique index: No database index. |
| EDOCUMENT | Z04 | Index for search by accounting key CE / PR SII | MANDT | Non-unique index: Index of all database systems. |
| EDOCUMENTHISTORY | Z04 | Index for accounting key CE / PR SII | /EDGE/CLAVE_CONTABLE | Non-unique index: Index of all database systems. |
| LFA1 | Z01 | Search index for stceg | MANDT | Non-unique index: Index of all database systems. |
| LFA1 | Z02 | Index for Tax Identification Number 1 | MANDT | Non-unique index: Index of all database systems. |
| LFA1 | Z03 | Index for Supplemental Tax Identification Number | MANDT | Non-unique index: Index of all database systems. |
| LFA1 | Z04 | Index for Tax Identification Number 3 | MANDT STCD3 | Non-unique index: Index of all database systems. |
| LFA1 | Z05 | Index for Tax Identification Number 4 | MANDT STCD4 | Non-unique index: Index of all database systems. |
| KNA1 | Z01 | Index for STCEG Filed | MANDT | Non-unique index: Index of all database systems. |
| KNA1 | Z02 | Index for Tax Identification Number 1 | MANDT | Non-unique index: Index of all database systems. |
| KNA1 | Z03 | Index for Supplemental Tax Identification Number | MANDT | Non-unique index: Index of all database systems. |
| KNA1 | Z04 | Index for Tax Identification Number 3 | MANDT STCD3 | Non-unique index: Index of all database systems. |
| KNA1 | Z05 | Index for Tax Identification Number 4 | MANDT STCD4 | Non-unique index: Index of all database systems. |
| RBKP | Z01 | Index for Number of an accounting doc number and exercise | MANDT | Non-unique index: Index of all database systems. |
| RENT_M340_ES | Z01 | Index for company code, accounting docummet and exercise | MANDT | Non-unique index: Index of all database systems. |