| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | CONVID | Key for Table TMATCONV | nvarchar | 8 | 0 | CHAR | (N' ') | No | | CONVID | Allow NULL? |
| 3 | LMATNR | Length of the material number | smallint | 5 | 0 | INT2 | ((0)) | No | | LMATNR | |
| 4 | LMASKE | Length of the template for converting material numbers | smallint | 5 | 0 | INT2 | ((0)) | No | | LMATSCH | |
| 5 | ATRENN | Number of Different Formatting Characters | smallint | 5 | 0 | INT2 | ((0)) | No | | ATRENN | |
| 6 | ATRENNX | Total Number of Formatting Characters | smallint | 5 | 0 | INT2 | ((0)) | No | | ATRENNX | |
| 7 | LNGEFF | Number of significant characters | smallint | 5 | 0 | INT2 | ((0)) | No | | LNGEFF | |
| 8 | MASKE | Template for material number conversion | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MATSCH | Allow NULL? |
| 9 | TZ | Enumeration of editing characters | nvarchar | 18 | 0 | CHAR | (N' ') | No | | SCHABLONE | Allow NULL? |
| 10 | FLAG0 | Indicator: Display material number with leading zeros | char | 1 | 0 | CHAR | (N' ') | No | | MATNR0 | Allow NULL? |
| 11 | LEXFLAG | Indicator for lexicographical material numbers | char | 1 | 0 | CHAR | (N' ') | No | | LEXFLAG | Allow NULL? |
| 12 | VCHAR | Separator for Versioned Materials | char | 1 | 0 | CHAR | (N' ') | No | | MGV_VCHAR | Allow NULL? |
| 13 | LMATNR_TOTAL | Total Length of Material Number | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MGV_LMATNR_TOTAL | |
| 14 | LMATNR_VERS | Length Version number | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MGV_LMATNR_VERS | |
| 15 | MAX_DIFF | Max. difference between int. & ext. (SAP internal use) | char | 1 | 0 | CHAR | (N' ') | Yes | | MGV_MAXDIFF | Allow NULL? |
| 16 | MVAKT | Material versioning active | char | 1 | 0 | CHAR | (N' ') | Yes | | VERSIONSACTIVE | Allow NULL? |
