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

SAP table SOFA has 7 primary key fields being MANDT,FOLTP,FOLYR,FOLNO,USRTP,USRYR,USRNO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

SOFA foreign key relationships

Table Field Check Table Check Field
0 SOFA FOLNO SOFD SAPoffice: Object Definition MANDT
0 SOFA FOLNO SOFD SAPoffice: Object Definition FOLTP
1 SOFA FOLTP TSOTD Valid Object Types OBJTP
0 SOFA USRTP TSOTD Valid Object Types OBJTP