SAP ABAP Table V_SOFDSOFA (Generated Table for View V_SOFDSOFA)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SOFDSOFA	Table Relationship Diagram
Short Description	Generated Table for View V_SOFDSOFA

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	FOLTP	☑	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID	TSOTD
3	FOLYR	☑	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
4	FOLNO	☑	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID
5	USRTP	☑	SO_USR_TP	SO_OBJ_TP	CHAR	3	0	User type from ID	TSOTD
6	USRYR	☑	SO_USR_YR	SO_OBJ_YR	CHAR	2	0	User year from the ID
7	USRNO	☑	SO_USR_NO	SO_USR_NO	CHAR	12	0	User number from the ID
8	ABO	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
9	PARTP	☐	SO_PAR_TP	SO_OBJ_TP	CHAR	3	0	Parent object type from ID	TSOTD
10	PARYR	☐	SO_PAR_YR	SO_OBJ_YR	CHAR	2	0	Parent object year from the ID
11	PARNO	☐	SO_PAR_NO	SO_OBJ_NO	CHAR	12	0	Parent object number from the ID	SOOD
12	OBJNAM	☐	SO_OBJ_NAM	SO_OBJ_NAM	CHAR	12	0	Name of document, folder or distribution list
13	OBJDES	☐	SO_OBJ_DES	SO_OBJ_DES	CHAR	50	0	Short description of contents
14	FOLRG	☐	SO_FOL_RG	SO_FOL_RG	CHAR	1	0	Folder: Area (private, shared folders)
15	FOLCNT	☐	SO_FOL_SIZ	SO_OBJ_SIZ	NUMC	5	0	Number of documents stored in this folder
16	FOLSIZ	☐	SO_FOL_SIZ	SO_OBJ_SIZ	NUMC	5	0	Number of documents stored in this folder
17	LAFDAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access
18	LADAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access
19	FOLSEC	☐	SO_FOL_SEC	SO_FOL_SEC	CHAR	1	0	Folder area (private, client, group, ...)
20	PFLCL	☐	SO_PFLCL	SO_FOL_CL	CHAR	1	0	Private folder class
21	LIFSP	☐	SO_LIFSP	SO_NUM5	NUMC	5	0	Retention period of documents in folder
22	USRACC	☐	SO_AUT_FOL	SO_FOL_AUT	CHAR	1	0	Authorizations for shared folders
23	DL	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SOFDSOFA	FOLTP	TSOTD	OBJTP	KEY	1	CN
2	V_SOFDSOFA	MANDT	T000	MANDT	KEY	1	CN
3	V_SOFDSOFA	PARNO	SOOD	OBJNO	REF	C	CN
4	V_SOFDSOFA	PARTP	TSOTD	OBJTP	REF	C	CN
5	V_SOFDSOFA	USRTP	TSOTD	OBJTP	KEY	1	1

History

Last changed by/on	SAP	20010619
SAP Release Created in