25.04.2013 Page 1 of 6

SAP Note 413446 - Indexes for CIN tables for performanceimprovement

Note Language: English Version: 7 Validity: Valid Since 21.12.2004

Summary

SymptomPerformance of the CIN related transactions is poor.

Other termsperformance, CIN tables, secondary index

Reason and PrerequisitesThe CIN tables lack in appropriate secondary indexes.

SolutionApply the corrections.

Please compare the following list of the secondary indexes for CIN2.2B andCIN30A and update accordingly.

Table J_1IPART1:

- Index 001 - Index on the internal document

MANDT

TRNTYP

DOCNO

DOCYR

- Index 002 - Index on material document

MANDT

MBLNR

MJAHR

- Index 003 - Index on exgrp, regtyp

MANDT

EXGRP

REGTYP

CPUDT

Table J_1IPART2:

- Index 001 - Index on the internal document

MANDT

TRNTYP

25.04.2013 Page 2 of 6

SAP Note 413446 - Indexes for CIN tables for performanceimprovement

DOCNO

DOCYR

- Index 002 - Index on reference document

MANDT

TRNTYP

REFDOC

REFYEAR

- Index 003 - Index on excise group, register type

MANDT

EXGRP

REGTYP

BUDAT

Table J_1IEXCHDR:

- Index 001 - Index for excise invoice number

MANDT

EXGRP

EXNUM

EXDAT

LIFNR

- Index 002 - Index on reference document

MANDT

RDOC

RYEAR

RIND

- Index 003 - Index for excise invoice on excise year

MANDT

EXNUM

EXYEAR

LIFNR

25.04.2013 Page 3 of 6

SAP Note 413446 - Indexes for CIN tables for performanceimprovement

- Index 004 - Index for excise invoice on excise date

MANDT

EXNUM

EXDAT

LIFNR

Table J_1IEXCDTL:

- Index 001 - Index on the refrence document 1

MANDT

RDOC1

RYEAR1

RITEM1

RIND1

- Index 002 - Index on reference document 2

MANDT

RDOC2

RYEAR2

RITEM2

RIND2

- Index 003 - Index for J1I7 Transaction

MANDT

DOCNO

DOCYR

TRNTYP

EXNUM

EXDAT

LIFNR

MATNR

RDOC2

RYEAR2

25.04.2013 Page 4 of 6

SAP Note 413446 - Indexes for CIN tables for performanceimprovement

RDOC1

STATUS

- Index 004 - Index for excise invoice on excise year

MANDT

EXNUM

EXYEAR

LIFNR

- Index 005 - Index for excise invoice on excise date

MANDT

EXNUM

EXDAT

LIFNR

Table J_1IGRXREF:

- Index 001 - Index for excise invoice on excise year

MANDT

EXNUM

EXYEAR

LIFNR

- Index 002 - Index for excise invoice on excise date

MANDT

EXNUM

EXDAT

LIFNR

- Index 003

EXNUM

EXYEAR

EXC_ZEILE

REC_IND

25.04.2013 Page 5 of 6

SAP Note 413446 - Indexes for CIN tables for performanceimprovement

Table J_1IKONV:

Index 001 - Index for excise invoice on excise year

MANDT

EXNUM

EXYEAR

LIFNR

Table MSEG: (Addtional Index for CIN)

- Index: Index for reference documents.

MANDT

LFBJA

LFBNR

LFPOS

Table MSEG: (Addtional Index for CIN)

- Index: Index for PO

- MANDT

EBELN

EBELP

Table J_1IRG23D:

- Index 002 - Index for Excise group, CPUDT

MANDT

EXGRP

CPUDT

Header Data

Release Status: Released for CustomerReleased on: 21.12.2004 05:28:45Master Language: EnglishPriority: Correction with medium priorityCategory: PerformancePrimary Component: XX-CSC-IN-MM Materials Management

Secondary Components:MM-IV-LIV Logistics Invoice Verification

25.04.2013 Page 6 of 6

SAP Note 413446 - Indexes for CIN tables for performanceimprovement

MM-IM-GF-PERF Performance

MM-IV Invoice Verification

Valid Releases

Software Component Release FromRelease

ToRelease

andSubsequent

SAP_APPL 40 40B 40B

SAP_APPL 46 46B 46B

SAP_APPL 46C 46C 46C

SAP_APPL 470 470 470

SAP_APPL 500 500 500

SAP_APPL 600 600 600

CIN 2.2 22B 22B

CIN 3.0 30A 30A

CIN 4.0 40A 40A

Support Packages

Support Packages Release Package Name

CIN 22B SAPKIPNBC5

CIN 30A SAPKIPNE06