| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RECN | Sequential Number of Data Record | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | ACTN | Sequential Number of the Change State | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | VALFR | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | VALTO | Valid-To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | AENNR | Change Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | DELFLG | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 8 | PARKFLG | Data Record Is Inactive | char | 1 | 0 | | | | Allow NULL? |
| 9 | CRDAT | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | CRNAM | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | UPDDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | UPDNAM | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | SRSID | Source of Data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | OWNID | Data Provider | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | | | | Allow NULL? |
| 16 | SUBST_RECN | Internal Substance Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 17 | HOMOGMAT_RECN | Internal Key of Homogeneous Material | nvarchar | 20 | 0 | | | | Allow NULL? |
| 18 | HOMOGMAT_NAME | Homogeneous Material Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 19 | VALUE | Mean Value for Declarable Substance (Homog. Mat) | decimal | 15 | 7 | | | | |
| 20 | VALUEMIN | Minimum Value for Declarable Substance | decimal | 15 | 7 | | | | |
| 21 | VALUEMAX | Maximum Value for Declarable Substance | decimal | 15 | 7 | | | | |
| 22 | VUNIT | Unit of Proportion | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | WEIGHT | Mean Weight of Declarable Substance | decimal | 17 | 7 | | | | |
| 24 | WUNIT | Unit of Mass | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | CONTAINED | Contained Substance | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | REMARK | Remark | nvarchar | 80 | 0 | | | | Allow NULL? |
| 27 | ORIGIN | Source of Declarable Substance | char | 1 | 0 | | | | Allow NULL? |
| 28 | VALUE_IN_PART | Mean Value for Declarable Substance (Part) | decimal | 15 | 7 | | | | |
| 29 | VALUEMIN_IN_PART | Minimum Value for Declarable Substance (Part) | decimal | 15 | 7 | | | | |
| 30 | VALUEMAX_IN_PART | Maximum Value for Declarable Substance (Part) | decimal | 15 | 7 | | | | |
| 31 | PART_VUNIT | Unit of Proportion (Part) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | PART_WEIGHT | Mean Weight of Declarable Substance (Part) | decimal | 17 | 7 | | | | |
| 33 | PART_WUNIT | Unit of Mass (Part) | nvarchar | 3 | 0 | | | | Allow NULL? |
