SAP Table SOFD

SAPoffice: Object Definition

The table SOFD (SAPoffice: Object Definition) is a standard table in SAP ERP. It belongs to the package SO.

Technical Information

Table	SOFD
Short Text	SAPoffice: Object Definition
Package	SO
Table Type	Transparent Table

Fields for Table SOFD

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
FOLTP	✔	Object folder: Object type from ID	SO_FOL_TP	CHAR	3	TSOTD
FOLYR	✔	Object folder: Year from ID	SO_FOL_YR	CHAR	2
FOLNO	✔	Object folder: Number from ID	SO_FOL_NO	CHAR	12	*
OWNTP		Owner type from ID	SO_OWN_TP	CHAR	3	TSOTD
OWNYR		Owner year from the ID	SO_OWN_YR	CHAR	2
OWNNO		Owner number from the ID	SO_OWN_NO	CHAR	12	SOOD
OBJLA		Language in Which Document Is Created	SO_OBJ_LA	LANG	1	T002
OBJSRT		Sort field	SO_OBJ_SRT	CHAR	10
OBJNAM		Name of document, folder or distribution list	SO_OBJ_NAM	CHAR	12
OBJDES		Short description of contents	SO_OBJ_DES	CHAR	50
CROTP		User who created object: Object type from ID	SO_CRO_TP	CHAR	3	TSOTD
CROYR		User that created object: year from the ID	SO_CRO_YR	CHAR	2
CRONO		User that created object: number from the ID	SO_CRO_NO	CHAR	12	SOOD
CRDAT		Date created	SO_DAT_CR	DATS	8
CRTIM		Time created	SO_TIM_CR	TIMS	6
CHOTP		User that changed the object: Object type from ID	SO_CHO_TP	CHAR	3	TSOTD
CHOYR		User that changed the object: year from the ID	SO_CHO_YR	CHAR	2
CHONO		User that changed the object: number from the ID	SO_CHO_NO	CHAR	12	SOOD
CHDAT		Date of Last Change	SO_DAT_CH	DATS	8
CHTIM		Time of Last Change	SO_TIM_CH	TIMS	6
NOTTP		Default setting of document class	SO_NOT_TP	CHAR	3	TSOTD
NOTYR		Object note: year from the ID	SO_NOT_YR	CHAR	2
NOTNO		Object note: number from the ID	SO_NOT_NO	CHAR	12	SOOD
FOLRG		Folder: Area (private, shared folders)	SO_FOL_RG	CHAR	1
LADAT		Date of last access	SO_DAT_LA	DATS	8
DLDAT		Document Expiration Date	SO_DAT_DL	DATS	8
DLTIM		Expiry time of object	SO_TIM_DL	TIMS	6
OBJSNS		Object: Sensitivity (private, functional, ...)	SO_OBJ_SNS	CHAR	1
FIXED		Check-in/check-out flag	SO_FIXED	CHAR	1
PARTP		Parent object type from ID	SO_PAR_TP	CHAR	3	TSOTD
PARYR		Parent object year from the ID	SO_PAR_YR	CHAR	2
PARNO		Parent object number from the ID	SO_PAR_NO	CHAR	12	SOOD
FOLCNT		Number of documents stored in this folder	SO_FOL_SIZ	NUMC	5
FOLSIZ		Number of documents stored in this folder	SO_FOL_SIZ	NUMC	5
TPONLY		Only this object type can be stored in this folder	SO_TPONLY	CHAR	3	TSOTD
LIFSP		Retention period of documents in folder	SO_LIFSP	NUMC	5
FOLINDEX		Index folder and documents contained in it	SO_INDEX	CHAR	1
PFLCL		Private folder class	SO_PFLCL	CHAR	1
ICLASS		Information class for indexing	SF_ICLASS	CHAR	4	TFIC
DLITP		Distribution list type from ID	SO_DLI_TP	CHAR	3	TSOTD
DLIYR		Distribution list year from the ID	SO_DLI_YR	CHAR	2
DLINO		Distribution list: number from the ID	SO_DLI_NO	CHAR	12	SOOD
FOLSEC		Folder area (private, client, group, ...)	SO_FOL_SEC	CHAR	1
FOLTYPE		SAPoffice: Folder type	SO_FOL_TY	CHAR	4
LAFDAT		Date of last access	SO_DAT_LA	DATS	8