SAP ABAP Table SOFM (SAPoffice: Folder contents)

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	SOFM	Table Relationship Diagram
Short Description	SAPoffice: Folder contents

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	SOFD
5	DOCTP	☑	SO_DOC_TP	SO_OBJ_TP	CHAR	3	0	Object: Object Type From ID	TSOTD
6	DOCYR	☑	SO_DOC_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
7	DOCNO	☑	SO_DOC_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	SOOD
8	FORTP	☑	SO_FOR_TP	SO_OBJ_TP	CHAR	3	0	Forwarder: Object type from ID	TSOTD
9	FORYR	☑	SO_FOR_YR	SO_OBJ_YR	CHAR	2	0	Forwarder: year from the ID
10	FORNO	☑	SO_FOR_NO	SO_OBJ_NO	CHAR	12	0	Forwarder: number from the ID
11	PERMA	☐	SO_PERMA	SO_FLAG	CHAR	1	0	SAPoffice: Object is displayed independent of selection date
12	HOLDO	☐	SO_HOLDO	SO_FLAG	CHAR	1	0	The object has status HOLD
13	ARCHI	☐	SO_ARCHI	SO_FLAG	CHAR	1	0	The document is stored in archive
14	DLDAT	☐	SO_DAT_DL	DATUM	DATS	8	0	Document Expiration Date
15	DLTIM	☐	SO_TIM_DL	UZEIT	TIMS	6	0	Expiry time of object
16	NOTTP	☐	SO_NOT_TP	SO_OBJ_TP	CHAR	3	0	Default setting of document class	TSOTD
17	NOTYR	☐	SO_NOT_YR	SO_OBJ_YR	CHAR	2	0	Object note: year from the ID
18	NOTNO	☐	SO_NOT_NO	SO_OBJ_NO	CHAR	12	0	Object note: number from the ID
19	RCDAT	☐	SO_DAT_RC	DATUM	DATS	8	0	Date document was received
20	RCTIM	☐	SO_TIM_RC	UZEIT	TIMS	6	0	Time object was received
21	SNDDR	☐	SO_SND_DR	SO_FLAG	CHAR	1	0	Send: As disregard
22	SNDEX	☐	SO_SND_EX	SO_FLAG	CHAR	1	0	Send express
23	SNDCP	☐	SO_SND_CP	SO_FLAG	CHAR	1	0	Send: As copy
24	SNDBC	☐	SO_SND_BC	SO_FLAG	CHAR	1	0	Send as a blind copy
25	OBJAC	☐	SO_OBJ_AC	SO_FLAG	CHAR	1	0	The recipient must take action
26	OBJRR	☐	SO_OBJ_RR	SO_FLAG	CHAR	1	0	A reply must be sent for this object
27	OBJRD	☐	SO_OBJ_RD	SO_FLAG	CHAR	1	0	Object has already been viewed
28	RESUB	☐	SO_RSUBM	SO_FELD123	CHAR	1	0	SAPoffice: folder entry is a resubmitted object
29	RECPRI	☐	SO_REC_PRI	SO_OBJ_PRI	CHAR	1	0	Priority
30	FLAG1	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
31	FLAG2	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
32	FLAG3	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
33	FLAG4	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
34	FLAG5	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
35	RBDAT	☐	SO_DAT_RB	DATUM	DATS	8	0	Date On Which The Object Was Resubmitted
36	LFOLTP	☐	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID
37	LFOLYR	☐	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
38	LFOLNO	☐	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SOFM	DOCNO	SOOD	OBJNO	KEY	1	CN
2	SOFM	DOCTP	TSOTD	OBJTP	KEY	1	1
3	SOFM	FOLNO	SOFD	FOLNO	KEY	1	CN
4	SOFM	FOLTP	TSOTD	OBJTP	KEY	1	1
5	SOFM	FORTP	TSOTD	OBJTP	KEY	1	1
6	SOFM	MANDT	T000	MANDT	KEY	1	1
7	SOFM	NOTTP	TSOTD	OBJTP	KEY	1	1

History

Last changed by/on	SAP	19970214
SAP Release Created in