SAP ABAP Table SOODD (SAPoffice: definition of an object (data division))

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	SOODD	Table Relationship Diagram
Short Description	SAPoffice: definition of an object (data division)

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

History

Last changed by/on	SAP	20070507
SAP Release Created in