| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MSEHI | Unit of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | KZEX3 | 3-char indicator for external unit of measurement | char | 1 | 0 | | | | Allow NULL? |
| 4 | KZEX6 | 6-char. ID for external unit of measurement | char | 1 | 0 | | | | Allow NULL? |
| 5 | ANDEC | No. of decimal places to which rounding should be performed | smallint | 5 | 0 | | | | |
| 6 | KZKEH | Commercial measurement unit ID | char | 1 | 0 | | | | Allow NULL? |
| 7 | KZWOB | Value-based commitment indicator | char | 1 | 0 | | | | Allow NULL? |
| 8 | KZ1EH | Indicator (1) unit (indicator not yet defined) | char | 1 | 0 | | | | Allow NULL? |
| 9 | KZ2EH | Indicator (2) unit (indicator not yet defined) | char | 1 | 0 | | | | Allow NULL? |
| 10 | DIMID | Dimension key | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | ZAEHL | Numerator for conversion to SI unit | int | 10 | 0 | | | | Allow NULL? |
| 12 | NENNR | Denominator for conversion into SI unit | int | 10 | 0 | | | | Allow NULL? |
| 13 | EXP10 | base ten exponent for conversion to SI unit | smallint | 5 | 0 | | | | |
| 14 | ADDKO | Additive constant for conversion to SI unit | decimal | 9 | 6 | | | | |
| 15 | EXPON | Base ten exponent for floating-point display | smallint | 5 | 0 | | | | |
| 16 | DECAN | Number of decimal places for number display | smallint | 5 | 0 | | | | |
| 17 | ISOCODE | ISO code for unit of measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | PRIMARY | Selection field for conversion from ISO code to int. code | char | 1 | 0 | | | | Allow NULL? |
| 19 | TEMP_VALUE | Temperature | float | 15 | 16 | | | | |
| 20 | TEMP_UNIT | Temperature unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | FAMUNIT | Unit of measurement family | char | 1 | 0 | | | | Allow NULL? |
| 22 | PRESS_VAL | Pressure Value | float | 15 | 16 | | | | |
| 23 | PRESS_UNIT | Unit of Pressure | nvarchar | 3 | 0 | | | | Allow NULL? |