| 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 | WLITEM | TSW: Worklist item number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | OIJ_WLITEM | Allow NULL? |
| 3 | WLRC | TSW: Worklist reason code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | OIJWLRCN | OIJ_WLRC | Allow NULL? |
| 4 | TSYST | Transport system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | OIJTS | OIJ_TSYST | Allow NULL? |
| 5 | LOCID | Location ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | OIJLOC | OIJ_LOCID | Allow NULL? |
| 6 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 7 | NOMNR | Nomination number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | OIJ_NOMNR | Allow NULL? |
| 8 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIJNOMH | OIJ_NOMTK | Allow NULL? |
| 9 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | OIJNOMI | OIJ_ITEM | Allow NULL? |
| 10 | PTSYST | Transport system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIJ_TSYST | Allow NULL? |
| 11 | PLOCID | Location ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIJ_LOCID | Allow NULL? |
| 12 | DATUM | TSW: Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIJ_DATUM | Allow NULL? |
| 13 | SITYP | Schedule type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TOIJ_EL_SITYPES | OIJ_SITYP | Allow NULL? |
| 14 | TKONN | Trading Contract: Trading Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TKONN | Allow NULL? |
| 15 | TPOSN | Trading Contract: Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | TPOSN | Allow NULL? |
| 16 | VBTYP | TSW Details document type | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_EL_VBTYP | Allow NULL? |
| 17 | WARN | TSW: Reason code warning indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_WARN | Allow NULL? |
| 18 | DELET | TSW: Worklist item deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_DELET | Allow NULL? |
| 19 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 20 | ERZEIT | Time of creation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_ERTIM | Allow NULL? |
| 21 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 22 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 23 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_AETIM | Allow NULL? |
| 24 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 25 | BLOIND | Blocking indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_BLOIND | Allow NULL? |
| 26 | DELIND | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_DELIND | Allow NULL? |
