| 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 | VIEWTYPE | View Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | | NVIEWTYPE | Allow NULL? |
| 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | CHAR | (N' ') | No | NWVIEW | NVIEWID | Allow NULL? |
| 4 | USERTYPE | IS-H: User Type (esp. for Views) | char | 1 | 0 | CHAR | (N' ') | No | | NUSERTYPE | Allow NULL? |
| 5 | USERNAME | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | XUBNAME | Allow NULL? |
| 6 | COUNTER | IS-H: 10-Digit Number, Special for Sequence Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ISH_COUNTER | Allow NULL? |
| 7 | TCCONTROL | Name of table control in the program | nvarchar | 30 | 0 | CHAR | (N' ') | No | | TCCONTROL | Allow NULL? |
| 8 | TCVERSION | Variant of a user setting for tables | nvarchar | 20 | 0 | CHAR | (N' ') | No | | TCVERSION | Allow NULL? |
| 9 | TCKONTEXT | Application context of a table control | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TCKONTEXT | Allow NULL? |
| 10 | FIELDNAME | Field name | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | FNAM_____4 | Allow NULL? |
| 11 | FIELDVALUE | IS-H: General Field for Field Values | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ISH_FIELDVALUE | Allow NULL? |
| 12 | FIELDHOLD | Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_SIGN1 | Allow NULL? |
| 13 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 14 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 15 | ERTIM | IS-H: Time Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_ERTIM | Allow NULL? |
| 16 | LSTDP | IS-H: Display Method Last Used | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_LSTDP | Allow NULL? |
