| 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 | PROJECT | Project id | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /IXOS/DC_EC_PROJECT | Allow NULL? |
| 3 | VERSION | Version of a project | nvarchar | 2 | 0 | NUMC | (N'00') | No | | /IXOS/DC_EC_VERSION | Allow NULL? |
| 4 | DATASOURCE | Attribute object | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | /IXOS/DC_EC_DATASOURCE | Allow NULL? |
| 5 | USERGROUP | User group | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | /IXOS/DC_EA_USERGROUP | Allow NULL? |
| 6 | SEPHITLFLAG | Flag for separate hit list | char | 1 | 0 | CHAR | (N' ') | No | | /IXOS/DC_EC_SEPHITLFLAG | Allow NULL? |
| 7 | FIELDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FIELDNAME | Allow NULL? |
| 8 | TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 9 | SELECTTEXT | Choose the text type to be used | char | 1 | 0 | CHAR | (N' ') | No | | /IXOS/DC_EC_SELECTTEXT | Allow NULL? |
| 10 | FIELDALIGN | Alignment in Hitlist (left, center, right) | char | 1 | 0 | CHAR | (N' ') | Yes | | /IXOS/DC_EA_POSITION_HITLIST | Allow NULL? |
| 11 | OUTPUTLEN | Output Length | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | OUTPUTLEN | Allow NULL? |
| 12 | SCRLEN1 | Max. length for short field label | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SCRLEN_S | Allow NULL? |
| 13 | SCRLEN2 | Max. length for medium field label | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SCRLEN_M | Allow NULL? |
| 14 | SCRLEN3 | Max. length for long field label | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SCRLEN_L | Allow NULL? |
| 15 | SORTING | Sort type for hitlist fields | char | 1 | 0 | CHAR | (N' ') | Yes | | /IXOS/DC_EC_SORTING | Allow NULL? |
| 16 | SORTORDER | Sort sequence of fields in hitlist | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /IXOS/DC_EA_SORTORDER | Allow NULL? |
| 17 | FIELDSEL | Flag for field selection | char | 1 | 0 | CHAR | (N' ') | Yes | | /IXOS/DC_EA_VISIBLE | Allow NULL? |
| 18 | FIELDPOS | Position of fields in administration | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /IXOS/DC_EA_POSITION | Allow NULL? |
| 19 | DATATYPE | ABAP/4 Dictionary: Screen data type for Screen Painter | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DYNPTYPE | Allow NULL? |
| 20 | INTTYPE | ABAP data type (C,D,N,...) | char | 1 | 0 | CHAR | (N' ') | Yes | | INTTYPE | Allow NULL? |
| 21 | REFTABLE | Table for reference field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFTABLE | Allow NULL? |
| 22 | REFFIELD | Reference field for currency and qty fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFFIELD | Allow NULL? |
| 23 | CONVEXIT | Conversion Routine | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | CONVEXIT | Allow NULL? |
| 24 | KEYFLAG | Identifies a key field of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | KEYFLAG | Allow NULL? |
| 25 | FIELDSUM | Sum of fields in Hitlist | char | 1 | 0 | CHAR | (N' ') | Yes | | /IXOS/DC_EA_FIELDSUM | Allow NULL? |
