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 1. Secondary Indices - Table and Field
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