| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | RNR | Request ID (Request Number) | nvarchar | 30 | 0 | CHAR | (N' ') | No | | RSREQUID | Allow NULL? |
| 2 | DTA | Data Source or Target for Status Manager | nvarchar | 45 | 0 | CHAR | (N' ') | No | | RSSTATMANDTA | Allow NULL? |
| 3 | DTA_TYPE | Data Target Type | nvarchar | 6 | 0 | CHAR | (N' ') | No | | RSSTATMANDTA_TYPE | Allow NULL? |
| 4 | PROCESS | Process Type | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | RSPC_TYPE | Allow NULL? |
| 5 | RNR_SID | Master data ID | int | 10 | 0 | INT4 | ((0)) | No | | RSSID | Allow NULL? |
| 6 | T_STATUS | Request status (internal display) | nvarchar | 4 | 0 | CHAR | (N' ') | No | | RSSTATUS | Allow NULL? |
| 7 | T_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | RSTIMESTMP | |
| 8 | QM_STATUS | Request status (internal display) | nvarchar | 4 | 0 | CHAR | (N' ') | No | | RSSTATUS | Allow NULL? |
| 9 | QM_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | RSTIMESTMP | |
| 10 | QM_USER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SYUNAME | Allow NULL? |
| 11 | PC_INSTANCE | Process Instance (Value) | nvarchar | 30 | 0 | CHAR | (N' ') | No | | RSPC_INSTANCE | Allow NULL? |
| 12 | PC_VARIANT | Process Variant (Name) | nvarchar | 30 | 0 | CHAR | (N' ') | No | | RSPC_VARIANT | Allow NULL? |
| 13 | PC_LOGID | Log-ID of a Process Chain Run | nvarchar | 25 | 0 | CHAR | (N' ') | No | | RSPC_LOGID | Allow NULL? |
| 14 | TS_PROC_STARTED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | RSTIMESTMP | |
| 15 | TS_PROC_ENDED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | RSTIMESTMP | |
| 16 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | No | | BTCJOB | Allow NULL? |
| 17 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | No | | BTCJOBCNT | Allow NULL? |
| 18 | TS_LAST_CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | RSTIMESTMP | |
| 19 | MSGNO | Message Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SYMSGNO | Allow NULL? |
| 20 | MSGID | Message Class | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | SYMSGID | Allow NULL? |
| 21 | MSGV1 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | No | | SYMSGV | Allow NULL? |
| 22 | MSGV2 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | No | | SYMSGV | Allow NULL? |
| 23 | MSGV3 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | No | | SYMSGV | Allow NULL? |
| 24 | MSGV4 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | No | | SYMSGV | Allow NULL? |