| 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 | RELID | Version Number Component | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CHAR2 | Allow NULL? |
| 3 | MEMORY_ID | Buffer ID for Access to EH&S Expert | nvarchar | 22 | 0 | CHAR | (N' ') | No | | EHSBE_RC_BUFFER_ID | Allow NULL? |
| 4 | SRTF2 | Natural Number | int | 10 | 0 | INT4 | ((0)) | No | | INT4 | Allow NULL? |
| 5 | RECN | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECN | Allow NULL? |
| 6 | ACTN | Sequential Number of the Change State | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESEACTN | Allow NULL? |
| 7 | VALFR | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALFR | Allow NULL? |
| 8 | VALTO | Valid-To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALTO | Allow NULL? |
| 9 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AENR | ESEAENNR | Allow NULL? |
| 10 | DELFLG | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEDELFLG | Allow NULL? |
| 11 | PARKFLG | Data Record Is Inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEPARKFLG | Allow NULL? |
| 12 | CRDAT | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESECRDAT | Allow NULL? |
| 13 | CRNAM | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESECRNAM | Allow NULL? |
| 14 | UPDDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEUPDDAT | Allow NULL? |
| 15 | UPDNAM | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESEUPDNAM | Allow NULL? |
| 16 | SRSID | Source of Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG56 | ESESRSID | Allow NULL? |
| 17 | OWNID | Data Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESEVENDRID | Allow NULL? |
| 18 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECN | Allow NULL? |
| 19 | UPDDATS | Date of Last Change to Specification As a Whole | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEUPDDATS | Allow NULL? |
| 20 | UPDNAMS | Name of Person Who Last Changed Specification | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESEUPDNAMS | Allow NULL? |
| 21 | SUBID | Specification | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESESUBID | Allow NULL? |
| 22 | SUBCAT | Specification Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESESUBCAT | Allow NULL? |
| 23 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESEAUTHGRP | Allow NULL? |
| 24 | REM | Note | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ESEREM | Allow NULL? |
| 25 | SUBCHAR | Identification of Substance Nature | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESESUBCHAR | Allow NULL? |
| 26 | CLUSTR | 2 byte integer (signed) | smallint | 5 | 0 | INT2 | ((0)) | Yes | | INT2 | |
| 27 | CLUSTD | Data cluster, maximum length 300 | varbinary | 300 | 0 | LRAW | | Yes | | LRAW0300 | |
