SAP ABAP Table SOFA (SAPoffice: user-specific authorization for shared folders)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     ⤷ SO (Package) SAPoffice

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SOFA	Table Relationship Diagram
Short Description	SAPoffice: user-specific authorization for shared folders

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	SOFD
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	USRACC	☐	SO_AUT_FOL	SO_FOL_AUT	CHAR	1	0	Authorizations for shared folders
9	FLAG1	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
10	FLAG2	☐	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	SOFA	FOLNO	SOFD	FOLNO	KEY		CN
2	SOFA	FOLTP	TSOTD	OBJTP	KEY	1	1
3	SOFA	MANDT	T000	MANDT	KEY	1	1
4	SOFA	USRTP	TSOTD	OBJTP	KEY	1	1

History

Last changed by/on	SAP	19970214
SAP Release Created in