SAP ABAP View V_SOFDSOFA (SAPoffice: Join for Selecting Folders Subscribed to)

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_SOFDSOFA
Short Description	SAPoffice: Join for Selecting Folders Subscribed to
Root table	SOFD	SAPoffice: Object Definition

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SOFD	MANDT	JL	EQ				0	0
2	SOFA	MANDT	JR	EQ			AND	0	0
3	SOFD	FOLTP	JL	EQ				0	0
4	SOFA	FOLTP	JR	EQ			AND	0	0
5	SOFD	FOLYR	JL	EQ				0	0
6	SOFA	FOLYR	JR	EQ			AND	0	0
7	SOFD	FOLNO	JL	EQ				0	0
8	SOFA	FOLNO	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	SOFD	FOLTP		☐	SO_FOL_TP	☐	Object folder: Object type from ID
3	FOLYR	SOFD	FOLYR		☐	SO_FOL_YR	☐	Object folder: Year from ID
4	FOLNO	SOFD	FOLNO		☐	SO_FOL_NO	☐	Object folder: Number from ID
5	USRTP	SOFA	USRTP		☐	SO_USR_TP	☐	User type from ID
6	USRYR	SOFA	USRYR		☐	SO_USR_YR	☐	User year from the ID
7	USRNO	SOFA	USRNO		☐	SO_USR_NO	☐	User number from the ID
8	ABO	SOFA	FLAG2		☐	SO_FLAG	☐	Search of private or shared folders
9	PARTP	SOFD	PARTP		☐	SO_PAR_TP	☐	Parent object type from ID
10	PARYR	SOFD	PARYR		☐	SO_PAR_YR	☐	Parent object year from the ID
11	PARNO	SOFD	PARNO		☐	SO_PAR_NO	☐	Parent object number from the ID
12	OBJNAM	SOFD	OBJNAM		☐	SO_OBJ_NAM	☐	Name of document, folder or distribution list
13	OBJDES	SOFD	OBJDES		☐	SO_OBJ_DES	☐	Short description of contents
14	FOLRG	SOFD	FOLRG		☐	SO_FOL_RG	☐	Folder: Area (private, shared folders)
15	FOLCNT	SOFD	FOLCNT		☐	SO_FOL_SIZ	☐	Number of documents stored in this folder
16	FOLSIZ	SOFD	FOLSIZ		☐	SO_FOL_SIZ	☐	Number of documents stored in this folder
17	LAFDAT	SOFD	LAFDAT		☐	SO_DAT_LA	☐	Date of last access
18	LADAT	SOFD	LADAT		☐	SO_DAT_LA	☐	Date of last access
19	FOLSEC	SOFD	FOLSEC		☐	SO_FOL_SEC	☐	Folder area (private, client, group, ...)
20	PFLCL	SOFD	PFLCL		☐	SO_PFLCL	☐	Private folder class
21	LIFSP	SOFD	LIFSP		☐	SO_LIFSP	☐	Retention period of documents in folder
22	USRACC	SOFA	USRACC		☐	SO_AUT_FOL	☐	Authorizations for shared folders
23	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