| 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 | USERID | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | USR02 | XUBNAME | Allow NULL? |
| 3 | STATUS_OBJECT | Status Object | nvarchar | 10 | 0 | CHAR | (N' ') | No | ALM_ME_STOBJ | ALM_ME_STATUS_OBJECT | Allow NULL? |
| 4 | ORDERID | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | AUFK | AUFNR | Allow NULL? |
| 5 | ACTIVITY | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | No | | VORNR | Allow NULL? |
| 6 | SUB_ACTIVITY | Suboperation | nvarchar | 4 | 0 | CHAR | (N' ') | No | | UVORN | Allow NULL? |
| 7 | ALM_COUNTER | Device Counter | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ALM_ME_COUNTER | Allow NULL? |
| 8 | FIN_CONF | Partial/Final Confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | AUERU_VS | Allow NULL? |
| 9 | SPLIT | Split number | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | CY_SPLIT | |
| 10 | PERSON | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 11 | WORK_CNTR | Work center | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARBPL | Allow NULL? |
| 12 | PLANPLANT | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | IWERK | Allow NULL? |
| 13 | CREATE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 14 | CREATE_TIME | Time created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CO_INS_TIME | Allow NULL? |
| 15 | LAST_SYNC_DATE | Date of Last Synchronization | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALM_ME_LSYNC_DATE | Allow NULL? |
| 16 | LAST_SYNC_TIME | Last Synchronization Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ALM_ME_LSYNC_TIME | Allow NULL? |
| 17 | RETURN_TYPE | Message type: S Success, E Error, W Warning, I Info, A Abort | char | 1 | 0 | CHAR | (N' ') | Yes | | BAPI_MTYPE | Allow NULL? |
| 18 | RETURN_ID | Message Class | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | T100A | SYMSGID | Allow NULL? |
| 19 | RETURN_NUMBER | Message Number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SYMSGNO | Allow NULL? |
| 20 | RETURN_MSG_V1 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 21 | RETURN_MSG_V2 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 22 | RETURN_MSG_V3 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 23 | RETURN_MSG_V4 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 24 | RETURN_PARAMETER | Parameter Name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BAPI_PARAM | Allow NULL? |
| 25 | ALM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | GUID_32 | Allow NULL? |
| 26 | LOEVM | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM | Allow NULL? |
| 27 | IPHAS | Maintenance Processing Phase | char | 1 | 0 | CHAR | (N' ') | Yes | | PM_PHASE | Allow NULL? |
| 28 | SYS_STAT | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 29 | USR_STAT | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
