SAP ABAP Table SOOD_WI (Sood for Archiving of WI Attachments)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     ⤷ SO (Package) SAPoffice

Basic Data

Table Category	INTTAB	Structure
Structure	SOOD_WI	Table Relationship Diagram
Short Description	Sood for Archiving of WI Attachments

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

History

Last changed by/on	SAP	20110908
SAP Release Created in	50A