CIN: Performance issue in MIRO

CIN: COUNTRY VERSION INDIA.
 ( which is mostly used in Indian companies to handle the excise/tax relates issues in the business  process. uses most of the tables starting with J_1* and J* . )

Some days back we were facing performance issue in MIRO.
We go through the ST12/ST05 trace and caught that the performance is degrading during a selection of MSEG table.

The selection was like below,

SELECT * FROM MSEG WHERE LFBJA = XXDRSEG-LFGJA AND
                                                          LFBNR = XXDRSEG-LFBNR AND
                                                          LFPOS = XXDRSEG-LFPOS.

As the fields LFBJA, LFBNR,, LFPOS are not primary key in MSEG, hence it requires a secondary index during selection but it was not there.

Solution:
We need to implement the SAP NOTE - 413446 - Indexes for CIN tables for performance improvement.

There are a lot of secondary index creation mentioned in the SAP note.
In our case the problem was solved with creating the only secondary index for MSEG.

Table MSEG: (Addtional Index for CIN)
Index: Index for reference documents.
MANDT
LFBJA (Fiscal Year of a Reference Document)
LFBNR (Document No. of a Reference Document)
LFPOS (Item of a Reference Document)