SAP table TMCNV (Data on Material Numbers Conversion)
SAP table TMCNV has 2 primary key fields being MANDT,CONVID.
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 | |||||
| CONVID | Key for Table TMATCONV | CHAR | 8 | 0 | CONVID | ||||||
| LMATNR | Length of the material number | INT2 | 5 | 0 | LMATNR | ||||||
| LMASKE | Length of the template for converting material numbers | INT2 | 5 | 0 | LMATSCH | ||||||
| ATRENN | Number of Different Formatting Characters | INT2 | 5 | 0 | ATRENN | ||||||
| ATRENNX | Total Number of Formatting Characters | INT2 | 5 | 0 | ATRENNX | ||||||
| LNGEFF | Number of significant characters | INT2 | 5 | 0 | LNGEFF | ||||||
| MASKE | Template for material number conversion | CHAR | 40 | 0 | MATSCH | ||||||
| TZ | Enumeration of editing characters | CHAR | 40 | 0 | SCHABLONE | ||||||
| FLAG0 | Indicator: Display material number with leading zeros | CHAR | 1 | 0 | MATNR0 | ||||||
| LEXFLAG | Indicator for lexicographical material numbers | CHAR | 1 | 0 | LEXFLAG |
|
|||||
| VCHAR | Separator for Versioned Materials | CHAR | 1 | 0 | MGV_VCHAR | ||||||
| LMATNR_TOTAL | Total Length of Material Number | INT2 | 5 | 0 | MGV_LMATNR_TOTAL | ||||||
| LMATNR_VERS | Length Version number | INT2 | 5 | 0 | MGV_LMATNR_VERS | ||||||
| MAX_DIFF | Max. difference between int. & ext. (SAP internal use) | CHAR | 1 | 0 | MGV_MAXDIFF | ||||||
| MVAKT | Material versioning active | CHAR | 1 | 0 | VERSIONSACTIVE |