SAP ABAP Table SOODO (SAPoffice: definition of an object (without MANDT))

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	SOODO	Table Relationship Diagram
Short Description	SAPoffice: definition of an object (without MANDT)

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

History

Last changed by/on	SAP	20070507
SAP Release Created in