SAP ABAP View V_SOFMFDOD (View via SOFD SOFM SOOD?)

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_SOFMFDOD
Short Description	View via SOFD SOFM SOOD?
Root table	SOFD	SAPoffice: Object Definition

Table

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

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			AND	0	0
9	SOFM	MANDT	JL	EQ				0	0
10	SOOD	MANDT	JR	EQ			AND	0	0
11	SOFM	DOCTP	JL	EQ				0	0
12	SOOD	OBJTP	JR	EQ			AND	0	0
13	SOFM	DOCYR	JL	EQ				0	0
14	SOOD	OBJYR	JR	EQ			AND	0	0
15	SOFM	DOCNO	JL	EQ				0	0
16	SOOD	OBJNO	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	OBJTP	SOFM	DOCTP		☐	SO_DOC_TP	☐	Object: Object Type From ID
6	OBJYR	SOFM	DOCYR		☐	SO_DOC_YR	☐	Object: Year from ID
7	OBJNO	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	OWNTP	SOFD	OWNTP		☐	SO_OWN_TP	☐	Owner type from ID
13	OWNYR	SOFD	OWNYR		☐	SO_OWN_YR	☐	Owner year from the ID
14	OWNNO	SOFD	OWNNO		☐	SO_OWN_NO	☐	Owner number from the ID
15	CRDAT	SOOD	CRDAT		☐	SO_DAT_CR	☐	Date created
16	CHDAT	SOOD	CHDAT		☐	SO_DAT_CH	☐	Date of Last Change
17	OBJLEN	SOOD	OBJLEN		☐	SO_OBJ_LEN	☐	Size of Document Content
18	ATTLEN	SOOD	ATTLEN		☐	SO_ATT_LEN	☐	Total size of all attachments to a document
19	ENCCNT	SOOD	ENCCNT		☐	SO_ENC_CNT	☐	Number of attachments for the object
20	FOLNAM	SOFD	OBJNAM		☐	SO_OBJ_NAM	☐	Name of document, folder or distribution list
21	FOLDES	SOFD	OBJDES		☐	SO_OBJ_DES	☐	Short description of contents
22	OBJNAM	SOOD	OBJNAM		☐	SO_OBJ_NAM	☐	Name of document, folder or distribution list
23	OBJDES	SOOD	OBJDES		☐	SO_OBJ_DES	☐	Short description of contents
24	LADAT	SOOD	LADAT		☐	SO_DAT_LA	☐	Date of last access
25	FILE_EXT	SOOD	FILE_EXT		☐	SO_FILEEXT	☐	File extension for PC application

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