1. Home
  2. Resources
  3. SAP Tables
  4. SOFD - SAPoffice: Object Definition

SAP Table SOFD

SAPoffice: Object Definition

SOFD (SAPoffice: Object Definition) 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 SOFD to other SAP tables.

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

SOFD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SOFD CHONO SOFD MANDT SOOD SAPoffice: Object definition MANDT
SOFD CHONO SOFD CHOTP SOOD SAPoffice: Object definition OBJTP
SOFD CHONO SOFD CHOYR SOOD SAPoffice: Object definition OBJYR
SOFD CHONO SOFD CHONO SOOD SAPoffice: Object definition OBJNO
SOFD CHOTP SOFD CHOTP TSOTD Valid Object Types OBJTP
SOFD CRONO SOFD CROYR SOOD SAPoffice: Object definition OBJYR
SOFD CRONO SOFD CRONO SOOD SAPoffice: Object definition OBJNO
SOFD CRONO SOFD MANDT SOOD SAPoffice: Object definition MANDT
SOFD CRONO SOFD CROTP SOOD SAPoffice: Object definition OBJTP
SOFD CROTP SOFD CROTP TSOTD Valid Object Types OBJTP
SOFD DLINO SOFD DLINO SOOD SAPoffice: Object definition OBJNO
SOFD DLINO SOFD MANDT SOOD SAPoffice: Object definition MANDT
SOFD DLINO SOFD DLITP SOOD SAPoffice: Object definition OBJTP
SOFD DLINO SOFD DLIYR SOOD SAPoffice: Object definition OBJYR
SOFD DLITP SOFD DLITP TSOTD Valid Object Types OBJTP
SOFD FOLTP SOFD FOLTP TSOTD Valid Object Types OBJTP
SOFD ICLASS SOFD ICLASS TFIC Class Table for SAPfind CLASS
SOFD MANDT SOFD MANDT T000 Clients MANDT
SOFD NOTNO SOFD MANDT SOOD SAPoffice: Object definition MANDT
SOFD NOTNO SOFD NOTTP SOOD SAPoffice: Object definition OBJTP
SOFD NOTNO SOFD NOTYR SOOD SAPoffice: Object definition OBJYR
SOFD NOTNO SOFD NOTNO SOOD SAPoffice: Object definition OBJNO
SOFD NOTTP SOFD NOTTP TSOTD Valid Object Types OBJTP
SOFD OBJLA SOFD OBJLA T002 Language Keys (Component BC-I18) SPRAS
SOFD OWNNO SOFD MANDT SOOD SAPoffice: Object definition MANDT
SOFD OWNNO SOFD OWNTP SOOD SAPoffice: Object definition OBJTP
SOFD OWNNO SOFD OWNYR SOOD SAPoffice: Object definition OBJYR
SOFD OWNNO SOFD OWNNO SOOD SAPoffice: Object definition OBJNO
SOFD OWNTP SOFD OWNTP TSOTD Valid Object Types OBJTP
SOFD PARNO SOFD PARYR SOOD SAPoffice: Object definition OBJYR
SOFD PARNO SOFD PARNO SOOD SAPoffice: Object definition OBJNO
SOFD PARNO SOFD MANDT SOOD SAPoffice: Object definition MANDT
SOFD PARNO SOFD PARTP SOOD SAPoffice: Object definition OBJTP
SOFD PARTP SOFD PARTP TSOTD Valid Object Types OBJTP
SOFD TPONLY SOFD TPONLY TSOTD Valid Object Types OBJTP