SAP ABAP View V_SOIC (SAPoffice: View For Reading Inbox/Outbox)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     ⤷ SO (Package) SAPoffice

Basic Data

View Type	D	Database View
Database View	V_SOIC
Short Description	SAPoffice: View For Reading Inbox/Outbox
Root table	SOFM	SAPoffice: Folder contents

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SOFM	SOFM
2	SOOD	PEST01
3	SOOS	PEST01

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SOOD	MANDT	JL	EQ				0	0
2	SOFM	MANDT	JR	EQ			AND	0	0
3	SOOD	OBJTP	JL	EQ				0	0
4	SOFM	DOCTP	JR	EQ			AND	0	0
5	SOOD	OBJYR	JL	EQ				0	0
6	SOFM	DOCYR	JR	EQ			AND	0	0
7	SOOD	OBJNO	JL	EQ				0	0
8	SOFM	DOCNO	JR	EQ			AND	0	0
9	SOOD	MANDT	JL	EQ				0	0
10	SOOS	MANDT	JR	EQ			AND	0	0
11	SOOD	OBJTP	JL	EQ				0	0
12	SOOS	OBJTP	JR	EQ			AND	0	0
13	SOOD	OBJYR	JL	EQ				0	0
14	SOOS	OBJYR	JR	EQ			AND	0	0
15	SOOD	OBJNO	JL	EQ				0	0
16	SOOS	OBJNO	JR	EQ			AND	0	0
17	SOFM	FORTP	JL	EQ				0	0
18	SOOS	FORTP	JR	EQ			AND	0	0
19	SOFM	FORYR	JL	EQ				0	0
20	SOOS	FORYR	JR	EQ			AND	0	0
21	SOFM	FORNO	JL	EQ				0	0
22	SOOS	FORNO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SOFM	MANDT		☐	MANDT	☐	Client
2	FOLTP	SOFM	FOLTP		☐	SO_FOL_TP	☐	Object folder: Object type from ID
3	FOLYR	SOFM	FOLYR		☐	SO_FOL_YR	☐	Object folder: Year from ID
4	FOLNO	SOFM	FOLNO		☐	SO_FOL_NO	☐	Object folder: Number from ID
5	RECTP	SOOS	RECTP		☐	SO_REC_TP	☐	Recipient type from ID
6	RECYR	SOOS	RECYR		☐	SO_REC_YR	☐	Recipient year from the ID
7	RECNO	SOOS	RECNO		☐	SO_REC_NO	☐	Recipient number from ID
8	DOCTP	SOFM	DOCTP		☐	SO_DOC_TP	☐	Object: Object Type From ID
9	DOCYR	SOFM	DOCYR		☐	SO_DOC_YR	☐	Object: Year from ID
10	DOCNO	SOFM	DOCNO		☐	SO_DOC_NO	☐	Object: Number from ID
11	FORTP	SOFM	FORTP		☐	SO_FOR_TP	☐	Forwarder: Object type from ID
12	FORYR	SOFM	FORYR		☐	SO_FOR_YR	☐	Forwarder: year from the ID
13	FORNO	SOFM	FORNO		☐	SO_FOR_NO	☐	Forwarder: number from the ID
14	DOCNAM	SOOD	OBJNAM		☐	SO_OBJ_NAM	☐	Name of document, folder or distribution list
15	DOCDES	SOOD	OBJDES		☐	SO_OBJ_DES	☐	Short description of contents
16	DOCLA	SOOD	OBJLA		☐	SO_OBJ_LA	☐	Language in Which Document Is Created
17	CRDAT	SOOD	CRDAT		☐	SO_DAT_CR	☐	Date created
18	CRTIM	SOOD	CRTIM		☐	SO_TIM_CR	☐	Time created
19	CHDAT	SOOD	CHDAT		☐	SO_DAT_CH	☐	Date of Last Change
20	CHTIM	SOOD	CHTIM		☐	SO_TIM_CH	☐	Time of Last Change
21	DLDAT	SOFM	DLDAT		☐	SO_DAT_DL	☐	Document Expiration Date
22	OWNTP	SOOD	OWNTP		☐	SO_OWN_TP	☐	Owner type from ID
23	OWNYR	SOOD	OWNYR		☐	SO_OWN_YR	☐	Owner year from the ID
24	OWNNO	SOOD	OWNNO		☐	SO_OWN_NO	☐	Owner number from the ID
25	OBJSNS	SOOD	OBJSNS		☐	SO_OBJ_SNS	☐	Object: Sensitivity (private, functional, ...)
26	OBJSND	SOOD	OBJSND		☐	SO_OBJ_SND	☐	Object has already been sent
27	ENCCNT	SOOD	ENCCNT		☐	SO_ENC_CNT	☐	Number of attachments for the object
28	RCDAT	SOOS	RCDAT		☐	SO_DAT_RC	☐	Date document was received
29	RCTIM	SOOS	RCTIM		☐	SO_TIM_RC	☐	Time object was received
30	OBJRD	SOFM	OBJRD		☐	SO_OBJ_RD	☐	Object has already been viewed
31	SNDEX	SOOS	SNDEX		☐	SO_SND_EX	☐	Send express
32	SNDCP	SOOS	SNDCP		☐	SO_SND_CP	☐	Send: As copy
33	SNDBC	SOFM	SNDBC		☐	SO_SND_BC	☐	Send as a blind copy
34	FORFB	SOOS	FORFB		☐	SO_FORFB	☐	You cannot forward this message
35	PRIFB	SOOS	PRIFB		☐	SO_PRIFB	☐	Object cannot be printed
36	ACALL	SOOS	ACALL		☐	SO_ACALL	☐	ToDo by all recipients
37	ACONE	SOOS	ACONE		☐	SO_ACONE	☐	ToDo by one of the recipients in the group
38	ACINP	SOOS	ACINP		☐	SO_ACINP	☐	ToDo: status
39	OBJAC	SOOS	OBJAC		☐	SO_OBJ_AC	☐	The recipient must take action
40	OBJRR	SOOS	OBJRR		☐	SO_OBJ_RR	☐	A reply must be sent for this object
41	OBJRS	SOOS	OBJRS		☐	SO_OBJ_RS	☐	The reply to this object has already been sent
42	VMTYP	SOOD	VMTYP		☐	SO_VM_TYP	☐	Execute: Type (Report, Dialog Module, ...)
43	RESUB	SOFM	RESUB		☐	SO_RSUBM	☐	SAPoffice: folder entry is a resubmitted object
44	RECPRI	SOFM	RECPRI		☐	SO_REC_PRI	☐	Priority
45	FLAG1	SOFM	FLAG1		☐	SO_FLAG	☐	Search of private or shared folders
46	RBDAT	SOFM	RBDAT		☐	SO_DAT_RB	☐	Date On Which The Object Was Resubmitted
47	OBJPRI	SOOD	OBJPRI		☐	SO_OBJ_PRI	☐	Document priority
48	FILE_EXT	SOOD	FILE_EXT		☐	SO_FILEEXT	☐	File extension for PC application
49	ARCHI	SOOD	ARCHI		☐	SO_ARCHI	☐	The document is stored in archive
50	OBJCP	SOOD	OBJCP		☐	SO_OBJ_CP	☐	Document cannot be changed
51	FIXED	SOOD	FIXED		☐	SO_FIXED	☐	Check-in/check-out flag
52	FOLRG	SOOD	FOLRG		☐	SO_FOL_RG	☐	Folder: Area (private, shared folders)
53	OBJLEN	SOOD	OBJLEN		☐	SO_OBJ_LEN	☐	Size of Document Content
54	RECCNT	SOOD	RECCNT		☐	SO_RECCNT	☐	Number of recipients of the object
55	ACOUT	SOOD	ACOUT		☐	SO_ACOUT	☐	ToDo: To Be Completed Outside SAPoffice
56	SKIPS	SOOD	SKIPS		☐	SO_SKIPS	☐	Execute: Process First Screen in Background
57	ACNAM	SOOD	ACNAM		☐	SO_ACNAM	☐	Execute: Name of Report, FM, DB, TCode
58	RDDAT	SOOS	RDDAT		☐	SO_DAT_RD	☐	Date on which the sent document was read
59	RDTIM	SOOS	RDTIM		☐	SO_TIM_RD	☐	Time at which the document was viewed
60	SDDAT	SOOD	SDDAT		☐	SO_DAT_SD	☐	Date On Which Object Was Sent
61	SDTIM	SOOD	SDTIM		☐	SO_TIM_SD	☐	Time at Which The Object Was Sent
62	SNDPRI	SOOS	SNDPRI		☐	SO_SND_PRI	☐	Send: Priority
63	RRDCNT	SOOD	RRDCNT		☐	SO_RRDCNT	☐	Number of Recipients Who Have Read Object
64	RARCNT	SOOD	RARCNT		☐	SO_RARCNT	☐	Number of recipients who must take action
65	RAPCNT	SOOD	RAPCNT		☐	SO_RAPCNT	☐	Number of recipients processing the object
66	RATCNT	SOOD	RATCNT		☐	SO_RATCNT	☐	Number of recipients who have taken action
67	RCPCNT	SOOD	RCPCNT		☐	SO_RCPCNT	☐	Number of recipients of a copy
68	RBCCNT	SOOD	RBCCNT		☐	SO_RBCCNT	☐	Number of recipients of a blind copy
69	RRRCNT	SOOD	RRRCNT		☐	SO_RRRCNT	☐	Number of recipients who must reply to the object
70	RRPCNT	SOOD	RRPCNT		☐	SO_RRPCNT	☐	Number of recipients who have sent required reply
71	REXCNT	SOOD	REXCNT		☐	SO_REXCNT	☐	Number of recipients of the express message
72	FLAG2	SOFM	FLAG2		☐	SO_FLAG	☐	Search of private or shared folders
73	FPTTP	SOOS	FPTTP		☐	SO_FPT_TP	☐	Forward pointer for correspondence: Object type from ID
74	BPTTP	SOOS	BPTTP		☐	SO_BPT_TP	☐	Backward Pointer for Correspondence: Object Type from ID
75	ACMEM	SOOD	ACMEM		☐	SO_ACMEM	☐	Process: memory ID
76	CREATOR	SOOD	CREATOR		☐	SO_CREATOR	☐	Creator for MacIntosh-based files

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in