SAP ABAP Table SOFD (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	SOFD	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	FOLTP	☑	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID	TSOTD
3	FOLYR	☑	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
4	FOLNO	☑	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID	*
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	SOOD
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	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	SOOD
15	CRDAT	☐	SO_DAT_CR	DATUM	DATS	8	0	Date created
16	CRTIM	☐	SO_TIM_CR	UZEIT	TIMS	6	0	Time created
17	CHOTP	☐	SO_CHO_TP	SO_OBJ_TP	CHAR	3	0	User that changed the object: Object type from ID	TSOTD
18	CHOYR	☐	SO_CHO_YR	SO_OBJ_YR	CHAR	2	0	User that changed the object: year from the ID
19	CHONO	☐	SO_CHO_NO	SO_OBJ_NO	CHAR	12	0	User that changed the object: number from the ID	SOOD
20	CHDAT	☐	SO_DAT_CH	DATUM	DATS	8	0	Date of Last Change
21	CHTIM	☐	SO_TIM_CH	UZEIT	TIMS	6	0	Time of Last Change
22	NOTTP	☐	SO_NOT_TP	SO_OBJ_TP	CHAR	3	0	Default setting of document class	TSOTD
23	NOTYR	☐	SO_NOT_YR	SO_OBJ_YR	CHAR	2	0	Object note: year from the ID
24	NOTNO	☐	SO_NOT_NO	SO_OBJ_NO	CHAR	12	0	Object note: number from the ID	SOOD
25	FOLRG	☐	SO_FOL_RG	SO_FOL_RG	CHAR	1	0	Folder: Area (private, shared folders)
26	LADAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access
27	DLDAT	☐	SO_DAT_DL	DATUM	DATS	8	0	Document Expiration Date
28	DLTIM	☐	SO_TIM_DL	UZEIT	TIMS	6	0	Expiry time of object
29	OBJSNS	☐	SO_OBJ_SNS	SO_OBJ_SNS	CHAR	1	0	Object: Sensitivity (private, functional, ...)
30	FIXED	☐	SO_FIXED	SO_FLAG	CHAR	1	0	Check-in/check-out flag
31	PARTP	☐	SO_PAR_TP	SO_OBJ_TP	CHAR	3	0	Parent object type from ID	TSOTD
32	PARYR	☐	SO_PAR_YR	SO_OBJ_YR	CHAR	2	0	Parent object year from the ID
33	PARNO	☐	SO_PAR_NO	SO_OBJ_NO	CHAR	12	0	Parent object number from the ID	SOOD
34	FOLCNT	☐	SO_FOL_SIZ	SO_OBJ_SIZ	NUMC	5	0	Number of documents stored in this folder
35	FOLSIZ	☐	SO_FOL_SIZ	SO_OBJ_SIZ	NUMC	5	0	Number of documents stored in this folder
36	TPONLY	☐	SO_TPONLY	SO_OBJ_TP	CHAR	3	0	Only this object type can be stored in this folder	TSOTD
37	LIFSP	☐	SO_LIFSP	SO_NUM5	NUMC	5	0	Retention period of documents in folder
38	FOLINDEX	☐	SO_INDEX	SO_FLAG	CHAR	1	0	Index folder and documents contained in it
39	PFLCL	☐	SO_PFLCL	SO_FOL_CL	CHAR	1	0	Private folder class
40	ICLASS	☐	SF_ICLASS	SF_ICLASS	CHAR	4	0	Information class for indexing	TFIC
41	DLITP	☐	SO_DLI_TP	SO_OBJ_TP	CHAR	3	0	Distribution list type from ID	TSOTD
42	DLIYR	☐	SO_DLI_YR	SO_OBJ_YR	CHAR	2	0	Distribution list year from the ID
43	DLINO	☐	SO_DLI_NO	SO_OBJ_NO	CHAR	12	0	Distribution list: number from the ID	SOOD
44	FOLSEC	☐	SO_FOL_SEC	SO_FOL_SEC	CHAR	1	0	Folder area (private, client, group, ...)
45	FOLTYPE	☐	SO_FOL_TY	SO_FOL_TY	CHAR	4	0	SAPoffice: Folder type
46	LAFDAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SOFD	CHONO	SOOD	OBJNO	REF	C	CN
2	SOFD	CHOTP	TSOTD	OBJTP	REF	C	CN
3	SOFD	CRONO	SOOD	OBJNO	REF	C	CN
4	SOFD	CROTP	TSOTD	OBJTP	REF	C	CN
5	SOFD	DLINO	SOOD	OBJNO	REF	C	CN
6	SOFD	DLITP	TSOTD	OBJTP	REF	C	CN
7	SOFD	FOLTP	TSOTD	OBJTP	KEY	1	CN
8	SOFD	ICLASS	TFIC	CLASS	REF	C	CN
9	SOFD	MANDT	T000	MANDT	KEY	1	CN
10	SOFD	NOTNO	SOOD	OBJNO	REF	C	CN
11	SOFD	NOTTP	TSOTD	OBJTP	REF	C	CN
12	SOFD	OBJLA	T002	SPRAS	KEY	1	1
13	SOFD	OWNNO	SOOD	OBJNO	KEY	1	CN
14	SOFD	OWNTP	TSOTD	OBJTP	KEY	1	CN
15	SOFD	PARNO	SOOD	OBJNO	REF	C	CN
16	SOFD	PARTP	TSOTD	OBJTP	REF	C	CN
17	SOFD	TPONLY	TSOTD	OBJTP	REF	C	CN

History

Last changed by/on	SAP	20070507
SAP Release Created in