SAP ABAP View V_SORDFDFA (SAPoffice: Unviewed shared folders in subscribed list)

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_SORDFDFA
Short Description	SAPoffice: Unviewed shared folders in subscribed list
Root table	SORD	SAPoffice: Viewed Records for Shared Folders

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SORD	SORD
2	SOFD
3	SOFA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SORD	MANDT	JL	EQ				0	0
2	SOFD	MANDT	JR	EQ			AND	0	0
3	SORD	OBJTP	JL	EQ				0	0
4	SOFD	FOLTP	JR	EQ			AND	0	0
5	SORD	OBJYR	JL	EQ				0	0
6	SOFD	FOLYR	JR	EQ			AND	0	0
7	SORD	OBJNO	JL	EQ				0	0
8	SOFD	FOLNO	JR	EQ			AND	0	0
9	SOFD	MANDT	JL	EQ				0	0
10	SOFA	MANDT	JR	EQ			AND	0	0
11	SOFD	FOLTP	JL	EQ				0	0
12	SOFA	FOLTP	JR	EQ			AND	0	0
13	SOFD	FOLYR	JL	EQ				0	0
14	SOFA	FOLYR	JR	EQ			AND	0	0
15	SOFD	FOLNO	JL	EQ				0	0
16	SOFA	FOLNO	JR	EQ			AND	0	0
17	SORD	USRTP	JL	EQ				0	0
18	SOFA	USRTP	JR	EQ			AND	0	0
19	SORD	USRYR	JL	EQ				0	0
20	SOFA	USRYR	JR	EQ			AND	0	0
21	SORD	USRNO	JL	EQ				0	0
22	SOFA	USRNO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SOFD	MANDT		☐	MANDT	☐	Client
2	FOLTP	SORD	OBJTP		☐	SO_OBJ_TP	☐	Code for document class
3	FOLYR	SORD	OBJYR		☐	SO_OBJ_YR	☐	Object: Year from ID
4	FOLNO	SORD	OBJNO		☐	SO_OBJ_NO	☐	Object: 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	PARTP	SOFD	PARTP		☐	SO_PAR_TP	☐	Parent object type from ID
9	PARYR	SOFD	PARYR		☐	SO_PAR_YR	☐	Parent object year from the ID
10	PARNO	SOFD	PARNO		☐	SO_PAR_NO	☐	Parent object number from the ID
11	OBJNAM	SOFD	OBJNAM		☐	SO_OBJ_NAM	☐	Name of document, folder or distribution list
12	OBJDES	SOFD	OBJDES		☐	SO_OBJ_DES	☐	Short description of contents
13	FOLRG	SOFD	FOLRG		☐	SO_FOL_RG	☐	Folder: Area (private, shared folders)
14	FOLCNT	SOFD	FOLCNT		☐	SO_FOL_SIZ	☐	Number of documents stored in this folder
15	FOLSIZ	SOFD	FOLSIZ		☐	SO_FOL_SIZ	☐	Number of documents stored in this folder
16	LAFDAT	SOFD	LAFDAT		☐	SO_DAT_LA	☐	Date of last access
17	LADAT	SOFD	LADAT		☐	SO_DAT_LA	☐	Date of last access
18	FOLSEC	SOFD	FOLSEC		☐	SO_FOL_SEC	☐	Folder area (private, client, group, ...)
19	PFLCL	SOFD	PFLCL		☐	SO_PFLCL	☐	Private folder class
20	LIFSP	SOFD	LIFSP		☐	SO_LIFSP	☐	Retention period of documents in folder
21	USRACC	SOFA	USRACC		☐	SO_AUT_FOL	☐	Authorizations for shared folders
22	DL	SOFA	FLAG1		☐	SO_FLAG	☐	Search of private or shared folders

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