| 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 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | CHAR | (N' ') | No | | WCEWCNR | Allow NULL? |
| 3 | LSTID | Operational List | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | WCELSTID | Allow NULL? |
| 4 | WCITM | Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | WCEITM | Allow NULL? |
| 5 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | J_OBJNR | Allow NULL? |
| 6 | ITMTYP | Item Category | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEITMTYP | Allow NULL? |
| 7 | SEQ | Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | WCEITMSEQ | Allow NULL? |
| 8 | PRED | Predecessor | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | WCEPREDITM | Allow NULL? |
| 9 | SUCC | Successor | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | WCESUCCITM | Allow NULL? |
| 10 | CCOBJ | Technical Object | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WCECCOBJ | Allow NULL? |
| 11 | CCTYP | Item Category | char | 1 | 0 | CHAR | (N' ') | Yes | | WCECCTYP | Allow NULL? |
| 12 | CCOBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 13 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WCESTXT | Allow NULL? |
| 14 | TGGRP | Operational Group | char | 1 | 0 | CHAR | (N' ') | Yes | WCCA | WCETGGRP | Allow NULL? |
| 15 | TGSTEP | Operational Step for Tagging | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | WCETGSTEP | Allow NULL? |
| 16 | TGPROC | Tagging Condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | WCCA | WCETGPROC | Allow NULL? |
| 17 | TGTYP | Tagging Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | WCCC | WCETGTYP | Allow NULL? |
| 18 | TGSEQ | Sequence for Tagging | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | WCETGSEQ | Allow NULL? |
| 19 | TGTXT | Comment Line for Tagging | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WCETGCOMMENT | Allow NULL? |
| 20 | UNSTEP | Operational Step for Untagging | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | WCEUNSTEP | Allow NULL? |
| 21 | UNPROC | Untagging Condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | WCCA | WCEUNPROC | Allow NULL? |
| 22 | UNTYP | Untagging Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | WCCC | WCEUNTYP | Allow NULL? |
| 23 | UNSEQ | Sequence for Untagging | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | WCEUNSEQ | Allow NULL? |
| 24 | UNTXT | Comment Line for Untagging | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WCEUNCOMMENT | Allow NULL? |
| 25 | PHBLFLG | Physical Blocking Required | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEPHBLFLG | Allow NULL? |
| 26 | PHBLTYP | Physical Blocking Type | char | 1 | 0 | CHAR | (N' ') | Yes | WCCV | WCEPHBLTYP | Allow NULL? |
| 27 | PHBLNR | Lock | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | WCEPHBLNR | Allow NULL? |
| 28 | TGFLG | Tag Required | char | 1 | 0 | CHAR | (N' ') | Yes | | WCETAGFLG | Allow NULL? |
| 29 | TGFORM | Print Format for Tag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | WCCL | WCETGFORM | Allow NULL? |
| 30 | TGNR | Tag | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | WCETGNR | Allow NULL? |
| 31 | UNFORM | Print Format for Test Tag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | WCCL | WCEUNFORM | Allow NULL? |
| 32 | UNNR | Test Tag | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | WCEUNNR | Allow NULL? |
| 33 | CONTROL | Switching Location | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WCECTRL | Allow NULL? |
| 34 | LOCATION | Location | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WCELOC | Allow NULL? |
| 35 | LFLG | Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | WCELTXTFLG | Allow NULL? |
| 36 | DOCFLG | Linked to Document | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEDOCFLG | Allow NULL? |
| 37 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | WCEREFOBJ | Allow NULL? |
| 38 | SYSST | Display lines for system status | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ILOM_STTXS | Allow NULL? |
| 39 | USRST | Display lines for user status | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ILOM_STTXU | Allow NULL? |
| 40 | ACTSTEP | Operational Step | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | WCEACTSTEP | Allow NULL? |
| 41 | ACTPROC | Operational Condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | WCEACTPROC | Allow NULL? |
| 42 | ACTTYP | Operational Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | WCEACTTYP | Allow NULL? |
| 43 | DISPFLG | Display | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEDISPFLG | Allow NULL? |
| 44 | UPDFLG | Change | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEUPDFLG | Allow NULL? |
| 45 | CTRLFLG1 | Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEFLG | Allow NULL? |
| 46 | CTRLFLG2 | Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEFLG | Allow NULL? |
| 47 | CTRLFLG3 | Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WCEFLG | Allow NULL? |
| 48 | COMPLETED | Processing Status | char | 1 | 0 | NUMC | (N'0') | Yes | | WCECOMPLETED | Allow NULL? |
| 49 | STATUS | Status | char | 1 | 0 | CHAR | (N' ') | Yes | | WCESTATUS | Allow NULL? |
| 50 | STEP | Flow Step | char | 1 | 0 | CHAR | (N' ') | Yes | | WCESTEP | Allow NULL? |
| 51 | FEEDBACK | Comment of the Technician On Site | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WCEFEEDBACK | Allow NULL? |
| 52 | CHNAME | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | WCECHNAME | Allow NULL? |
| 53 | CHDATE | Date on Which Object was Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WCECHDATE | Allow NULL? |
| 54 | CHTIME | Time at Which Object was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | WCECHTIME | Allow NULL? |