| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PROCESS_ID | Process ID | nvarchar | 34 | 0 | | | | Allow NULL? |
| 3 | WORKITEM_ID | Work item ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | WORKITEM_GROUP | Work item group | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | WITEXT | Work Item Text | nvarchar | 120 | 0 | | | | Allow NULL? |
| 6 | CREATED_BY | Create-User | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | WF_FINISHED | Work Item Finished? | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | TIMESTAMP | Created On | nvarchar | 14 | 0 | | | | Allow NULL? |
| 9 | FINISHED_AT | Ended on | nvarchar | 14 | 0 | | | | Allow NULL? |
| 10 | DURATION | Duration in Seconds | decimal | 31 | 0 | | | | |
| 11 | DURATION_TEXT | Duration | nvarchar | 64 | 0 | | | | Allow NULL? |
| 12 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | STATUS | Approval status | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | STATUS_D | Approval status: Text | nvarchar | 30 | 0 | | | | Allow NULL? |
| 15 | APPROVER | Approver | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | CATEGORY | Category | nvarchar | 15 | 0 | | | | Allow NULL? |
| 17 | CATEGORY_D | Category: Text | nvarchar | 20 | 0 | | | | Allow NULL? |
| 18 | COST_CENTER | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | PSPNR | WBS Element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | PO_NUMBER | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | PO_ITEM | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | AUFNR | Order Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | GL_ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | ASSET_NO | Main Asset Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | ASSET_SUB_NO | Asset Subnumber | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | F_COST_CENTER | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 27 | F_PSPNR | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 28 | F_PO_NUMBER | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 29 | F_PO_ITEM | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 30 | F_AUFNR | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 31 | F_GL_ACCOUNT | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 32 | F_ASSET_NO | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 33 | F_ASSET_SUB_NO | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 34 | F_OTHERS | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 35 | TEXT_XML | | ntext | 1073741823 | 0 | | | | |
| 36 | COMM_CURR_XML | | ntext | 1073741823 | 0 | | | | |
| 37 | APPROVER_XML | | ntext | 1073741823 | 0 | | | | |
