Generate Secondary Indices
To improve the application performance, for tables containing large amounts of data, generate secondary indices for key tables relevant for the product.
Note: Ensure you have ABAP Developer access to ECC system with authorization to maintain
tables and set up table indexes.
| Table | Field for Secondary Index |
|---|---|
| MARA | VHART |
| EKBE | MATNR, WERKS |
| IKPF | BLDAT, GIDAT, ZSTAT, DSTAT, LSTAT |
| IKPF | DSTAT, LSTAT |
| IKPF | BLDAT, GIDAT, ZSTAT, LSTAT |
| IKPF | ZSTAT, DSTAT, LSTAT |
| IKPF | ZSTAT, LSTAT |
| VTTK | TPLST, SHTYP |
| VEKP | VHILM, PACKVORSCHR, STATUS |
| VTFA | VBELV, POSNV, VBTYP_V |
| /SCDL/DB_PROCI_I | DOCCAT, /SCWM/WHNO, PRODUCTNO |
| VBUK | KOSTK |
| MSEG | BWART, BUDAT_MKPF |
| EQBS | B_WERK, B_LAGER |
| EQUI | MATNR |
| LTAP | VBELN |
