1. Home
  2. Resources
  3. SAP Tables
  4. SOFM - SAPoffice: Folder contents

SAP Table SOFM

SAPoffice: Folder contents

SOFM (SAPoffice: Folder contents) 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 SOFM to other SAP tables.

SOFM 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 SOFD CHAR 12 0
DOCTP Object: Object Type From ID SO_DOC_TP TSOTD CHAR 3 0
DOCYR Object: Year from ID SO_DOC_YR CHAR 2 0
DOCNO Object: Number from ID SO_DOC_NO SOOD CHAR 12 0
FORTP Forwarder: Object type from ID SO_FOR_TP TSOTD CHAR 3 0
FORYR Forwarder: year from the ID SO_FOR_YR CHAR 2 0
FORNO Forwarder: number from the ID SO_FOR_NO CHAR 12 0
PERMA SAPoffice: Object is displayed independent of selection date SO_PERMA CHAR 1 0
NULL Value for deactivated
X Value for activated
HOLDO The object has status HOLD SO_HOLDO CHAR 1 0
NULL Value for deactivated
X Value for activated
ARCHI The document is stored in archive SO_ARCHI CHAR 1 0
NULL Value for deactivated
X Value for activated
DLDAT Document Expiration Date SO_DAT_DL DATS 8 0
DLTIM Expiry time of object SO_TIM_DL 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 CHAR 12 0
RCDAT Date document was received SO_DAT_RC DATS 8 0
RCTIM Time object was received SO_TIM_RC TIMS 6 0
SNDDR Send: As disregard SO_SND_DR CHAR 1 0
NULL Value for deactivated
X Value for activated
SNDEX Send express SO_SND_EX CHAR 1 0
NULL Value for deactivated
X Value for activated
SNDCP Send: As copy SO_SND_CP CHAR 1 0
NULL Value for deactivated
X Value for activated
SNDBC Send as a blind copy SO_SND_BC CHAR 1 0
NULL Value for deactivated
X Value for activated
OBJAC The recipient must take action SO_OBJ_AC CHAR 1 0
NULL Value for deactivated
X Value for activated
OBJRR A reply must be sent for this object SO_OBJ_RR CHAR 1 0
NULL Value for deactivated
X Value for activated
OBJRD Object has already been viewed SO_OBJ_RD CHAR 1 0
NULL Value for deactivated
X Value for activated
RESUB SAPoffice: folder entry is a resubmitted object SO_RSUBM CHAR 1 0
NULL No specification made
1 Possible values
RECPRI Priority SO_REC_PRI CHAR 1 0
1 Highest priority
2
3
4
5
6
7
8
9 Lowest priority
FLAG1 Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated
FLAG2 Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated
FLAG3 Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated
FLAG4 Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated
FLAG5 Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated
RBDAT Date On Which The Object Was Resubmitted SO_DAT_RB DATS 8 0
LFOLTP Object folder: Object type from ID SO_FOL_TP CHAR 3 0
LFOLYR Object folder: Year from ID SO_FOL_YR CHAR 2 0
LFOLNO Object folder: Number from ID SO_FOL_NO CHAR 12 0

SOFM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SOFM DOCNO SOFM MANDT SOOD SAPoffice: Object definition MANDT
SOFM DOCNO SOFM DOCTP SOOD SAPoffice: Object definition OBJTP
SOFM DOCNO SOFM DOCYR SOOD SAPoffice: Object definition OBJYR
SOFM DOCNO SOFM DOCNO SOOD SAPoffice: Object definition OBJNO
SOFM DOCTP SOFM DOCTP TSOTD Valid Object Types OBJTP
SOFM FOLNO SOFM FOLNO SOFD SAPoffice: Object Definition FOLNO
SOFM FOLNO SOFM MANDT SOFD SAPoffice: Object Definition MANDT
SOFM FOLNO SOFM FOLTP SOFD SAPoffice: Object Definition FOLTP
SOFM FOLNO SOFM FOLYR SOFD SAPoffice: Object Definition FOLYR
SOFM FOLTP SOFM FOLTP TSOTD Valid Object Types OBJTP
SOFM FORTP SOFM FORTP TSOTD Valid Object Types OBJTP
SOFM MANDT SOFM MANDT T000 Clients MANDT
SOFM NOTTP SOFM NOTTP TSOTD Valid Object Types OBJTP