| 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 | ESTCAT | Value Assignment Type | nvarchar | 30 | 0 | CHAR | (N' ') | No | | ESEESTCAT | Allow NULL? |
| 3 | ESTTYPE | Value Assignment Category | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG01 | ESEESTTYPE | Allow NULL? |
| 4 | REM | Note | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ESEREM | Allow NULL? |
| 5 | CLS | Allocation: internal class number to char. value | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | KLAH | ESECLSVA | Allow NULL? |
| 6 | CLSPOS | Class number for characteristic items | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | KLAH | ESECLSVP | Allow NULL? |
| 7 | ECCOFLG | Automatic Activation of Copied Value Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEECCOFLG | Allow NULL? |
| 8 | ECINFLG | Automatic Activation of New Value Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEECINFLG | Allow NULL? |
| 9 | ECUPFLG | Automatic Activation of Changed Value Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEECUPFLG | Allow NULL? |
| 10 | USEPROF | Usage Profile | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG96 | ESEUSEPROF | Allow NULL? |
| 11 | IDLID | Identification Listing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG26 | ESEIDLID | Allow NULL? |
| 12 | CLVANAM | Class Name for Value Assignment | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | ESECLVANAM | Allow NULL? |
| 13 | CLVPNAM | (obsolete) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | ESECLVPNAM | Allow NULL? |
| 14 | USEPRDEF | Value Assignment Type Usage Profile Overrides User Profile | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEUSEPRDEF | Allow NULL? |
| 15 | ENTRYF | Initial Entry Function for Screen | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | ESEENTRYF | Allow NULL? |
| 16 | FLGSINST | Only One Instance Permitted for Value Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEFLGSINST | Allow NULL? |
| 17 | FLGINT | Value Assignment Type Is for Internal Purposes | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEFLGINT | Allow NULL? |
| 18 | FLGINV | Inversion of Axes in Value Assignment Table | char | 1 | 0 | CHAR | (N' ') | Yes | | EHS_ESEFLGINV | Allow NULL? |
