SAP table MCSA (File for saving selection versions (AUSTAB))
SAP table MCSA has 5 primary key fields being MANDT,RELID,SELVS,FIELDNAME,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 | T000 | MANDT | |||||||||||||||||
RELID | Theme area | CHAR | 2 | 0 | MCTHEME |
|
|||||||||||||||||
SELVS | Selection version for standard analysis | CHAR | 5 | 0 | MCRSV | SELVS | |||||||||||||||||
FIELDNAME | Field Name | CHAR | 30 | 0 | * | FIELDNAME | |||||||||||||||||
SRTF2 | BIN4 data element for SYST | INT4 | 10 | 0 | SYBIN4 | ||||||||||||||||||
CLUSTR | Length field for user data in EXPORT/IMPORT tables | INT2 | 5 | 0 | INDX_CLSTR | ||||||||||||||||||
CLUSTD | Data field for IMPORT/EXPORT database tables | LRAW | 2886 | 0 | INDX_CLUST |
MCSA foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 MCSA | MANDT | T000 | Clients | MANDT |
1 MCSA | SELVS | MCRSV | Selection versions: Header data | MANDT |