1. Home
  2. Resources
  3. SAP Tables
  4. SOPR - SAPoffice: System-wide profile

SAP Table SOPR

SAPoffice: System-wide profile

SOPR (SAPoffice: System-wide profile) 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 SOPR to other SAP tables.

SOPR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DELRE SAPoffice: delete unviewed objects SO_DEL_RE CHAR 1 0
NULL Value for deactivated
X Value for activated
DELRR SAPoffice: delete unanswered objects SO_DEL_RR CHAR 1 0
NULL Value for deactivated
X Value for activated
DELAC SAPoffice: delete ToDo objects - no action taken SO_DEL_AC CHAR 1 0
NULL Value for deactivated
X Value for activated
DELREM SAPoffice: delete unviewed objects with message SO_DEL_REM CHAR 1 0
NULL Value for deactivated
X Value for activated
DELRRM SAPoffice: delete unanswered objects with message SO_DEL_RRM CHAR 1 0
NULL Value for deactivated
X Value for activated
DELACM SAPoffice: del. ToDo objects (no action taken) with message SO_DEL_ACM CHAR 1 0
NULL Value for deactivated
X Value for activated
IN_DEX SAPoffice: Indexing on/off SO_IN_DEX CHAR 1 0
NULL Value for deactivated
X Value for activated
OBJENC Object: coded SO_OBJ_ENC CHAR 1 0
NULL Value for deactivated
X Value for activated
EXPIN No notification of unviewed mails at logon SO_EXPIN CHAR 1 0
NULL Value for deactivated
X Value for activated
EXPEX Execution of express messages in new session SO_EXPEX CHAR 1 0
NULL Value for deactivated
X Value for activated
EXPNA Name of exit routine for express messages SO_EXPNA CHAR 40 0
EXMAX Maximum number of express messages allowed per send SO_EXMAX RAW 2 0
RCMAX Maximum number of recipients allowed per send SO_RCMAX RAW 2 0
USRAU Maintain user: only the administrator is authorized SO_USRAU CHAR 1 0
NULL Value for deactivated
X Value for activated
INMAX Maximum number of documents allowed in the inbox SO_INMAX RAW 2 0
CRGDL Authorization to create shared distribution lists SO_CRGDL CHAR 1 0
CRFCL Authorization to create client folders SO_CRFCL CHAR 1 0
CRFCC Authorization to create company-code-wide folders SO_CRFCC CHAR 1 0
CRFPL Authorization to create plant-wide folders SO_CRFPL CHAR 1 0
CRFDP Authorization to create department-wide folders SO_CRFDP CHAR 1 0
CRFAD Authorization to create cost-center-wide folders SO_CRFAD CHAR 1 0
CRFGR Authorization to create group folders SO_CRFGR CHAR 1 0
HOMAX Max. no. of documents a user can protect from archiving SO_HOMAX RAW 1 0
GLMAX Maximum size of the access lists of a user SO_GLMAX RAW 1 0
GFMAX Max. number of group folders which a user can create SO_GFMAX RAW 1 0
AUTEXT Authorization to send externally SO_AUT_EXT CHAR 1 0
NOTTP Default setting of document class SO_NOT_TP CHAR 3 0
CALEN Day on which the week begins SO_CALEN CHAR 1 0
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday
7 Sunday
OUTFL Documents are copied to the outbox when sent SO_OUTFL CHAR 1 0
NULL Value for deactivated
X Value for activated
SQWIN Switch confirmation prompt on or off when deleting SO_SQWIN CHAR 1 0
NULL Value for deactivated
X Value for activated
SYUSR Your user view is set when you start SAPoffice SO_SYUSR CHAR 1 0
NULL Value for deactivated
X Value for activated
SYUSRINB Inbox filter (unviewed documents only) SO_SYUSRIN CHAR 1 0
SYUSROUT SAPoffice: Storage information SO_CONT CHAR 1 0
WSTYR Object: Year from ID SO_OBJ_YR CHAR 2 0
WSTNO Object: Number from ID SO_OBJ_NO CHAR 12 0
PFRYR Object: Year from ID SO_OBJ_YR CHAR 2 0
PFRNO Object: Number from ID SO_OBJ_NO CHAR 12 0
PDLYR Object: Year from ID SO_OBJ_YR CHAR 2 0
PDLNO Object: Number from ID SO_OBJ_NO CHAR 12 0
AFRYR Object: Year from ID SO_OBJ_YR CHAR 2 0
AFRNO Object: Number from ID SO_OBJ_NO CHAR 12 0
RSWORKDAY Resubmission on workdays only SO_RSWD CHAR 1 0
NULL Value for deactivated
X Value for activated
RSFACID Factory calendar identification code for the resubmission SO_RSFACID TFACD CHAR 2 0
USRADR Number of internal company address SO_USRIADR CHAR 10 0
LFDNR Addresses: Sequence number SO_LFDNR CHAR 3 0
SNDART Text field length 3: for use as required SO_TEXT003 CHAR 3 0
FLAG1 Text field length 1 SO_TEXT001 CHAR 1 0
FLAG2 Text field length 1 SO_TEXT001 CHAR 1 0
FLAG3 Text field length 1 SO_TEXT001 CHAR 1 0
NATIO SAPoffice: international code for character set SO_NATIO CHAR 1 0
RFCDES RFC destination for SAPoffice server SO_RFCDES CHAR 32 0
DEFEXP Default expiry time for document SO_DEFEXP NUMC 3 0
LADAT Default for last access date (last changed) SO_DEF_LAD NUMC 3 0
UNIX_DESTI SAPoffice: RFC destination of the UNIX mail server SO_UNX_DES CHAR 32 0
RETURN_ADR SAPoffice: UNIX address for this Office (UNIX server) SO_RET_ADR CHAR 50 0
EXTTELE Authorization to send via telematic services SO_EXTTELE CHAR 1 0
EXTSMTP Authorization to send via the Internet SO_EXTSMTP CHAR 1 0
EXTX400 Authorization to send via X.400 SO_EXTX400 CHAR 1 0
EXTSAP Authorization to send within SAP system group SO_EXTSAP CHAR 1 0
NO_DIR_SND Direct external sending is not allowed in this system SO_NDRSND CHAR 1 0
NULL Value for deactivated
X Value for activated
NO_EXT_SND Sending to an external address recipient type not allowed SO_NEXTSND CHAR 1 0
NULL Value for deactivated
X Value for activated
NO_INT_SND Send internally not allowed in this system SO_NINTSND CHAR 1 0
NULL Value for deactivated
X Value for activated
OUTEXP Expiration time for documents in outbox SO_OUT_EXP NUMC 3 0
EXTX500 Authorization to access the LDAP services SO_EXTX500 CHAR 1 0
NULL Value for deactivated
X Value for activated
UNX_CONFIG Path specification for a UNIX file SO_UNXCONF CHAR 241 0
DOC_LENGTH Query PC documents from this size SO_MAX_LEN NUMC 12 0
RESUB_DATE Date of next resubmission SO_RES_DAT DATS 8 0
RESUB_TIME Time of next resubmission in system SO_RES_TIM TIMS 6 0
RS_BATCHID ID of the batch item supervising the resubmission SO_RS_BTID NUMC 12 0
FAX_EXIST Connection to fax communications component SO_EX_FAX CHAR 1 0
NULL Value for deactivated
X Value for activated
TLX_EXIST Connection to telex communications component SO_EX_TLX CHAR 1 0
NULL Value for deactivated
X Value for activated
SMTP_EXIST Connection to Internet Gateway SO_EX_SMTP CHAR 1 0
NULL Value for deactivated
X Value for activated
X400_EXIST Connection to X.400 component SO_EX_X400 CHAR 1 0
NULL Value for deactivated
X Value for activated
SAP_EXIST The SAP system is part of a mail system group SO_EX_SAP CHAR 1 0
NULL Value for deactivated
X Value for activated
X500_EXIST LDAP service connection SO_EX_X500 CHAR 1 0
NULL Value for deactivated
X Value for activated
ORG_EXIST HR Org is connected and maintained SO_EX_ORG CHAR 1 0
NULL Value for deactivated
X Value for activated
ARCH_EXIST Connection to an archive SO_EX_ARCH CHAR 1 0
NULL Value for deactivated
X Value for activated
OBJ_EXIST Send to Business Objects SO_EX_OBJ CHAR 1 0
NULL Value for deactivated
X Value for activated
DIRADDRESS Company address for direct addresses (empty or "unknown") SO_DIR_ADR CHAR 10 0
ADDRBUFCLR Time stamp for invalidation of buffered addresses SO_ADBUFCL NUMC 14 0
ADDRBUFINV No. of hours (interval) before invalidation of addr. buffer SO_ADBUFIV NUMC 4 0
REORGDAILY Search of private or shared folders SO_FLAG CHAR 1 0
NULL Value for deactivated
X Value for activated
REMOTEDEST RFC destination for SAPoffice server SO_RFCDES CHAR 32 0
REMOTENAME Name of SAP System SYSYSID CHAR 8 0
REMOTECLNT Client ID SYMANDT CLNT 3 0
REMOTERELS Release of SAP System SYSAPRL CHAR 4 0
DISTRIB This system is part of a system group SO_DISTRIB CHAR 1 0
NULL Value for deactivated
X Value for activated
MAIL_SYSID Name of SAP System SYSYSID CHAR 8 0
MAIL_MANDT Client ID SYMANDT CLNT 3 0
MAIL_CLNT Addresses: Client SO_RML_MD CHAR 3 0
IBND_UPD UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0

SOPR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SOPR MANDT SOPR MANDT T000 Clients MANDT
SOPR RSFACID SOPR RSFACID TFACD Factory calendar definition IDENT