SAP ABAP Table SOFM_WI (Sofm for Archiving of WI Attachments)

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	SOFM_WI	Table Relationship Diagram
Short Description	Sofm for Archiving of WI Attachments

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

History

Last changed by/on	SAP	20110908
SAP Release Created in	50A