SAP table SOFD (SAPoffice: Object Definition)

SAP table SOFD has 4 primary key fields being MANDT,FOLTP,FOLYR,FOLNO.

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 * SO_FOL_NO
OWNTP Owner type from ID CHAR 3 0 TSOTD SO_OWN_TP
OWNYR Owner year from the ID CHAR 2 0 SO_OWN_YR
OWNNO Owner number from the ID CHAR 12 0 SOOD SO_OWN_NO
OBJLA Language in Which Document Is Created LANG 1 0 T002 SO_OBJ_LA
OBJSRT Sort field CHAR 10 0 SO_OBJ_SRT
OBJNAM Name of document, folder or distribution list CHAR 12 0 SO_OBJ_NAM
OBJDES Short description of contents CHAR 50 0 SO_OBJ_DES
CROTP User who created object: Object type from ID CHAR 3 0 TSOTD SO_CRO_TP
CROYR User that created object: year from the ID CHAR 2 0 SO_CRO_YR
CRONO User that created object: number from the ID CHAR 12 0 SOOD SO_CRO_NO
CRDAT Date created DATS 8 0 SO_DAT_CR
CRTIM Created At TIMS 6 0 SO_TIM_CR
CHOTP User that changed the object: Object type from ID CHAR 3 0 TSOTD SO_CHO_TP
CHOYR User that changed the object: year from the ID CHAR 2 0 SO_CHO_YR
CHONO User that changed the object: number from the ID CHAR 12 0 SOOD SO_CHO_NO
CHDAT Last Changed On DATS 8 0 SO_DAT_CH
CHTIM Time of Last Change TIMS 6 0 SO_TIM_CH
NOTTP Default setting of document class CHAR 3 0 TSOTD SO_NOT_TP
NOTYR Object note: year from the ID CHAR 2 0 SO_NOT_YR
NOTNO Object note: number from the ID CHAR 12 0 SOOD SO_NOT_NO
FOLRG Folder: Area (private, shared folders) CHAR 1 0 SO_FOL_RG
I Inbox
O Outbox
P Private folder
Q Shared folder
S System-wide trash
T Private trash
Y Workflow folder
LADAT Date of last access DATS 8 0 SO_DAT_LA
DLDAT Document Expiration Date DATS 8 0 SO_DAT_DL
DLTIM Expiry time of object TIMS 6 0 SO_TIM_DL
OBJSNS Object: Sensitivity (private, functional, ...) CHAR 1 0 SO_OBJ_SNS
E Private
F Functional
G Business
O Standard
P Confidential
FIXED Check-in/check-out flag CHAR 1 0 SO_FIXED
PARTP Parent object type from ID CHAR 3 0 TSOTD SO_PAR_TP
PARYR Parent object year from the ID CHAR 2 0 SO_PAR_YR
PARNO Parent object number from the ID CHAR 12 0 SOOD SO_PAR_NO
FOLCNT Number of documents stored in this folder NUMC 5 0 SO_FOL_SIZ
FOLSIZ Number of documents stored in this folder NUMC 5 0 SO_FOL_SIZ
TPONLY Only this object type can be stored in this folder CHAR 3 0 TSOTD SO_TPONLY
LIFSP Retention period of documents in folder NUMC 5 0 SO_LIFSP
FOLINDEX Index folder and documents contained in it CHAR 1 0 SO_INDEX
PFLCL Private folder class CHAR 1 0 SO_PFLCL
ICLASS Information class for indexing CHAR 4 0 TFIC SF_ICLASS
DLITP Distribution list type from ID CHAR 3 0 TSOTD SO_DLI_TP
DLIYR Distribution list year from the ID CHAR 2 0 SO_DLI_YR
DLINO Distribution list: number from the ID CHAR 12 0 SOOD SO_DLI_NO
FOLSEC Folder area (private, client, group, ...) CHAR 1 0 SO_FOL_SEC
G Group folder (shared folders only)
M Client-wide folder (shared folders only)
P Private folder (private folders only)
FOLTYPE SAPoffice: Folder type CHAR 4 0 SO_FOL_TY
LAFDAT Date of last access DATS 8 0 SO_DAT_LA

SOFD foreign key relationships

Table Field Check Table Check Field
0 SOFD CHONO SOOD SAPoffice: Object definition MANDT
0 SOFD CHONO SOOD SAPoffice: Object definition OBJTP
0 SOFD CHONO SOOD SAPoffice: Object definition OBJYR
0 SOFD CHONO SOOD SAPoffice: Object definition OBJNO
1 SOFD CHOTP TSOTD Valid Object Types OBJTP
0 SOFD CRONO SOOD SAPoffice: Object definition MANDT
0 SOFD CRONO SOOD SAPoffice: Object definition OBJTP
0 SOFD CRONO SOOD SAPoffice: Object definition OBJYR
0 SOFD CRONO SOOD SAPoffice: Object definition OBJNO
1 SOFD CROTP TSOTD Valid Object Types OBJTP
0 SOFD DLINO SOOD SAPoffice: Object definition MANDT
0 SOFD DLINO SOOD SAPoffice: Object definition OBJTP
0 SOFD DLINO SOOD SAPoffice: Object definition OBJYR
0 SOFD DLINO SOOD SAPoffice: Object definition OBJNO
1 SOFD DLITP TSOTD Valid Object Types OBJTP
0 SOFD FOLTP TSOTD Valid Object Types OBJTP
1 SOFD ICLASS TFIC Class Table for SAPfind CLASS
0 SOFD NOTNO SOOD SAPoffice: Object definition MANDT
0 SOFD NOTNO SOOD SAPoffice: Object definition OBJTP
0 SOFD NOTNO SOOD SAPoffice: Object definition OBJYR
0 SOFD NOTNO SOOD SAPoffice: Object definition OBJNO
1 SOFD NOTTP TSOTD Valid Object Types OBJTP
0 SOFD OBJLA T002 Language Keys (Component BC-I18) SPRAS
1 SOFD OWNNO SOOD SAPoffice: Object definition MANDT
1 SOFD OWNNO SOOD SAPoffice: Object definition OBJTP
1 SOFD OWNNO SOOD SAPoffice: Object definition OBJYR
1 SOFD OWNNO SOOD SAPoffice: Object definition OBJNO
0 SOFD OWNTP TSOTD Valid Object Types OBJTP
1 SOFD PARNO SOOD SAPoffice: Object definition MANDT
1 SOFD PARNO SOOD SAPoffice: Object definition OBJTP
1 SOFD PARNO SOOD SAPoffice: Object definition OBJYR
1 SOFD PARNO SOOD SAPoffice: Object definition OBJNO
0 SOFD PARTP TSOTD Valid Object Types OBJTP
1 SOFD TPONLY TSOTD Valid Object Types OBJTP