| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 2 | MODEFLAG | Activation flag | char | 1 | 0 | CHAR | (N' ') | No | | ACTFLAG | Allow NULL? |
| 3 | POSITION | Position of the field in the table | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | TABFDPOS | Allow NULL? |
| 4 | FLAG1 | Flag 1 length 1 byte for field attributes | varbinary | 1 | 0 | RAW | | Yes | | FDFLAG1 | |
| 5 | FLAG2 | Flag 2 length 1 byte for field attributes | varbinary | 1 | 0 | RAW | | Yes | | FDFLAG2 | |
| 6 | FLAG3 | Flag 1 length 1 byte for field attributes | varbinary | 1 | 0 | RAW | | Yes | | FDFLAG1 | |
| 7 | FLAG4 | Flag 2 length 1 byte for field attributes | varbinary | 1 | 0 | RAW | | Yes | | FDFLAG2 | |
| 8 | DBTABPOS | Position number of table field in database | varbinary | 2 | 0 | RAW | | Yes | | FLPOS | |
| 9 | FIELDTYPE | ABAP data type (coded) | varbinary | 1 | 0 | RAW | | Yes | | FLDTYPE | |
| 10 | OFFSET | Table field offset | varbinary | 4 | 0 | RAW | | Yes | | ROFFSET | |
| 11 | DBLENGTH | Length of field in ABAP | varbinary | 2 | 0 | RAW | | Yes | | DBLENGTH | |
| 12 | DBLENGTH2 | ABAP Dictionary: Length on Database | varbinary | 4 | 0 | RAW | | Yes | | DBLENGTH2 | |
| 13 | EXLENGTH | Field output length | varbinary | 2 | 0 | RAW | | Yes | | OUTLENGTH | |
| 14 | DECIMALS | Number of decimal places in the field | varbinary | 1 | 0 | RAW | | Yes | | INTDECIM | |
| 15 | DEPTH | Depth in nested structures | varbinary | 1 | 0 | RAW | | Yes | | DDDEPTH | |
| 16 | FLDALIGN | Alignment of types with different pointer lengths | varbinary | 1 | 0 | RAW | | Yes | | FLDALIGN | |
| 17 | FIELDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIELDNAME | Allow NULL? |
| 18 | ROLLNAME | Data element (semantic domain) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ROLLNAME | Allow NULL? |
| 19 | ABTYPE | ABAP data type (nametab interface coded) | varbinary | 1 | 0 | RAW | | Yes | | ABTYPE | |
| 20 | DTYP | Data Type in ABAP Dictionary | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DATATYPE_D | Allow NULL? |
| 21 | EXID | ABAP data type (C,D,N,...) | char | 1 | 0 | CHAR | (N' ') | Yes | | INTTYPE | Allow NULL? |
| 22 | REFTABLE | Table for reference field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFTABLE | Allow NULL? |
| 23 | REFFIELD | Reference field for currency and qty fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFFIELD | Allow NULL? |
| 24 | PRECFIELD | Internal precision | varbinary | 2 | 0 | RAW | | Yes | | PRECINTERN | |
| 25 | CONVEXIT | Conversion Routine | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | CONVEXIT | Allow NULL? |
| 26 | MEMORYID | Set/Get parameter ID | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | MEMORYID | Allow NULL? |
| 27 | CHECKTABLE | Check table name of the foreign key | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CHECKTABLE | Allow NULL? |
| 28 | DIGITS | Dictionary length for DEC, CURR, QUAN types | varbinary | 2 | 0 | RAW | | Yes | | DDINTLENG | |
