| 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 | T000 | MANDT | Allow NULL? |
| 2 | RECN | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESERECN | Allow NULL? |
| 3 | ACTN | Sequential Number of the Change State | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESEACTN | Allow NULL? |
| 4 | VALFR | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALFR | Allow NULL? |
| 5 | VALTO | Valid-To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALTO | Allow NULL? |
| 6 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AENR | ESEAENNR | Allow NULL? |
| 7 | DELFLG | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEDELFLG | Allow NULL? |
| 8 | PARKFLG | Data Record Is Inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEPARKFLG | Allow NULL? |
| 9 | CRDAT | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESECRDAT | Allow NULL? |
| 10 | CRNAM | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESECRNAM | Allow NULL? |
| 11 | UPDDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEUPDDAT | Allow NULL? |
| 12 | UPDNAM | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESEUPDNAM | Allow NULL? |
| 13 | SRSID | Source of Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG56 | ESESRSID | Allow NULL? |
| 14 | OWNID | Data Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESEVENDRID | Allow NULL? |
| 15 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECN | Allow NULL? |
| 16 | REGLIST_DEP | Regulatory/Customer List | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | EHFNDC_SREG | EHFND_REGLIST | Allow NULL? |
| 17 | PART_RECN_DEP | Internal Key of Part | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | EHPRC_PART_RECN | Allow NULL? |
| 18 | PART_NAME_DEP | Part Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EHPRC_PART_NAME | Allow NULL? |
| 19 | VALUE_P_DEP | Mean Value for Declarable Substance (Part) | decimal | 15 | 7 | QUAN | ((0)) | Yes | | EHPRC_DECSVAVG_PART | |
| 20 | VALUEMIN_P_DEP | Minimum Value for Declarable Substance (Part) | decimal | 15 | 7 | QUAN | ((0)) | Yes | | EHPRC_DECSVMIN_PART | |
| 21 | VALUEMAX_P_DEP | Maximum Value for Declarable Substance (Part) | decimal | 15 | 7 | QUAN | ((0)) | Yes | | EHPRC_DECSVMAX_PART | |
| 22 | VUNIT_DEP | Unit of Proportion (Part) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | EHPRC_PROP_UNIT_PART | Allow NULL? |
| 23 | PART_WEIGHT_DEP | Mean Weight of Declarable Substance (Part) | decimal | 17 | 7 | QUAN | ((0)) | Yes | | EHPRC_DECSMAVG_PART | |
| 24 | PART_WUNIT_DEP | Unit of Mass (Part) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | EHPRC_MASS_UNIT_PART | Allow NULL? |
| 25 | EXEMPTION_DEP | Exemption | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | EHPRC_EXEMPT | Allow NULL? |
| 26 | CLASS_DEP | Classification for Compliance | char | 1 | 0 | CHAR | (N' ') | Yes | EHPRCC_CLASS | EHPRC_CLASSIFICATION | Allow NULL? |
| 27 | ORIGIN_DEP | Source of Declarable Substance | char | 1 | 0 | CHAR | (N' ') | Yes | | EHPRC_DECSORIGIN | Allow NULL? |
| 28 | RECN_INDEP | | nvarchar | 20 | 0 | | (N'00000000000000000000') | Yes | | | Allow NULL? |
| 29 | FLG_AGAINST_PART | Check Against Part | char | 1 | 0 | CHAR | (N' ') | Yes | | EHPRC_AGAINST_PART | Allow NULL? |
| 30 | FLG_GROUP | Truth Value | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEBOOLE | Allow NULL? |
| 31 | GROUP_ID | Alternative Group ID | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | EHPRC_ALTGROUP_ID | Allow NULL? |
| 32 | FLG_GROUP_ALT | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
