SAP ABAP Table SOOD (SAPoffice: Object definition)

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	TRANSP	Transparent table
Transparent table	SOOD	Table Relationship Diagram
Short Description	SAPoffice: Object definition

Delivery and Maintenance

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

History

Last changed by/on	SAP	20070507
SAP Release Created in