| 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 | TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 5 | FIELDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FIELDNAME | Allow NULL? |
| 6 | LANGU | Language Key | char | 1 | 0 | LANG | (N' ') | No | * | DDLANGUAGE | Allow NULL? |
| 7 | DOMNAME | Domain name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | DOMNAME | Allow NULL? |
| 8 | ROLLNAME | Data element (semantic domain) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ROLLNAME | Allow NULL? |
| 9 | CHECKTABLE | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TABNAME | Allow NULL? |
| 10 | LENG | Length (No. of Characters) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | DDLENG | Allow NULL? |
| 11 | INTLEN | Internal Length in Bytes | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | INTLEN | Allow NULL? |
| 12 | OUTPUTLEN | Output Length | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | OUTPUTLEN | Allow NULL? |
| 13 | DECIMALS | Number of Decimal Places | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | DECIMALS | Allow NULL? |
| 14 | DATATYPE | ABAP/4 Dictionary: Screen data type for Screen Painter | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DYNPTYPE | Allow NULL? |
| 15 | INTTYPE | ABAP data type (C,D,N,...) | char | 1 | 0 | CHAR | (N' ') | Yes | | INTTYPE | Allow NULL? |
| 16 | REFTABLE | Table for reference field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFTABLE | Allow NULL? |
| 17 | REFFIELD | Reference field for currency and qty fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFFIELD | Allow NULL? |
| 18 | PRECFIELD | Name of included table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | PRECFIELD | Allow NULL? |
| 19 | AUTHORID | Authorization class | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | AUTHORID | Allow NULL? |
| 20 | MEMORYID | Set/Get parameter ID | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | MEMORYID | Allow NULL? |
| 21 | LOGFLAG | Indicator for writing change documents | char | 1 | 0 | CHAR | (N' ') | Yes | | LOGFLAG | Allow NULL? |
| 22 | MASK | Template (not used) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AS4MASK | Allow NULL? |
| 23 | MASKLEN | Template length (not used) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MASKLEN | Allow NULL? |
| 24 | CONVEXIT | Conversion Routine | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | CONVEXIT | Allow NULL? |
| 25 | HEADLEN | Maximum length of heading | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | HEADLEN | Allow NULL? |
| 26 | SCRLEN1 | Max. length for short field label | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SCRLEN_S | Allow NULL? |
| 27 | SCRLEN2 | Max. length for medium field label | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SCRLEN_M | Allow NULL? |
| 28 | SCRLEN3 | Max. length for long field label | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SCRLEN_L | Allow NULL? |
| 29 | FIELDTEXT | Short Description of Repository Objects | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AS4TEXT | Allow NULL? |
| 30 | REPTEXT | Heading | nvarchar | 55 | 0 | CHAR | (N' ') | Yes | | REPTEXT | Allow NULL? |
| 31 | SCRTEXT_S | Short Field Label | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SCRTEXT_S | Allow NULL? |
| 32 | SCRTEXT_M | Medium Field Label | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SCRTEXT_M | Allow NULL? |
| 33 | SCRTEXT_L | Long Field Label | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SCRTEXT_L | Allow NULL? |
| 34 | KEYFLAG | Identifies a key field of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | KEYFLAG | Allow NULL? |
| 35 | LOWERCASE | Lowercase letters allowed/not allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | LOWERCASE | Allow NULL? |
| 36 | MAC | Flag if search help is attached to the field | char | 1 | 0 | CHAR | (N' ') | Yes | | DDSHATTACH | Allow NULL? |
| 37 | GENKEY | Flag (X or Blank) | char | 1 | 0 | CHAR | (N' ') | Yes | | AS4FLAG | Allow NULL? |
| 38 | NOFORKEY | Flag (X or Blank) | char | 1 | 0 | CHAR | (N' ') | Yes | | AS4FLAG | Allow NULL? |
| 39 | VALEXI | Existence of fixed values | char | 1 | 0 | CHAR | (N' ') | Yes | | VALEXI | Allow NULL? |
| 40 | NOAUTHCH | Flag (X or Blank) | char | 1 | 0 | CHAR | (N' ') | Yes | | AS4FLAG | Allow NULL? |
| 41 | SIGN | Flag for sign in numerical fields | char | 1 | 0 | CHAR | (N' ') | Yes | | SIGNFLAG | Allow NULL? |
| 42 | DYNPFLD | Flag: field to be displayed on the screen | char | 1 | 0 | CHAR | (N' ') | Yes | | DYNPROFLD | Allow NULL? |
| 43 | F4AVAILABL | Does the field have an input help | char | 1 | 0 | CHAR | (N' ') | Yes | | DDF4AVAIL | Allow NULL? |
| 44 | COMPTYPE | DD: Component Type | char | 1 | 0 | CHAR | (N' ') | Yes | | COMPTYPE | Allow NULL? |
| 45 | LFIELDNAME | Field name | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | FNAM_____4 | Allow NULL? |
