SAP Table
MGVTYPE Table of version categories
SAP table MGVTYPE has 2 primary key fields being MANDT,VTYPE.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
MGVTYPE columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyVTYPE | Version Category | CHAR | 10 | 0 | VERSIONTYPE | ||
| LAEDA | Date of Last Change | DATS | 8 | 0 | LAEDA | ||
| LAETI | Time last change was made | TIMS | 6 | 0 | MGV_LAETIME | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| ASTAT | Activation status version types | CHAR | 2 | 0 | MGV_ASTAT | ||
| VTMDT | Client version type | CLNT | 3 | 0 | MGV_VTYPE_SRCCL | ||
| VTSYS | System ID version type | CHAR | 10 | 0 | MGV_VTYPE_SYSTEM | ||
| LVORM | Deletion indicator | CHAR | 1 | 0 | MGV_LOESCHVORM |
/ Relationships
MGVTYPE foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| MGVTYPE | MANDT | T000 | Clients | MANDT |