| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 2 | STREE | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | GUID_22 | Allow NULL? |
| 3 | FDDIC | origin of DDIC info of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | DMC_DDIC_ORIGIN | Allow NULL? |
| 4 | DDICNAME | Name of an ABAP Dictionary object | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | DDNAME | Allow NULL? |
| 5 | TABCLASS | Table category | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | TABCLASS | Allow NULL? |
| 6 | IDENT | Tree Structure ID | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | DMC_STIDT | Allow NULL? |
| 7 | CHNAM | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 8 | CHANGEDATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 9 | VERSIO | Version Number of Objects | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | DMC_VERSIO | Allow NULL? |
| 10 | AUTHOR | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 11 | CREATEDATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 12 | DESCR | Description | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | DMC_DESCR | Allow NULL? |
| 13 | AS4TIME | Last changed at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AS4TIME | Allow NULL? |
| 14 | AS4DATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AS4DATE | Allow NULL? |
| 15 | TECHNICAL | DMC: Flag if structure or field is technical or not | char | 1 | 0 | CHAR | (N' ') | Yes | | DMC_TECHN | Allow NULL? |
| 16 | USES_STRINGS | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 17 | APPL_INSERT | MWB: Application Insert (Yes/No) | char | 1 | 0 | CHAR | (N' ') | Yes | | DMC_APPL_INSERT | Allow NULL? |
| 18 | READONLY | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 19 | UC_CODEPAGE | SAP Character Set ID | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | CPCODEPAGE | Allow NULL? |
| 20 | TYPING_CLASS | DMC: Indicator for type class (TTYP, REF, STRUC,...) | char | 1 | 0 | CHAR | (N' ') | Yes | | DMC_TYPING | Allow NULL? |
| 21 | USES_LRAW | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |