| 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 | MTART | Material Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | MTART | Allow NULL? |
| 3 | MTREF | Reference material type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | MTREF | Allow NULL? |
| 4 | MBREF | Screen reference depending on the material type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | MBREF | Allow NULL? |
| 5 | FLREF | Field reference for material master | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T130A | FLREF_MG | Allow NULL? |
| 6 | NUMKI | Number range | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKR | Allow NULL? |
| 7 | NUMKE | Number range | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKR | Allow NULL? |
| 8 | ENVOP | External Number Assignment Without Validation | char | 1 | 0 | CHAR | (N' ') | Yes | | ENVOP | Allow NULL? |
| 9 | BSEXT | External Purchase Orders Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BSEXT | Allow NULL? |
| 10 | BSINT | Internal purchase orders allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BSINT | Allow NULL? |
| 11 | PSTAT | Maintenance status | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PSTAT_D | Allow NULL? |
| 12 | KKREF | Account category reference | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T025K | KKREF | Allow NULL? |
| 13 | VPRSV | Price control indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VPRSV | Allow NULL? |
| 14 | KZVPR | Price Control Mandatory | char | 1 | 0 | CHAR | (N' ') | Yes | | KZVPR | Allow NULL? |
| 15 | VMTPO | Default value for material item category group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TPTM | VMTPO | Allow NULL? |
| 16 | EKALR | Material Is Costed with Quantity Structure | char | 1 | 0 | CHAR | (N' ') | Yes | | CK_EKALREL | Allow NULL? |
| 17 | KZGRP | Grouping indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZGRP | Allow NULL? |
| 18 | KZKFG | Configurable Material | char | 1 | 0 | CHAR | (N' ') | Yes | | KZKFG | Allow NULL? |
| 19 | BEGRU | Authorization group in the material master | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BEGRM | Allow NULL? |
| 20 | KZPRC | Material Master Record for a Process | char | 1 | 0 | CHAR | (N' ') | Yes | | KZPRC | Allow NULL? |
| 21 | KZPIP | Pipeline Handling Mandatory | char | 1 | 0 | CHAR | (N' ') | Yes | | KZPIP | Allow NULL? |
| 22 | PRDRU | Display price on cash register display and print on receipt | char | 1 | 0 | CHAR | (N' ') | Yes | | POSPRDRUCK | Allow NULL? |
| 23 | ARANZ | Display material on cash register display | char | 1 | 0 | CHAR | (N' ') | Yes | | POSARTANZ | Allow NULL? |
| 24 | WMAKG | Material type ID | char | 1 | 0 | CHAR | (N' ') | Yes | | WMAK | Allow NULL? |
| 25 | IZUST | Initial status of a new batch | char | 1 | 0 | CHAR | (N' ') | Yes | | IZUST | Allow NULL? |
| 26 | ARDEL | Time in days until a material is deleted | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ARDEL | Allow NULL? |
| 27 | KZMPN | Manufacturer Part | char | 1 | 0 | CHAR | (N' ') | Yes | | MPNMTART | Allow NULL? |
| 28 | MSTAE | Cross-Plant Material Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T141 | MSTAE | Allow NULL? |
| 29 | CCHIS | Control (time) of history requirement: Material | char | 1 | 0 | CHAR | (N' ') | Yes | | CC_HIST_MAT | Allow NULL? |
| 30 | CTYPE | Class Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TCLA | KLASSENART_M | Allow NULL? |
| 31 | CLASS | Class number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | KLASSE_M | Allow NULL? |
| 32 | CHNEU | Batch Creation Control (Automatic/Manual) | char | 1 | 0 | CHAR | (N' ') | Yes | | CHNEU | Allow NULL? |
| 33 | VTYPE | Version Category | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | MGVTYPE | VERSIONTYPE | Allow NULL? |
| 34 | VNUMKI | Number range | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKR | Allow NULL? |
| 35 | VNUMKE | Number range | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKR | Allow NULL? |
| 36 | KZRAC | Returnable Packaging Logistics is mandatory | char | 1 | 0 | CHAR | (N' ') | Yes | | KZRAC | Allow NULL? |
