1. Home
  2. Resources
  3. SAP Tables
  4. TMCNV - Data on Material Numbers Conversion

SAP Table TMCNV

Data on Material Numbers Conversion

TMCNV (Data on Material Numbers Conversion) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TMCNV to other SAP tables.

Source: TMCNV (Data on Material Numbers Conversion)

TMCNV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CONVID Key for Table TMATCONV CONVID CHAR 8 0
LMATNR Length of the material number LMATNR INT2 5 0
1 Possible length of material number
LMASKE Length of the template for converting material numbers LMATSCH INT2 5 0
1 Possible length of material number
ATRENN Number of Different Formatting Characters ATRENN INT2 5 0
1 Possible length of material number
ATRENNX Total Number of Formatting Characters ATRENNX INT2 5 0
1 Possible length of material number
LNGEFF Number of significant characters LNGEFF INT2 5 0
1 Possible length of material number
MASKE Template for material number conversion MATSCH CHAR 18 0
TZ Enumeration of editing characters SCHABLONE CHAR 18 0
FLAG0 Indicator: Display material number with leading zeros MATNR0 CHAR 1 0
X Yes
NULL No
LEXFLAG Indicator for lexicographical material numbers LEXFLAG CHAR 1 0
NULL No lexicographical entry
X Lexicographical entry
VCHAR Separator for Versioned Materials MGV_VCHAR CHAR 1 0
LMATNR_TOTAL Total Length of Material Number MGV_LMATNR_TOTAL INT2 5 0
1 Possible length of material number
LMATNR_VERS Length Version number MGV_LMATNR_VERS INT2 5 0
1 Possible length of material number
MAX_DIFF Max. difference between int. & ext. (SAP internal use) MGV_MAXDIFF CHAR 1 0
X Yes
NULL No
MVAKT Material versioning active VERSIONSACTIVE CHAR 1 0
X Yes
NULL No