SAP table MCSI (File for Storage of Selection Versions (INDX))

SAP table MCSI has 7 primary key fields being MANDT,RELID,MCAPP,MCANA,UNAME,SELVS,SRTF2.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
RELID Theme area CHAR 2 0 MCTHEME
BW Extraction structures log (MCSI)
CM Copy Management: First record from last DB-Fetch (MCSLOG)
IS Standard analysis (MCSA, MCSI)
LO Update log (MCSI)
NA Log for statistical setup (MCSLOG)
PF Generation log for update rules (MCSI)
PI Generation log for information structure (MCSI)
RO Log for LIS Copy Management (MCSLOG)
MCAPP Number of application CHAR 2 0 TMCAP MCAPP
MCANA Number of standard analysis CHAR 4 0 TMC7 MCANA
UNAME User Name CHAR 12 0 UNAME
SELVS Selection version for standard analysis CHAR 5 0 SELVS
SRTF2 BIN4 data element for SYST INT4 10 0 SYBIN4
DATUM (8-character) Date for SYST DATS 8 0 SYDATS
UZEIT System Time TIMS 6 0 SYUZEIT
SETXT Selection version description CHAR 40 0 SETXT
CLUSTR BIN2 data element for SYST INT2 5 0 SYBIN2
CLUSTD Application Log: INDX tables data cluster LRAW 2886 0 CLUSTD

MCSI foreign key relationships

Table Field Check Table Check Field
0 MCSI MCANA TMC7 Standard Analyses in Logistics Controlling MANDT
0 MCSI MCANA TMC7 Standard Analyses in Logistics Controlling MCANA
1 MCSI MCAPP TMCAP Applications: Logistics Information System MANDT
1 MCSI MCAPP TMCAP Applications: Logistics Information System MCAPP