SAP ABAP View V_SOFC_ATT (SAPoffice: Projection of Folder View)

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_SOFC_ATT
Short Description	SAPoffice: Projection of Folder View
Root table	SOFM	SAPoffice: Folder contents

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SOFM	SOFM
2	SOOD	PEST01

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	SOFM	MANDT	JR	EQ			AND	0	0
3	SOOD	OBJTP	JL	EQ				0	0
4	SOFM	DOCTP	JR	EQ			AND	0	0
5	SOOD	OBJYR	JL	EQ				0	0
6	SOFM	DOCYR	JR	EQ			AND	0	0
7	SOOD	OBJNO	JL	EQ				0	0
8	SOFM	DOCNO	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	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	OBJSND	SOOD	OBJSND		☐	SO_OBJ_SND	☐	Object has already been sent
25	RECCNT	SOOD	RECCNT		☐	SO_RECCNT	☐	Number of recipients of the object
26	SDDAT	SOOD	SDDAT		☐	SO_DAT_SD	☐	Date On Which Object Was Sent
27	SDTIM	SOOD	SDTIM		☐	SO_TIM_SD	☐	Time at Which The Object Was Sent
28	RRDCNT	SOOD	RRDCNT		☐	SO_RRDCNT	☐	Number of Recipients Who Have Read Object
29	SNDBC	SOFM	SNDBC		☐	SO_SND_BC	☐	Send as a blind copy
30	RARCNT	SOOD	RARCNT		☐	SO_RARCNT	☐	Number of recipients who must take action
31	RAPCNT	SOOD	RAPCNT		☐	SO_RAPCNT	☐	Number of recipients processing the object
32	RATCNT	SOOD	RATCNT		☐	SO_RATCNT	☐	Number of recipients who have taken action
33	RCPCNT	SOOD	RCPCNT		☐	SO_RCPCNT	☐	Number of recipients of a copy
34	RBCCNT	SOOD	RBCCNT		☐	SO_RBCCNT	☐	Number of recipients of a blind copy
35	RRRCNT	SOOD	RRRCNT		☐	SO_RRRCNT	☐	Number of recipients who must reply to the object
36	RRPCNT	SOOD	RRPCNT		☐	SO_RRPCNT	☐	Number of recipients who have sent required reply
37	VMTYP	SOOD	VMTYP		☐	SO_VM_TYP	☐	Execute: Type (Report, Dialog Module, ...)
38	RESUB	SOFM	RESUB		☐	SO_RSUBM	☐	SAPoffice: folder entry is a resubmitted object
39	RECPRI	SOFM	RECPRI		☐	SO_REC_PRI	☐	Priority
40	FLAG1	SOFM	FLAG1		☐	SO_FLAG	☐	Search of private or shared folders
41	RBDAT	SOFM	RBDAT		☐	SO_DAT_RB	☐	Date On Which The Object Was Resubmitted
42	OBJPRI	SOOD	OBJPRI		☐	SO_OBJ_PRI	☐	Document priority
43	OBJSNS	SOOD	OBJSNS		☐	SO_OBJ_SNS	☐	Object: Sensitivity (private, functional, ...)
44	OBJCP	SOOD	OBJCP		☐	SO_OBJ_CP	☐	Document cannot be changed
45	FIXED	SOOD	FIXED		☐	SO_FIXED	☐	Check-in/check-out flag
46	FILE_EXT	SOOD	FILE_EXT		☐	SO_FILEEXT	☐	File extension for PC application
47	LFOLTP	SOFM	LFOLTP		☐	SO_FOL_TP	☐	Object folder: Object type from ID
48	LFOLYR	SOFM	LFOLYR		☐	SO_FOL_YR	☐	Object folder: Year from ID
49	LFOLNO	SOFM	LFOLNO		☐	SO_FOL_NO	☐	Object folder: Number from ID
50	ARCHI	SOOD	ARCHI		☐	SO_ARCHI	☐	The document is stored in archive
51	FOLRG	SOOD	FOLRG		☐	SO_FOL_RG	☐	Folder: Area (private, shared folders)
52	OBJLEN	SOOD	OBJLEN		☐	SO_OBJ_LEN	☐	Size of Document Content
53	OBJRD	SOFM	OBJRD		☐	SO_OBJ_RD	☐	Object has already been viewed
54	ATTLEN	SOOD	ATTLEN		☐	SO_ATT_LEN	☐	Total size of all attachments to a document
55	CROTP	SOOD	CROTP		☐	SO_CRO_TP	☐	User who created object: Object type from ID
56	CROYR	SOOD	CROYR		☐	SO_CRO_YR	☐	User that created object: year from the ID
57	CRONO	SOOD	CRONO		☐	SO_CRO_NO	☐	User that created object: number from the ID
58	CHOTP	SOOD	CHOTP		☐	SO_CHO_TP	☐	User that changed the object: Object type from ID
59	CHOYR	SOOD	CHOYR		☐	SO_CHO_YR	☐	User that changed the object: year from the ID
60	CHONO	SOOD	CHONO		☐	SO_CHO_NO	☐	User that changed the object: number from the ID

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