SAP ABAP Table V_SOIC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SOIC	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SOIC	BPTTP	TSOTD	OBJTP	REF	1	1
2	V_SOIC	DOCLA	T002	SPRAS	REF	1	1
3	V_SOIC	DOCNO	SOOD	OBJNO	KEY	1	CN
4	V_SOIC	DOCTP	TSOTD	OBJTP	KEY	1	1
5	V_SOIC	FOLNO	SOFD	FOLNO	KEY	1	CN
6	V_SOIC	FOLTP	TSOTD	OBJTP	KEY	1	1
7	V_SOIC	FORTP	TSOTD	OBJTP	KEY	1	1
8	V_SOIC	FPTTP	TSOTD	OBJTP	REF	1	1
9	V_SOIC	MANDT	T000	MANDT	KEY	1	1
10	V_SOIC	OWNTP	TSOTD	OBJTP	REF	1	1
11	V_SOIC	RECTP	TSOTD	OBJTP	KEY	1	1
12	V_SOIC	VMTYP	TSOVM	VMTYP	REF	1	1

History

Last changed by/on	SAP	20130604
SAP Release Created in