SAP SOFA SAPoffice: user-specific authorization for shared folders Table data and field list

SOFA is a standard SAP Table which is used to store SAPoffice: user-specific authorization for shared folders data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The SOFA table consists of various fields, each holding specific information or linking keys about SAPoffice: user-specific authorization for shared folders data available in SAP. These include FOLTP (Object folder: Object type from ID), FOLYR (Object folder: Year from ID), FOLNO (Object folder: Number from ID), USRTP (User type from ID)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

SOFA table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP SOFA table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the SOFA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
FOLTP	Object folder: Object type from ID	SO_FOL_TP	CHAR	3	TSOTD		SO_OBJ_TP
FOLYR	Object folder: Year from ID	SO_FOL_YR	CHAR	2			SO_OBJ_YR
FOLNO	Object folder: Number from ID	SO_FOL_NO	CHAR	12	SOFD		SO_OBJ_NO
USRTP	User type from ID	SO_USR_TP	CHAR	3	TSOTD		SO_OBJ_TP
USRYR	User year from the ID	SO_USR_YR	CHAR	2			SO_OBJ_YR
USRNO	User number from the ID	SO_USR_NO	CHAR	12	Assigned to domain		SO_USR_NO
USRACC	Authorizations for shared folders	SO_AUT_FOL	CHAR	1			SO_FOL_AUT
FLAG1	Search of private or shared folders	SO_FLAG	CHAR	1			SO_FLAG
FLAG2	Search of private or shared folders	SO_FLAG	CHAR	1			SO_FLAG

Key field

Non-key field

< SOEXTRECI1 - SAPoffice: Structure of the External Recipient List SOFAD - SAPoffice: user-specific folder authorization (data div.) >

How do I retrieve data from SAP table SOFA using ABAP code

The following ABAP code Example will allow you to do a basic selection on SOFA to SELECT all data from the table
DATA: WA_SOFA TYPE SOFA.

SELECT SINGLE *
FROM SOFA
INTO CORRESPONDING FIELDS OF WA_SOFA
WHERE...

How to access SAP table SOFA

Within an ECC or HANA version of SAP you can also view further information about SOFA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).