SAP ABAP View V_SOFMSOFD (SAPoffice: Join Between Folder Entry and Folder Definition)

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_SOFMSOFD
Short Description	SAPoffice: Join Between Folder Entry and Folder Definition
Root table	SOFM	SAPoffice: Folder contents

Table

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

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	SOFM	MANDT	JR	EQ			AND	0	0
3	SOFD	FOLTP	JL	EQ				0	0
4	SOFM	FOLTP	JR	EQ			AND	0	0
5	SOFD	FOLYR	JL	EQ				0	0
6	SOFM	FOLYR	JR	EQ			AND	0	0
7	SOFD	FOLNO	JL	EQ				0	0
8	SOFM	FOLNO	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	DOCTP	SOFM	DOCTP		☐	SO_DOC_TP	☐	Object: Object Type From ID
6	DOCYR	SOFM	DOCYR		☐	SO_DOC_YR	☐	Object: Year from ID
7	DOCNO	SOFM	DOCNO		☐	SO_DOC_NO	☐	Object: Number from ID
8	FORTP	SOFM	FORTP		☐	SO_FOR_TP	☐	Forwarder: Object type from ID
9	FORYR	SOFM	FORYR		☐	SO_FOR_YR	☐	Forwarder: year from the ID
10	FORNO	SOFM	FORNO		☐	SO_FOR_NO	☐	Forwarder: number from the ID
11	FOLRG	SOFD	FOLRG		☐	SO_FOL_RG	☐	Folder: Area (private, shared folders)
12	FOLNAM	SOFD	OBJNAM		☐	SO_OBJ_NAM	☐	Name of document, folder or distribution list
13	FOLDES	SOFD	OBJDES		☐	SO_OBJ_DES	☐	Short description of contents
14	OWNTP	SOFD	OWNTP		☐	SO_OWN_TP	☐	Owner type from ID
15	OWNYR	SOFD	OWNYR		☐	SO_OWN_YR	☐	Owner year from the ID
16	OWNNO	SOFD	OWNNO		☐	SO_OWN_NO	☐	Owner number from the ID
17	OBJSNS	SOFD	OBJSNS		☐	SO_OBJ_SNS	☐	Object: Sensitivity (private, functional, ...)

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