SAP ABAP View V_SORDSOOD (SAPoffice: Join for Selecting Unviewed Shared Documents)

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_SORDSOOD
Short Description	SAPoffice: Join for Selecting Unviewed Shared Documents
Root table	SORD	SAPoffice: Viewed Records for Shared Folders

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SORD	SORD
2	SOOD
3	SOFM

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	SORD	MANDT	JR	EQ			AND	0	0
3	SOOD	OBJTP	JL	EQ				0	0
4	SORD	OBJTP	JR	EQ			AND	0	0
5	SOOD	OBJYR	JL	EQ				0	0
6	SORD	OBJYR	JR	EQ			AND	0	0
7	SOOD	OBJNO	JL	EQ				0	0
8	SORD	OBJNO	JR	EQ			AND	0	0
9	SOOD	MANDT	JL	EQ				0	0
10	SOFM	MANDT	JR	EQ			AND	0	0
11	SOOD	OBJTP	JL	EQ				0	0
12	SOFM	DOCTP	JR	EQ			AND	0	0
13	SOOD	OBJYR	JL	EQ				0	0
14	SOFM	DOCYR	JR	EQ			AND	0	0
15	SOOD	OBJNO	JL	EQ				0	0
16	SOFM	DOCNO	JR	EQ			AND	0	0
17	SORD	FOLTP	JL	EQ				0	0
18	SOFM	FOLTP	JR	EQ			AND	0	0
19	SORD	FOLYR	JL	EQ				0	0
20	SOFM	FOLYR	JR	EQ			AND	0	0
21	SORD	FOLNO	JL	EQ				0	0
22	SOFM	FOLNO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SORD	MANDT		☐	MANDT	☐	Client
2	FOLTP	SORD	FOLTP		☐	SO_FOL_TP	☐	Object folder: Object type from ID
3	FOLYR	SORD	FOLYR		☐	SO_FOL_YR	☐	Object folder: Year from ID
4	FOLNO	SORD	FOLNO		☐	SO_FOL_NO	☐	Object folder: Number from ID
5	USRTP	SORD	USRTP		☐	SO_USR_TP	☐	User type from ID
6	USRYR	SORD	USRYR		☐	SO_USR_YR	☐	User year from the ID
7	USRNO	SORD	USRNO		☐	SO_USR_NO	☐	User number from the ID
8	DOCTP	SORD	OBJTP		☐	SO_OBJ_TP	☐	Code for document class
9	DOCYR	SORD	OBJYR		☐	SO_OBJ_YR	☐	Object: Year from ID
10	DOCNO	SORD	OBJNO		☐	SO_OBJ_NO	☐	Object: Number from ID
11	DOCNAM	SOOD	OBJNAM		☐	SO_OBJ_NAM	☐	Name of document, folder or distribution list
12	DOCDES	SOOD	OBJDES		☐	SO_OBJ_DES	☐	Short description of contents
13	DOCLA	SOOD	OBJLA		☐	SO_OBJ_LA	☐	Language in Which Document Is Created
14	CRDAT	SOOD	CRDAT		☐	SO_DAT_CR	☐	Date created
15	CRTIM	SOOD	CRTIM		☐	SO_TIM_CR	☐	Time created
16	CHDAT	SOOD	CHDAT		☐	SO_DAT_CH	☐	Date of Last Change
17	CHTIM	SOOD	CHTIM		☐	SO_TIM_CH	☐	Time of Last Change
18	LADAT	SOOD	LADAT		☐	SO_DAT_LA	☐	Date of last access
19	DLDAT	SOFM	DLDAT		☐	SO_DAT_DL	☐	Document Expiration Date
20	OWNTP	SOOD	OWNTP		☐	SO_OWN_TP	☐	Owner type from ID
21	OWNYR	SOOD	OWNYR		☐	SO_OWN_YR	☐	Owner year from the ID
22	OWNNO	SOOD	OWNNO		☐	SO_OWN_NO	☐	Owner number from the ID
23	ENCCNT	SOOD	ENCCNT		☐	SO_ENC_CNT	☐	Number of attachments for the object
24	VMTYP	SOOD	VMTYP		☐	SO_VM_TYP	☐	Execute: Type (Report, Dialog Module, ...)
25	OBJCP	SOOD	OBJCP		☐	SO_OBJ_CP	☐	Document cannot be changed
26	FILE_EXT	SOOD	FILE_EXT		☐	SO_FILEEXT	☐	File extension for PC application
27	ARCHI	SOOD	ARCHI		☐	SO_ARCHI	☐	The document is stored in archive
28	ACOUT	SOOD	ACOUT		☐	SO_ACOUT	☐	ToDo: To Be Completed Outside SAPoffice
29	SKIPS	SOOD	SKIPS		☐	SO_SKIPS	☐	Execute: Process First Screen in Background
30	ACNAM	SOOD	ACNAM		☐	SO_ACNAM	☐	Execute: Name of Report, FM, DB, TCode
31	ACMEM	SOOD	ACMEM		☐	SO_ACMEM	☐	Process: memory ID
32	OBJLEN	SOOD	OBJLEN		☐	SO_OBJ_LEN	☐	Size of Document Content
33	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	20010619
SAP Release Created in