| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | SYS_NUMBER | Unique System ID from SAPLICENSE | nvarchar | 18 | 0 | CHAR | (N' ') | No | | LAW_SYSID | Allow NULL? |
| 2 | SYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | No | | SYSYSID | Allow NULL? |
| 3 | INSTNO | Installation number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | INSTNUMBER | Allow NULL? |
| 4 | HWKEY | Hardware Key | nvarchar | 11 | 0 | CHAR | (N' ') | No | | HWKEY | Allow NULL? |
| 5 | CUSTOMER_NUMBER | Customer Number of an SAP Customer | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | LAW_CUSTOMER_NUMBER | Allow NULL? |
| 6 | ACTIVE | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 7 | SYSNUM_AVAILABLE | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 8 | ACTIVE_HWKEY | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 9 | SAPREL | Release of SAP System | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SYSAPRL | Allow NULL? |
| 10 | SYSSTATUS | System Status | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | SYSSTAT | Allow NULL? |
| 11 | PATCHLEVEL | Four-digit number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NUM4 | Allow NULL? |
| 12 | PLUGINVERS | Char 20 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CHAR20 | Allow NULL? |
| 13 | LASTACTION | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 14 | VERSTDATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 15 | VERSTTIME | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYUZEIT | Allow NULL? |
| 16 | VERSTRES | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 17 | VERBTDATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 18 | VERBTTIME | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYUZEIT | Allow NULL? |
| 19 | VERBTRES | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 20 | COMP_RFCDEST | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | RFCDES | RFCDEST | Allow NULL? |
| 21 | COMP_SRVUSER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 22 | LAW_RFCDEST | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RFCDEST | Allow NULL? |
| 23 | LAW_SRVUSER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 24 | AUTH_METHOD | Numeric 1-character | char | 1 | 0 | NUMC | (N'0') | Yes | | NUM1 | Allow NULL? |
| 25 | PMODE | Processing Mode | char | 1 | 0 | CHAR | (N' ') | Yes | | PMODE | Allow NULL? |
| 26 | PLUGIN | ABAP Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PROGNAME | Allow NULL? |
| 27 | ERRNUMBER | Four-digit number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NUM4 | Allow NULL? |
| 28 | STATUS_C | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 29 | STATUS_E | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 30 | STATUS_M | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
