SAP SOFMO SAPoffice: folder contents (without MANDT) Table data and field list

SOFMO is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SAPoffice: folder contents (without MANDT)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SOFMO TYPE SOFMO.

The SOFMO table consists of various fields, each holding specific information or linking keys about SAPoffice: folder contents (without MANDT) data available in SAP. These include FOLYR (Object folder: Year from ID), FOLNO (Object folder: Number from ID), DOCTP (Object: Object Type From ID), DOCYR (Object: Year from ID)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

SOFMO structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP SOFMO structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the SOFMO table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
FOLTP	Object folder: Object type from ID	SO_FOL_TP	CHAR	3	TSOTD		SO_OBJ_TP
FOLYR	Object folder: Year from ID	SO_FOL_YR	CHAR	2			SO_OBJ_YR
FOLNO	Object folder: Number from ID	SO_FOL_NO	CHAR	12	Assigned to domain		SO_OBJ_NO
DOCTP	Object: Object Type From ID	SO_DOC_TP	CHAR	3	Assigned to domain		SO_OBJ_TP
DOCYR	Object: Year from ID	SO_DOC_YR	CHAR	2			SO_OBJ_YR
DOCNO	Object: Number from ID	SO_DOC_NO	CHAR	12	Assigned to domain		SO_OBJ_NO
FORTP	Forwarder: Object type from ID	SO_FOR_TP	CHAR	3	Assigned to domain		SO_OBJ_TP
FORYR	Forwarder: year from the ID	SO_FOR_YR	CHAR	2			SO_OBJ_YR
FORNO	Forwarder: number from the ID	SO_FOR_NO	CHAR	12	Assigned to domain		SO_OBJ_NO
PERMA	SAPoffice: Object is displayed independent of selection date	SO_PERMA	CHAR	1			SO_FLAG
HOLDO	The object has status HOLD	SO_HOLDO	CHAR	1			SO_FLAG
ARCHI	The document is stored in archive	SO_ARCHI	CHAR	1			SO_FLAG
DLDAT	Document Expiration Date	SO_DAT_DL	DATS	8			DATUM
DLTIM	Expiry time of object	SO_TIM_DL	TIMS	6			UZEIT
NOTTP	Default setting of document class	SO_NOT_TP	CHAR	3	TSOTD		SO_OBJ_TP
NOTYR	Object note: year from the ID	SO_NOT_YR	CHAR	2			SO_OBJ_YR
NOTNO	Object note: number from the ID	SO_NOT_NO	CHAR	12	Assigned to domain		SO_OBJ_NO
RCDAT	Date document was received	SO_DAT_RC	DATS	8			DATUM
RCTIM	Time object was received	SO_TIM_RC	TIMS	6			UZEIT
SNDDR	Send: As disregard	SO_SND_DR	CHAR	1			SO_FLAG
SNDEX	Send express	SO_SND_EX	CHAR	1			SO_FLAG
SNDCP	Send: As copy	SO_SND_CP	CHAR	1			SO_FLAG
SNDBC	Send as a blind copy	SO_SND_BC	CHAR	1			SO_FLAG
OBJAC	The recipient must take action	SO_OBJ_AC	CHAR	1			SO_FLAG
OBJRR	A reply must be sent for this object	SO_OBJ_RR	CHAR	1			SO_FLAG
OBJRD	Object has already been viewed	SO_OBJ_RD	CHAR	1			SO_FLAG
RESUB	SAPoffice: folder entry is a resubmitted object	SO_RSUBM	CHAR	1			SO_FELD123
RECPRI	Priority	SO_REC_PRI	CHAR	1			SO_OBJ_PRI
FLAG1	Search of private or shared folders	SO_FLAG	CHAR	1			SO_FLAG
FLAG2	Search of private or shared folders	SO_FLAG	CHAR	1			SO_FLAG
FLAG3	Search of private or shared folders	SO_FLAG	CHAR	1			SO_FLAG
FLAG4	Search of private or shared folders	SO_FLAG	CHAR	1			SO_FLAG
FLAG5	Search of private or shared folders	SO_FLAG	CHAR	1			SO_FLAG
RBDAT	Date On Which The Object Was Resubmitted	SO_DAT_RB	DATS	8			DATUM
LFOLTP	Object folder: Object type from ID	SO_FOL_TP	CHAR	3	Assigned to domain		SO_OBJ_TP
LFOLYR	Object folder: Year from ID	SO_FOL_YR	CHAR	2			SO_OBJ_YR
LFOLNO	Object folder: Number from ID	SO_FOL_NO	CHAR	12	Assigned to domain		SO_OBJ_NO

Key field

Non-key field

< SOFMK - SAPoffice: folder contents (key part) SOFM_WI - Sofm for Archiving of WI Attachments >

How do I retrieve data from SAP structure SOFMO using ABAP code?

As SOFMO is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SOFMO as there is no data to select.

How to access SAP table SOFMO

Within an ECC or HANA version of SAP you can also view further information about SOFMO and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).