SAP ABAP Table SWWARCH_1 (Structure for WORKITEM_SOOD_REC from FG SWWX)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-BMT-WFM (Application Component) SAP Business Workflow
⤷ SWW (Package) Business Workflow: Work Items
⤷ BC-BMT-WFM (Application Component) SAP Business Workflow
⤷ SWW (Package) Business Workflow: Work Items
Basic Data
Table Category | INTTAB | Structure |
Structure | SWWARCH_1 | Table Relationship Diagram |
Short Description | Structure for WORKITEM_SOOD_REC from FG SWWX |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | ARCH_INST | SYTABIX | SYST_LONG | INT4 | 10 | 0 | Row Index of Internal Tables | ||
2 | .INCLUDE | 0 | 0 | Sood for Archiving of WI Attachments | |||||
3 | WI_ID | SWW_WIID | SWW_WIID | NUMC | 12 | 0 | Work item ID | * | |
4 | SOFM_KEY | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
5 | .INCLUDE | 0 | 0 | SAPoffice: Object definition | |||||
6 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
7 | OBJTP | SO_OBJ_TP | SO_OBJ_TP | CHAR | 3 | 0 | Code for document class | TSOTD | |
8 | OBJYR | SO_OBJ_YR | SO_OBJ_YR | CHAR | 2 | 0 | Object: Year from ID | ||
9 | OBJNO | SO_OBJ_NO | SO_OBJ_NO | CHAR | 12 | 0 | Object: Number from ID | * | |
10 | OBJLA | SO_OBJ_LA | SPRAS | LANG | 1 | 0 | Language in Which Document Is Created | T002 | |
11 | OBJSRT | SO_OBJ_SRT | SO_OBJ_SRT | CHAR | 10 | 0 | Sort field | ||
12 | OBJNAM | SO_OBJ_NAM | SO_OBJ_NAM | CHAR | 12 | 0 | Name of document, folder or distribution list | ||
13 | OBJDES | SO_OBJ_DES | SO_OBJ_DES | CHAR | 50 | 0 | Short description of contents | ||
14 | OWNTP | SO_OWN_TP | SO_OBJ_TP | CHAR | 3 | 0 | Owner type from ID | TSOTD | |
15 | OWNYR | SO_OWN_YR | SO_OBJ_YR | CHAR | 2 | 0 | Owner year from the ID | ||
16 | OWNNO | SO_OWN_NO | SO_OBJ_NO | CHAR | 12 | 0 | Owner number from the ID | * | |
17 | OWNNAM | SO_OWN_NAM | USERNAME | CHAR | 12 | 0 | Name of document owner | ||
18 | CROTP | SO_CRO_TP | SO_OBJ_TP | CHAR | 3 | 0 | User who created object: Object type from ID | TSOTD | |
19 | CROYR | SO_CRO_YR | SO_OBJ_YR | CHAR | 2 | 0 | User that created object: year from the ID | ||
20 | CRONO | SO_CRO_NO | SO_OBJ_NO | CHAR | 12 | 0 | User that created object: number from the ID | * | |
21 | CRONAM | SO_CRO_NAM | USERNAME | CHAR | 12 | 0 | Creator Name | ||
22 | CRDAT | SO_DAT_CR | DATUM | DATS | 8 | 0 | Date created | ||
23 | CRTIM | SO_TIM_CR | UZEIT | TIMS | 6 | 0 | Time created | ||
24 | CHOTP | SO_CHO_TP | SO_OBJ_TP | CHAR | 3 | 0 | User that changed the object: Object type from ID | TSOTD | |
25 | CHOYR | SO_CHO_YR | SO_OBJ_YR | CHAR | 2 | 0 | User that changed the object: year from the ID | ||
26 | CHONO | SO_CHO_NO | SO_OBJ_NO | CHAR | 12 | 0 | User that changed the object: number from the ID | * | |
27 | CHONAM | SO_CHO_NAM | USERNAME | CHAR | 12 | 0 | Changed by | ||
28 | CHDAT | SO_DAT_CH | DATUM | DATS | 8 | 0 | Date of Last Change | ||
29 | CHTIM | SO_TIM_CH | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
30 | NOTTP | SO_NOT_TP | SO_OBJ_TP | CHAR | 3 | 0 | Default setting of document class | TSOTD | |
31 | NOTYR | SO_NOT_YR | SO_OBJ_YR | CHAR | 2 | 0 | Object note: year from the ID | ||
32 | NOTNO | SO_NOT_NO | SO_OBJ_NO | CHAR | 12 | 0 | Object note: number from the ID | * | |
33 | OBJAPP | SO_OBJ_APP | SO_FLAG | CHAR | 1 | 0 | Application object | ||
34 | OBJFIL | SO_OBJ_FIL | SO_FLAG | CHAR | 1 | 0 | Object from SAPfile | ||
35 | FOLRG | SO_FOL_RG | SO_FOL_RG | CHAR | 1 | 0 | Folder: Area (private, shared folders) | ||
36 | NOTES | SO_NOTES | SO_FLAG | CHAR | 1 | 0 | Flag for an attachment | ||
37 | UHCNT | SO_UHCNT | SO_CNT2 | RAW | 2 | 0 | Counts how many users have this object in HOLD status | ||
38 | ENCCNT | SO_ENC_CNT | SO_CNT2 | RAW | 2 | 0 | Number of attachments for the object | ||
39 | PTFOL | SO_PTFOL | SO_CNT2 | RAW | 2 | 0 | Number of folders which contain the object | ||
40 | PTENC | SO_PTENC | SO_CNT2 | RAW | 2 | 0 | Number of objects for which this object is an attachment | ||
41 | PTHYP | SO_PTHYP | SO_CNT2 | RAW | 2 | 0 | Number of hyperlinks to this object | ||
42 | PTNOT | SO_PTNOT | SO_CNT2 | RAW | 2 | 0 | Number of objects, in which this object is a note | ||
43 | PTMBO | SO_PTMBO | SO_CNT2 | RAW | 2 | 0 | Number of MBO objects which contain this object | ||
44 | PAFOL | SO_PAFOL | SO_CNT2 | RAW | 2 | 0 | Number of folders, in which object is stored and archived | ||
45 | PAENC | SO_PAENC | SO_CNT2 | RAW | 2 | 0 | No.of archived objects f. which this object is an attachment | ||
46 | PAHYP | SO_PAHYP | SO_CNT2 | RAW | 2 | 0 | Number of archived hyperlinks to this object | ||
47 | PANOT | SO_PANOT | SO_CNT2 | RAW | 2 | 0 | Number of archived objects in which this object is a note | ||
48 | PAMBO | SO_PAMBO | SO_CNT2 | RAW | 2 | 0 | Number of archived MBO objects which contain this object | ||
49 | ARCHI | SO_ARCHI | SO_FLAG | CHAR | 1 | 0 | The document is stored in archive | ||
50 | LADAT | SO_DAT_LA | DATUM | DATS | 8 | 0 | Date of last access | ||
51 | DLDAT | SO_DAT_DL | DATUM | DATS | 8 | 0 | Document Expiration Date | ||
52 | DLTIM | SO_TIM_DL | UZEIT | TIMS | 6 | 0 | Expiry time of object | ||
53 | OBJPRI | SO_OBJ_PRI | SO_OBJ_PRI | CHAR | 1 | 0 | Document priority | ||
54 | OBJSNS | SO_OBJ_SNS | SO_OBJ_SNS | CHAR | 1 | 0 | Object: Sensitivity (private, functional, ...) | ||
55 | OBJENC | SO_OBJ_ENC | SO_FLAG | CHAR | 1 | 0 | Object: coded | ||
56 | OBJSND | SO_OBJ_SND | SO_FLAG | CHAR | 1 | 0 | Object has already been sent | ||
57 | SDDAT | SO_DAT_SD | DATUM | DATS | 8 | 0 | Date On Which Object Was Sent | ||
58 | SDTIM | SO_TIM_SD | UZEIT | TIMS | 6 | 0 | Time at Which The Object Was Sent | ||
59 | RECCNT | SO_RECCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients of the object | ||
60 | RRDCNT | SO_RRDCNT | SO_CNT2 | RAW | 2 | 0 | Number of Recipients Who Have Read Object | ||
61 | RRRCNT | SO_RRRCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients who must reply to the object | ||
62 | RRPCNT | SO_RRPCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients who have sent required reply | ||
63 | RARCNT | SO_RARCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients who must take action | ||
64 | RAPCNT | SO_RAPCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients processing the object | ||
65 | RATCNT | SO_RATCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients who have taken action | ||
66 | REXCNT | SO_REXCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients of the express message | ||
67 | RCPCNT | SO_RCPCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients of a copy | ||
68 | RBCCNT | SO_RBCCNT | SO_CNT2 | RAW | 2 | 0 | Number of recipients of a blind copy | ||
69 | ACONE | SO_ACONE | SO_CNT1 | RAW | 1 | 0 | ToDo by one of the recipients in the group | ||
70 | ACOUT | SO_ACOUT | SO_FLAG | CHAR | 1 | 0 | ToDo: To Be Completed Outside SAPoffice | ||
71 | FROUT | SO_FROUT | SO_FLAG | CHAR | 1 | 0 | Object is to be forwarded outside of SAPoffice | ||
72 | VMTYP | SO_VM_TYP | SO_VM_TYP | CHAR | 1 | 0 | Execute: Type (Report, Dialog Module, ...) | TSOVM | |
73 | SKIPS | SO_SKIPS | SO_FLAG | CHAR | 1 | 0 | Execute: Process First Screen in Background | ||
74 | ACNAM | SO_ACNAM | SO_ACNAM | CHAR | 54 | 0 | Execute: Name of Report, FM, DB, TCode | ||
75 | ACMEM | SO_ACMEM | SO_ACMEM | CHAR | 32 | 0 | Process: memory ID | ||
76 | HYPTP | SO_HYP_TP | SO_OBJ_TP | CHAR | 3 | 0 | Hypertext pointer: Object type | TSOTD | |
77 | HYPYR | SO_HYP_YR | SO_OBJ_YR | CHAR | 2 | 0 | Hypertext pointer: year | ||
78 | HYPNO | SO_HYP_NO | SO_OBJ_NO | CHAR | 12 | 0 | Hypertext pointer: number | * | |
79 | AUTTP | SO_AUT_TP | SO_OBJ_TP | CHAR | 3 | 0 | Authorization list: Type from ID | TSOTD | |
80 | AUTYR | SO_AUT_YR | SO_OBJ_YR | CHAR | 2 | 0 | Authorization list: year from the ID | ||
81 | AUTNO | SO_AUT_NO | SO_OBJ_NO | CHAR | 12 | 0 | Authorization list: number from the ID | * | |
82 | PCTRL | SO_PCTRL | SO_FLAG | CHAR | 1 | 0 | SAPoffice: object can be deleted in external inbox | ||
83 | CCOTP | SO_CCO_TP | SO_OBJ_TP | CHAR | 3 | 0 | Change copy: object type from the ID | TSOTD | |
84 | CCOYR | SO_CCO_YR | SO_OBJ_YR | CHAR | 2 | 0 | Change copy: year from the ID | ||
85 | CCONO | SO_CCO_NO | SO_OBJ_NO | CHAR | 12 | 0 | Change copy: number from the ID | * | |
86 | OBJCP | SO_OBJ_CP | SO_FLAG | CHAR | 1 | 0 | Document cannot be changed | ||
87 | PRTCT | SO_PRTCT | SO_FLAG | CHAR | 1 | 0 | Document title modifiable | ||
88 | FIXED | SO_FIXED | SO_FLAG | CHAR | 1 | 0 | Check-in/check-out flag | ||
89 | EXTHD | SO_EXTHD | SO_FLAG | CHAR | 1 | 0 | Object-specific header is stored externally | ||
90 | EXTCT | SO_EXTCT | SO_FLAG | CHAR | 1 | 0 | Object contents are stored externally | ||
91 | FILE_EXT | SO_FILEEXT | CHAR3 | CHAR | 3 | 0 | File extension for PC application | ||
92 | OBJLEN | SO_OBJ_LEN | SO_OBJ_LEN | CHAR | 12 | 0 | Size of Document Content | ||
93 | OBJDBLEN | SO_OBJ_LEN | SO_OBJ_LEN | CHAR | 12 | 0 | Size of Document Content | ||
94 | CREATOR | SO_CREATOR | SO_TEXT004 | CHAR | 4 | 0 | Creator for MacIntosh-based files | ||
95 | ATTLEN | SO_ATT_LEN | SO_OBJ_LEN | CHAR | 12 | 0 | Total size of all attachments to a document | ||
96 | IF_DOC_BCS | OS_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique Identifier | ||
97 | IF_DOC_CLS | OS_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique Identifier |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SWWARCH_1 | AUTTP | TSOTD | OBJTP | REF | 1 | 1 |
2 | SWWARCH_1 | CCOTP | TSOTD | OBJTP | REF | 1 | 1 |
3 | SWWARCH_1 | CHOTP | TSOTD | OBJTP | REF | 1 | 1 |
4 | SWWARCH_1 | CROTP | TSOTD | OBJTP | REF | 1 | 1 |
5 | SWWARCH_1 | HYPTP | TSOTD | OBJTP | REF | 1 | 1 |
6 | SWWARCH_1 | MANDT | T000 | MANDT | KEY | 1 | 1 |
7 | SWWARCH_1 | NOTTP | TSOTD | OBJTP | REF | 1 | 1 |
8 | SWWARCH_1 | OBJLA | T002 | SPRAS | REF | 1 | 1 |
9 | SWWARCH_1 | OBJTP | TSOTD | OBJTP | KEY | 1 | 1 |
10 | SWWARCH_1 | OWNTP | TSOTD | OBJTP | REF | 1 | 1 |
11 | SWWARCH_1 | VMTYP | TSOVM | VMTYP | REF | 1 | 1 |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 610 |