SAP ABAP Table SOWIARC (Structure of Archiving of WI Attachments (SOFM))

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	SOWIARC	Table Relationship Diagram
Short Description	Structure of Archiving of WI Attachments (SOFM)

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	SOOD	☐	SOOD		STRU	0	0
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
3	OBJTP	☐	SO_OBJ_TP	SO_OBJ_TP	CHAR	3	0	Code for document class
4	OBJYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
5	OBJNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
6	OBJLA	☐	SO_OBJ_LA	SPRAS	LANG	1	0	Language in Which Document Is Created
7	OBJSRT	☐	SO_OBJ_SRT	SO_OBJ_SRT	CHAR	10	0	Sort field
8	OBJNAM	☐	SO_OBJ_NAM	SO_OBJ_NAM	CHAR	12	0	Name of document, folder or distribution list
9	OBJDES	☐	SO_OBJ_DES	SO_OBJ_DES	CHAR	50	0	Short description of contents
10	OWNTP	☐	SO_OWN_TP	SO_OBJ_TP	CHAR	3	0	Owner type from ID
11	OWNYR	☐	SO_OWN_YR	SO_OBJ_YR	CHAR	2	0	Owner year from the ID
12	OWNNO	☐	SO_OWN_NO	SO_OBJ_NO	CHAR	12	0	Owner number from the ID
13	OWNNAM	☐	SO_OWN_NAM	USERNAME	CHAR	12	0	Name of document owner
14	CROTP	☐	SO_CRO_TP	SO_OBJ_TP	CHAR	3	0	User who created object: Object type from ID
15	CROYR	☐	SO_CRO_YR	SO_OBJ_YR	CHAR	2	0	User that created object: year from the ID
16	CRONO	☐	SO_CRO_NO	SO_OBJ_NO	CHAR	12	0	User that created object: number from the ID
17	CRONAM	☐	SO_CRO_NAM	USERNAME	CHAR	12	0	Creator Name
18	CRDAT	☐	SO_DAT_CR	DATUM	DATS	8	0	Date created
19	CRTIM	☐	SO_TIM_CR	UZEIT	TIMS	6	0	Time created
20	CHOTP	☐	SO_CHO_TP	SO_OBJ_TP	CHAR	3	0	User that changed the object: Object type from ID
21	CHOYR	☐	SO_CHO_YR	SO_OBJ_YR	CHAR	2	0	User that changed the object: year from the ID
22	CHONO	☐	SO_CHO_NO	SO_OBJ_NO	CHAR	12	0	User that changed the object: number from the ID
23	CHONAM	☐	SO_CHO_NAM	USERNAME	CHAR	12	0	Changed by
24	CHDAT	☐	SO_DAT_CH	DATUM	DATS	8	0	Date of Last Change
25	CHTIM	☐	SO_TIM_CH	UZEIT	TIMS	6	0	Time of Last Change
26	NOTTP	☐	SO_NOT_TP	SO_OBJ_TP	CHAR	3	0	Default setting of document class
27	NOTYR	☐	SO_NOT_YR	SO_OBJ_YR	CHAR	2	0	Object note: year from the ID
28	NOTNO	☐	SO_NOT_NO	SO_OBJ_NO	CHAR	12	0	Object note: number from the ID
29	OBJAPP	☐	SO_OBJ_APP	SO_FLAG	CHAR	1	0	Application object
30	OBJFIL	☐	SO_OBJ_FIL	SO_FLAG	CHAR	1	0	Object from SAPfile
31	FOLRG	☐	SO_FOL_RG	SO_FOL_RG	CHAR	1	0	Folder: Area (private, shared folders)
32	NOTES	☐	SO_NOTES	SO_FLAG	CHAR	1	0	Flag for an attachment
33	UHCNT	☐	SO_UHCNT	SO_CNT2	RAW	2	0	Counts how many users have this object in HOLD status
34	ENCCNT	☐	SO_ENC_CNT	SO_CNT2	RAW	2	0	Number of attachments for the object
35	PTFOL	☐	SO_PTFOL	SO_CNT2	RAW	2	0	Number of folders which contain the object
36	PTENC	☐	SO_PTENC	SO_CNT2	RAW	2	0	Number of objects for which this object is an attachment
37	PTHYP	☐	SO_PTHYP	SO_CNT2	RAW	2	0	Number of hyperlinks to this object
38	PTNOT	☐	SO_PTNOT	SO_CNT2	RAW	2	0	Number of objects, in which this object is a note
39	PTMBO	☐	SO_PTMBO	SO_CNT2	RAW	2	0	Number of MBO objects which contain this object
40	PAFOL	☐	SO_PAFOL	SO_CNT2	RAW	2	0	Number of folders, in which object is stored and archived
41	PAENC	☐	SO_PAENC	SO_CNT2	RAW	2	0	No.of archived objects f. which this object is an attachment
42	PAHYP	☐	SO_PAHYP	SO_CNT2	RAW	2	0	Number of archived hyperlinks to this object
43	PANOT	☐	SO_PANOT	SO_CNT2	RAW	2	0	Number of archived objects in which this object is a note
44	PAMBO	☐	SO_PAMBO	SO_CNT2	RAW	2	0	Number of archived MBO objects which contain this object
45	ARCHI	☐	SO_ARCHI	SO_FLAG	CHAR	1	0	The document is stored in archive
46	LADAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access
47	DLDAT	☐	SO_DAT_DL	DATUM	DATS	8	0	Document Expiration Date
48	DLTIM	☐	SO_TIM_DL	UZEIT	TIMS	6	0	Expiry time of object
49	OBJPRI	☐	SO_OBJ_PRI	SO_OBJ_PRI	CHAR	1	0	Document priority
50	OBJSNS	☐	SO_OBJ_SNS	SO_OBJ_SNS	CHAR	1	0	Object: Sensitivity (private, functional, ...)
51	OBJENC	☐	SO_OBJ_ENC	SO_FLAG	CHAR	1	0	Object: coded
52	OBJSND	☐	SO_OBJ_SND	SO_FLAG	CHAR	1	0	Object has already been sent
53	SDDAT	☐	SO_DAT_SD	DATUM	DATS	8	0	Date On Which Object Was Sent
54	SDTIM	☐	SO_TIM_SD	UZEIT	TIMS	6	0	Time at Which The Object Was Sent
55	RECCNT	☐	SO_RECCNT	SO_CNT2	RAW	2	0	Number of recipients of the object
56	RRDCNT	☐	SO_RRDCNT	SO_CNT2	RAW	2	0	Number of Recipients Who Have Read Object
57	RRRCNT	☐	SO_RRRCNT	SO_CNT2	RAW	2	0	Number of recipients who must reply to the object
58	RRPCNT	☐	SO_RRPCNT	SO_CNT2	RAW	2	0	Number of recipients who have sent required reply
59	RARCNT	☐	SO_RARCNT	SO_CNT2	RAW	2	0	Number of recipients who must take action
60	RAPCNT	☐	SO_RAPCNT	SO_CNT2	RAW	2	0	Number of recipients processing the object
61	RATCNT	☐	SO_RATCNT	SO_CNT2	RAW	2	0	Number of recipients who have taken action
62	REXCNT	☐	SO_REXCNT	SO_CNT2	RAW	2	0	Number of recipients of the express message
63	RCPCNT	☐	SO_RCPCNT	SO_CNT2	RAW	2	0	Number of recipients of a copy
64	RBCCNT	☐	SO_RBCCNT	SO_CNT2	RAW	2	0	Number of recipients of a blind copy
65	ACONE	☐	SO_ACONE	SO_CNT1	RAW	1	0	ToDo by one of the recipients in the group
66	ACOUT	☐	SO_ACOUT	SO_FLAG	CHAR	1	0	ToDo: To Be Completed Outside SAPoffice
67	FROUT	☐	SO_FROUT	SO_FLAG	CHAR	1	0	Object is to be forwarded outside of SAPoffice
68	VMTYP	☐	SO_VM_TYP	SO_VM_TYP	CHAR	1	0	Execute: Type (Report, Dialog Module, ...)
69	SKIPS	☐	SO_SKIPS	SO_FLAG	CHAR	1	0	Execute: Process First Screen in Background
70	ACNAM	☐	SO_ACNAM	SO_ACNAM	CHAR	54	0	Execute: Name of Report, FM, DB, TCode
71	ACMEM	☐	SO_ACMEM	SO_ACMEM	CHAR	32	0	Process: memory ID
72	HYPTP	☐	SO_HYP_TP	SO_OBJ_TP	CHAR	3	0	Hypertext pointer: Object type
73	HYPYR	☐	SO_HYP_YR	SO_OBJ_YR	CHAR	2	0	Hypertext pointer: year
74	HYPNO	☐	SO_HYP_NO	SO_OBJ_NO	CHAR	12	0	Hypertext pointer: number
75	AUTTP	☐	SO_AUT_TP	SO_OBJ_TP	CHAR	3	0	Authorization list: Type from ID
76	AUTYR	☐	SO_AUT_YR	SO_OBJ_YR	CHAR	2	0	Authorization list: year from the ID
77	AUTNO	☐	SO_AUT_NO	SO_OBJ_NO	CHAR	12	0	Authorization list: number from the ID
78	PCTRL	☐	SO_PCTRL	SO_FLAG	CHAR	1	0	SAPoffice: object can be deleted in external inbox
79	CCOTP	☐	SO_CCO_TP	SO_OBJ_TP	CHAR	3	0	Change copy: object type from the ID
80	CCOYR	☐	SO_CCO_YR	SO_OBJ_YR	CHAR	2	0	Change copy: year from the ID
81	CCONO	☐	SO_CCO_NO	SO_OBJ_NO	CHAR	12	0	Change copy: number from the ID
82	OBJCP	☐	SO_OBJ_CP	SO_FLAG	CHAR	1	0	Document cannot be changed
83	PRTCT	☐	SO_PRTCT	SO_FLAG	CHAR	1	0	Document title modifiable
84	FIXED	☐	SO_FIXED	SO_FLAG	CHAR	1	0	Check-in/check-out flag
85	EXTHD	☐	SO_EXTHD	SO_FLAG	CHAR	1	0	Object-specific header is stored externally
86	EXTCT	☐	SO_EXTCT	SO_FLAG	CHAR	1	0	Object contents are stored externally
87	FILE_EXT	☐	SO_FILEEXT	CHAR3	CHAR	3	0	File extension for PC application
88	OBJLEN	☐	SO_OBJ_LEN	SO_OBJ_LEN	CHAR	12	0	Size of Document Content
89	OBJDBLEN	☐	SO_OBJ_LEN	SO_OBJ_LEN	CHAR	12	0	Size of Document Content
90	CREATOR	☐	SO_CREATOR	SO_TEXT004	CHAR	4	0	Creator for MacIntosh-based files
91	ATTLEN	☐	SO_ATT_LEN	SO_OBJ_LEN	CHAR	12	0	Total size of all attachments to a document
92	IF_DOC_BCS	☐	OS_GUID	SYSUUID	RAW	16	0	Globally Unique Identifier
93	IF_DOC_CLS	☐	OS_GUID	SYSUUID	RAW	16	0	Globally Unique Identifier
94	SOFM	☐	SOFM		STRU	0	0
95	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
96	FOLTP	☐	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID
97	FOLYR	☐	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
98	FOLNO	☐	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID
99	DOCTP	☐	SO_DOC_TP	SO_OBJ_TP	CHAR	3	0	Object: Object Type From ID
100	DOCYR	☐	SO_DOC_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
101	DOCNO	☐	SO_DOC_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
102	FORTP	☐	SO_FOR_TP	SO_OBJ_TP	CHAR	3	0	Forwarder: Object type from ID
103	FORYR	☐	SO_FOR_YR	SO_OBJ_YR	CHAR	2	0	Forwarder: year from the ID
104	FORNO	☐	SO_FOR_NO	SO_OBJ_NO	CHAR	12	0	Forwarder: number from the ID
105	PERMA	☐	SO_PERMA	SO_FLAG	CHAR	1	0	SAPoffice: Object is displayed independent of selection date
106	HOLDO	☐	SO_HOLDO	SO_FLAG	CHAR	1	0	The object has status HOLD
107	ARCHI	☐	SO_ARCHI	SO_FLAG	CHAR	1	0	The document is stored in archive
108	DLDAT	☐	SO_DAT_DL	DATUM	DATS	8	0	Document Expiration Date
109	DLTIM	☐	SO_TIM_DL	UZEIT	TIMS	6	0	Expiry time of object
110	NOTTP	☐	SO_NOT_TP	SO_OBJ_TP	CHAR	3	0	Default setting of document class
111	NOTYR	☐	SO_NOT_YR	SO_OBJ_YR	CHAR	2	0	Object note: year from the ID
112	NOTNO	☐	SO_NOT_NO	SO_OBJ_NO	CHAR	12	0	Object note: number from the ID
113	RCDAT	☐	SO_DAT_RC	DATUM	DATS	8	0	Date document was received
114	RCTIM	☐	SO_TIM_RC	UZEIT	TIMS	6	0	Time object was received
115	SNDDR	☐	SO_SND_DR	SO_FLAG	CHAR	1	0	Send: As disregard
116	SNDEX	☐	SO_SND_EX	SO_FLAG	CHAR	1	0	Send express
117	SNDCP	☐	SO_SND_CP	SO_FLAG	CHAR	1	0	Send: As copy
118	SNDBC	☐	SO_SND_BC	SO_FLAG	CHAR	1	0	Send as a blind copy
119	OBJAC	☐	SO_OBJ_AC	SO_FLAG	CHAR	1	0	The recipient must take action
120	OBJRR	☐	SO_OBJ_RR	SO_FLAG	CHAR	1	0	A reply must be sent for this object
121	OBJRD	☐	SO_OBJ_RD	SO_FLAG	CHAR	1	0	Object has already been viewed
122	RESUB	☐	SO_RSUBM	SO_FELD123	CHAR	1	0	SAPoffice: folder entry is a resubmitted object
123	RECPRI	☐	SO_REC_PRI	SO_OBJ_PRI	CHAR	1	0	Priority
124	FLAG1	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
125	FLAG2	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
126	FLAG3	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
127	FLAG4	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
128	FLAG5	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
129	RBDAT	☐	SO_DAT_RB	DATUM	DATS	8	0	Date On Which The Object Was Resubmitted
130	LFOLTP	☐	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID
131	LFOLYR	☐	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
132	LFOLNO	☐	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID
133	OBJHEAD	☐	SOLI_TAB		TTYP	0	0
134	OBJCONT	☐	SOLI_TAB		TTYP	0	0
135	OBJPARA	☐	SELC_TAB		TTYP	0	0
136	OBJPARB	☐	SOOP1_TAB		TTYP	0	0

History

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