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 | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
FIXED
Check-in/check-out flag
|
SO_FIXED |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
PFLCL
Private folder class
|
SO_PFLCL |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 |