| 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 | WPLACETYPE | Type of the Work Environment | nvarchar | 3 | 0 | CHAR | (N' ') | No | | NWPLACETYPE | Allow NULL? |
| 3 | WPLACEID | Identification of the Work Environment | nvarchar | 40 | 0 | CHAR | (N' ') | No | | NWPLACEID | Allow NULL? |
| 4 | AGR_NAME | Role Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | AGR_NAME | Allow NULL? |
| 5 | BENUTZER | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | XUBNAME | Allow NULL? |
| 6 | DEFAVTYPE | Type of the Work Environment | nvarchar | 3 | 0 | CHAR | (N' ') | No | | NWPLACETYPE | Allow NULL? |
| 7 | DEFAVID | Identification of the Work Environment | nvarchar | 40 | 0 | CHAR | (N' ') | No | | NWPLACEID | Allow NULL? |
| 8 | NAVTREE | IS-H: Boolean Data Type for ON (= "X") and OFF (= " ") | char | 1 | 0 | CHAR | (N' ') | No | | ISH_ON_OFF | Allow NULL? |
| 9 | TREESIZE | IS-H: Extension of a Control | int | 10 | 0 | INT4 | ((0)) | No | | ISH_CTRL_SIZE | Allow NULL? |
| 10 | TREESPLIT | IS-H: Item Number (Integer) | tinyint | 3 | 0 | INT1 | ((0)) | No | | ISH_POS_INT1 | |
| 11 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | | RI_ERNAM | Allow NULL? |
| 12 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RI_ERDAT | Allow NULL? |
| 13 | ERTIM | IS-H: Time Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | RI_ERTIM | Allow NULL? |
| 14 | SUPDEF | SAP Standard Variant Hidden (ON/OFF) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_SUPPRESS_SAPDEF | Allow NULL? |
