1. Home
  2. Resources
  3. SAP Tables
  4. SOFA - SAPoffice: user-specific authorization for shared folders

SAP Table SOFA

SAPoffice: user-specific authorization for shared folders

SOFA (SAPoffice: user-specific authorization for shared folders) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SOFA to other SAP tables.

SOFA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FOLTP Object folder: Object type from ID SO_FOL_TP TSOTD CHAR 3 0
FOLYR Object folder: Year from ID SO_FOL_YR CHAR 2 0
FOLNO Object folder: Number from ID SO_FOL_NO SOFD CHAR 12 0
USRTP User type from ID SO_USR_TP TSOTD CHAR 3 0
USRYR User year from the ID SO_USR_YR CHAR 2 0
USRNO User number from the ID SO_USR_NO CHAR 12 0
USRACC Authorizations for shared folders SO_AUT_FOL CHAR 1 0
1 Display folder and documents in the folder
2 Change documents in the folder
3 Change folder and authorization list
FLAG1 Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated
FLAG2 Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated

SOFA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SOFA FOLNO SOFA MANDT SOFD SAPoffice: Object Definition MANDT
SOFA FOLNO SOFA FOLTP SOFD SAPoffice: Object Definition FOLTP
SOFA FOLNO SOFA FOLYR SOFD SAPoffice: Object Definition FOLYR
SOFA FOLNO SOFA FOLNO SOFD SAPoffice: Object Definition FOLNO
SOFA FOLTP SOFA FOLTP TSOTD Valid Object Types OBJTP
SOFA MANDT SOFA MANDT T000 Clients MANDT
SOFA USRTP SOFA USRTP TSOTD Valid Object Types OBJTP