SAP table MCRSV (Selection versions: Header data)

SAP table MCRSV has 2 primary key fields being MANDT,SELVS.

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 T000 MANDT
SELVS Selection version for standard analysis CHAR 5 0 SELVS
GSTRU Generated DDIC table for LIS, conditions, messages CHAR 30 0 * GSTRU
ANNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ANDAT Date on which the record was created DATS 8 0 ERDAT
GENAM Last Changed By CHAR 12 0 AENAME
GEDAT Date of last change DATS 8 0 AENDT
AKTPER Set indicator to include current period in period to analyze CHAR 1 0 MCEXC
XDYNPER Indicator: Dynamic calculation of time of analysis CHAR 1 0 XDYNPER
KURST Exchange rate type for conversion to analysis currency CHAR 4 0 TCURV MCKURST
WAERS Key for the currency in which the analysis is carried out CUKY 5 0 TCURC MCAWAER1
SELSET Variant for selecting the standard analysis CHAR 14 0 MCSELSET
MCPER Number of previous analysis periods of selection version NUMC 3 0 MCSVPER
SELDAT Date when selection data was saved DATS 8 0 MCSELDAT
KENNZSICHT Name of key figure view CHAR 12 0 MCKZS MCKZSICHT
SELUSR User who saved the selection data CHAR 12 0 MCSELUSR
SPRAS Language in which the selection version was created LANG 1 0 MCSPRASS
SELTIM Time when selection data was saved TIMS 6 0 MCSELTIM
MCANA Number of standard analysis CHAR 4 0 * MCANA
MMSPB Width of the characteristic column NUMC 2 0 MCMMSPB
KZSPB Maximum width of key figure columns NUMC 2 0 MCKZSPB
IDENT Indicator: characteristic display as text CHAR 1 0 OIDENT
SELVS_TYP Type of selection version CHAR 1 0 MCSELVS_TYP
Selection version, created in Release < 4.0
1 Manual selection version
2 Standard analysis -> Selection version: saved, scheduled
REPID Central evaluation report in LIS CHAR 40 0 MCREPO
MCPERZ Future analysis periods of selection version NUMC 3 0 MCSVPERZ

MCRSV foreign key relationships

Table Field Check Table Check Field
0 MCRSV KENNZSICHT MCKZS Key figure views in Logistics Controlling MANDT
0 MCRSV KENNZSICHT MCKZS Key figure views in Logistics Controlling KENNZSICHT
1 MCRSV KURST TCURV Exchange rate types for currency translation MANDT
1 MCRSV KURST TCURV Exchange rate types for currency translation KURST
0 MCRSV MANDT T000 Clients MANDT
1 MCRSV WAERS TCURC Currency Codes MANDT
1 MCRSV WAERS TCURC Currency Codes WAERS