| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | CASENR | Clarification Case | nvarchar | 10 | 0 | CHAR | (N' ') | No | EMMA_CASE | EMMA_CNR | Allow NULL? |
| 3 | SEQNR | Sequence Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | EMMA_SEQNR | Allow NULL? |
| 4 | XPROCA | Automatic Solution Process | char | 1 | 0 | CHAR | (N' ') | Yes | | EMMA_PROCAUT | Allow NULL? |
| 5 | OBJTYPE | Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SWO_OBJTYP | Allow NULL? |
| 6 | METHOD | Method | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SWO_METHOD | Allow NULL? |
| 7 | WFTASKTYP | Task type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | EWC_TASK_TP | Allow NULL? |
| 8 | WFTASKID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | HROBJID | Allow NULL? |
| 9 | ABOX_CONF | Action Box configuration | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | EWF_CONFIG | Allow NULL? |
| 10 | ABOX_CALLID | Code of an Action Box transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EWF_CALLID | Allow NULL? |
| 11 | CLSNAM | Object Type | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SWF_CLSNAM | Allow NULL? |
| 12 | CLSMET | Workflow: Method Name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SWF_CLSMET | Allow NULL? |
| 13 | SOPTXTID | Name of Solution Process | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EMMAC_SOPTXTID | EMMA_SOPTXTID | Allow NULL? |
| 14 | ICON | Icon in text fields (substitute display, alias) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ICON | ICON_D | Allow NULL? |
| 15 | PROCEX_DATE | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 16 | PROCEX_TIME | Time last change was made | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZET | Allow NULL? |
| 17 | PROCEX_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 18 | XEXECCTRL | Release of Solution Process Execution | char | 1 | 0 | CHAR | (N' ') | Yes | | EMMA_PROCAUT_MODE | Allow NULL? |
| 19 | PROCEX_STATUS | Execution Status of Solution Process | char | 1 | 0 | CHAR | (N' ') | Yes | | EMMA_PROCEX_STATUS | Allow NULL? |
| 20 | XPROCM | Multiple Execution of Automatic Solution Process Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | EMMA_PROCAUT_MULTIPLE | Allow NULL? |
| 21 | XPROCL | Logging of Execution of Automatic Solution Process | char | 1 | 0 | CHAR | (N' ') | Yes | | EMMA_PROCAUT_LOG | Allow NULL? |
| 22 | SOP_GUID | GUID of Solution Process | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | EMMA_SOPGUID | Allow NULL? |