| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PGNAM | ABAP Program Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 3 | KZVTD | Updating of Administrative Data | char | 1 | 0 | | | | Allow NULL? |
| 4 | KZUMR | Indicator: only defined units of measure can be used | char | 1 | 0 | | | | Allow NULL? |
| 5 | ANZUM | Maximum number of incorrect material master records | decimal | 5 | 0 | | | | |
| 6 | STDZG | Standard document type for drawings | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | KZASY | Ind.: Update material administrative data asynchronously | char | 1 | 0 | | | | Allow NULL? |
| 8 | PMCID | Indicator: no program-driven matchcode IDs exist | char | 1 | 0 | | | | Allow NULL? |
| 9 | LAND1 | Standard country (retail) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | KZPMA | Ind.: Use cross-distribution-chain pricing ref. materials | char | 1 | 0 | | | | Allow NULL? |
| 11 | KZPMV | Ind.: Use distribution-chain-specific pricing ref. materials | char | 1 | 0 | | | | Allow NULL? |
| 12 | KZNFM | Indicator: Use follow-up materials | char | 1 | 0 | | | | Allow NULL? |
| 13 | KZVBM | Indicator: Use reference materials for consumption | char | 1 | 0 | | | | Allow NULL? |
| 14 | KZPRG | Use Planning Materials | char | 1 | 0 | | | | Allow NULL? |
| 15 | KZSAT | Indicator: Use configurable materials (cross-plant) | char | 1 | 0 | | | | Allow NULL? |
| 16 | KZSTD | Indicator: Use configurable materials (plant-specific) | char | 1 | 0 | | | | Allow NULL? |
| 17 | KZMPN | Indicator: Use manufacturer part numbers | char | 1 | 0 | | | | Allow NULL? |
| 18 | KZALM | Ind.: Check all required fields in material master maint. | char | 1 | 0 | | | | Allow NULL? |
| 19 | XPRAR | Ind.: XPRA executed for initializing reference materials | char | 1 | 0 | | | | Allow NULL? |
| 20 | RFCDEST | RFC destination for material search in external catalog | nvarchar | 32 | 0 | | | | Allow NULL? |
| 21 | SLOCK | Shared Lock in Material Master (Only Tables MBEW and MARC) | char | 1 | 0 | | | | Allow NULL? |
| 22 | KZNCK | Dispense with Consistency Checks | char | 1 | 0 | | | | Allow NULL? |
| 23 | ALEFL | Mode of Change Authorizations for Integrated Distributed PDM | char | 1 | 0 | | | | Allow NULL? |
| 24 | CONSE | Send Configuration When Sending Complete Material Master | char | 1 | 0 | | | | Allow NULL? |
| 25 | CONCP | Generate Change Pointer for Material Variants | char | 1 | 0 | | | | Allow NULL? |
| 26 | NOVER | No Update of MOFF/MSTA Data with Separate Evaluation | char | 1 | 0 | | | | Allow NULL? |
| 27 | NOAPP | Control for Creation of Application Log | char | 1 | 0 | | | | Allow NULL? |
| 28 | KZUCM | Indicator: Reference Material for Original Batches | char | 1 | 0 | | | | Allow NULL? |
| 29 | KZRMA | Indicator: Reference Material for Similar Packable Materials | char | 1 | 0 | | | | Allow NULL? |
