SAP ABAP Table V_SOFD (Generated Table for View V_SOFD)

Basic Data

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

Delivery and Maintenance

Pool/cluster	SOFD
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	OWNTP	☐	SO_OWN_TP	SO_OBJ_TP	CHAR	3	0	Owner type from ID	TSOTD
6	OWNYR	☐	SO_OWN_YR	SO_OBJ_YR	CHAR	2	0	Owner year from the ID
7	OWNNO	☐	SO_OWN_NO	SO_OBJ_NO	CHAR	12	0	Owner number from the ID	SOOD
8	OBJLA	☐	SO_OBJ_LA	SPRAS	LANG	1	0	Language in Which Document Is Created	T002
9	OBJNAM	☐	SO_OBJ_NAM	SO_OBJ_NAM	CHAR	12	0	Name of document, folder or distribution list
10	OBJDES	☐	SO_OBJ_DES	SO_OBJ_DES	CHAR	50	0	Short description of contents
11	FOLRG	☐	SO_FOL_RG	SO_FOL_RG	CHAR	1	0	Folder: Area (private, shared folders)
12	LADAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access
13	OBJSNS	☐	SO_OBJ_SNS	SO_OBJ_SNS	CHAR	1	0	Object: Sensitivity (private, functional, ...)
14	PARTP	☐	SO_PAR_TP	SO_OBJ_TP	CHAR	3	0	Parent object type from ID	TSOTD
15	PARYR	☐	SO_PAR_YR	SO_OBJ_YR	CHAR	2	0	Parent object year from the ID
16	PARNO	☐	SO_PAR_NO	SO_OBJ_NO	CHAR	12	0	Parent object number from the ID	SOOD
17	FOLCNT	☐	SO_FOL_SIZ	SO_OBJ_SIZ	NUMC	5	0	Number of documents stored in this folder
18	FOLSEC	☐	SO_FOL_SEC	SO_FOL_SEC	CHAR	1	0	Folder area (private, client, group, ...)
19	LAFDAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SOFD	FOLTP	TSOTD	OBJTP	KEY	1	CN
2	V_SOFD	MANDT	T000	MANDT	KEY	1	CN
3	V_SOFD	OBJLA	T002	SPRAS	KEY	1	1
4	V_SOFD	OWNNO	SOOD	OBJNO	KEY	1	CN
5	V_SOFD	OWNTP	TSOTD	OBJTP	KEY	1	CN
6	V_SOFD	PARNO	SOOD	OBJNO	REF	C	CN
7	V_SOFD	PARTP	TSOTD	OBJTP	REF	C	CN

History

Last changed by/on	SAP	20041216
SAP Release Created in