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 |