SOPR SAP (SAPoffice: System-wide profile) Table details
Dictionary Type: Table
Description: SAPoffice: System-wide profile
Description: SAPoffice: System-wide profile
Table field list including key, data, relationships and ABAP select examples
SOPR is a standard SAP Table which is used to store SAPoffice: System-wide profile data and is available within R/3 SAP systems depending on the version and release level.
The SOPR table consists of various fields, each holding specific information or linking keys about SAPoffice: System-wide profile data available in SAP. These include DELRE (SAPoffice: delete unviewed objects), DELRR (SAPoffice: delete unanswered objects), DELAC (SAPoffice: delete ToDo objects - no action taken), DELREM (SAPoffice: delete unviewed objects with message).. 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. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SOPR table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| DELRE | SAPoffice: delete unviewed objects | SO_DEL_RE | CHAR | 1 | SO_FLAG | ||||
| DELRR | SAPoffice: delete unanswered objects | SO_DEL_RR | CHAR | 1 | SO_FLAG | ||||
| DELAC | SAPoffice: delete ToDo objects - no action taken | SO_DEL_AC | CHAR | 1 | SO_FLAG | ||||
| DELREM | SAPoffice: delete unviewed objects with message | SO_DEL_REM | CHAR | 1 | SO_FLAG | ||||
| DELRRM | SAPoffice: delete unanswered objects with message | SO_DEL_RRM | CHAR | 1 | SO_FLAG | ||||
| DELACM | SAPoffice: del. ToDo objects (no action taken) with message | SO_DEL_ACM | CHAR | 1 | SO_FLAG | ||||
| IN_DEX | SAPoffice: Indexing on/off | SO_IN_DEX | CHAR | 1 | SO_FLAG | ||||
| OBJENC | Object: coded | SO_OBJ_ENC | CHAR | 1 | SO_FLAG | ||||
| EXPIN | No notification of unviewed mails at logon | SO_EXPIN | CHAR | 1 | SO_FLAG | ||||
| EXPEX | Execution of express messages in new session | SO_EXPEX | CHAR | 1 | SO_FLAG | ||||
| EXPNA | Name of exit routine for express messages | SO_EXPNA | CHAR | 40 | PROGNAME | ||||
| EXMAX | Maximum number of express messages allowed per send | SO_EXMAX | RAW | 2 | SO_CNT2 | ||||
| RCMAX | Maximum number of recipients allowed per send | SO_RCMAX | RAW | 2 | SO_CNT2 | ||||
| USRAU | Maintain user: only the administrator is authorized | SO_USRAU | CHAR | 1 | SO_FLAG | ||||
| INMAX | Maximum number of documents allowed in the inbox | SO_INMAX | RAW | 2 | SO_CNT2 | ||||
| CRGDL | Authorization to create shared distribution lists | SO_CRGDL | CHAR | 1 | SO_I_FLAG | ||||
| CRFCL | Authorization to create client folders | SO_CRFCL | CHAR | 1 | SO_I_FLAG | ||||
| CRFCC | Authorization to create company-code-wide folders | SO_CRFCC | CHAR | 1 | SO_I_FLAG | ||||
| CRFPL | Authorization to create plant-wide folders | SO_CRFPL | CHAR | 1 | SO_I_FLAG | ||||
| CRFDP | Authorization to create department-wide folders | SO_CRFDP | CHAR | 1 | SO_I_FLAG | ||||
| CRFAD | Authorization to create cost-center-wide folders | SO_CRFAD | CHAR | 1 | SO_I_FLAG | ||||
| CRFGR | Authorization to create group folders | SO_CRFGR | CHAR | 1 | SO_I_FLAG | ||||
| HOMAX | Max. no. of documents a user can protect from archiving | SO_HOMAX | RAW | 1 | SO_CNT1 | ||||
| GLMAX | Maximum size of the access lists of a user | SO_GLMAX | RAW | 1 | SO_CNT1 | ||||
| GFMAX | Max. number of group folders which a user can create | SO_GFMAX | RAW | 1 | SO_CNT1 | ||||
| AUTEXT | Authorization to send externally | SO_AUT_EXT | CHAR | 1 | SO_I_FLAG | ||||
| NOTTP | Default setting of document class | SO_NOT_TP | CHAR | 3 | Assigned to domain | SO_OBJ_TP | |||
| CALEN | Day on which the week begins | SO_CALEN | CHAR | 1 | SO_CALEN | ||||
| OUTFL | Documents are copied to the outbox when sent | SO_OUTFL | CHAR | 1 | SO_FLAG | ||||
| SQWIN | Switch confirmation prompt on or off when deleting | SO_SQWIN | CHAR | 1 | SO_FLAG | ||||
| SYUSR | Your user view is set when you start SAPoffice | SO_SYUSR | CHAR | 1 | SO_FLAG | ||||
| SYUSRINB | Inbox filter (unviewed documents only) | SO_SYUSRIN | CHAR | 1 | SO_TEXT001 | ||||
| SYUSROUT | SAPoffice: Storage information | SO_CONT | CHAR | 1 | SO_TEXT001 | ||||
| WSTYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
| WSTNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
| PFRYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
| PFRNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
| PDLYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
| PDLNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
| AFRYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
| AFRNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
| RSWORKDAY | Resubmission on workdays only | SO_RSWD | CHAR | 1 | SO_FLAG | ||||
| RSFACID | Factory calendar identification code for the resubmission | SO_RSFACID | CHAR | 2 | TFACD | WFCID | |||
| USRADR | Number of internal company address | SO_USRIADR | CHAR | 10 | ALPHA | SO_INTADR | |||
| LFDNR | Addresses: Sequence number | SO_LFDNR | CHAR | 3 | SO_TEXT003 | ||||
| SNDART | Text field length 3: for use as required | SO_TEXT003 | CHAR | 3 | SO_TEXT003 | ||||
| FLAG1 | Text field length 1 | SO_TEXT001 | CHAR | 1 | SO_TEXT001 | ||||
| FLAG2 | Text field length 1 | SO_TEXT001 | CHAR | 1 | SO_TEXT001 | ||||
| FLAG3 | Text field length 1 | SO_TEXT001 | CHAR | 1 | SO_TEXT001 | ||||
| NATIO | SAPoffice: international code for character set | SO_NATIO | CHAR | 1 | Assigned to domain | NATION | |||
| RFCDES | RFC destination for SAPoffice server | SO_RFCDES | CHAR | 32 | Assigned to domain | RFCDEST | RFC | ||
| DEFEXP | Default expiry time for document | SO_DEFEXP | NUMC | 3 | SO_NUM3 | ||||
| LADAT | Default for last access date (last changed) | SO_DEF_LAD | NUMC | 3 | SO_NUM3 | ||||
| UNIX_DESTI | SAPoffice: RFC destination of the UNIX mail server | SO_UNX_DES | CHAR | 32 | SO_RFCDES | ||||
| RETURN_ADR | SAPoffice: UNIX address for this Office (UNIX server) | SO_RET_ADR | CHAR | 50 | SO_STRI050 | ||||
| EXTTELE | Authorization to send via telematic services | SO_EXTTELE | CHAR | 1 | SO_I_FLAG | ||||
| EXTSMTP | Authorization to send via the Internet | SO_EXTSMTP | CHAR | 1 | SO_I_FLAG | ||||
| EXTX400 | Authorization to send via X.400 | SO_EXTX400 | CHAR | 1 | SO_I_FLAG | ||||
| EXTSAP | Authorization to send within SAP system group | SO_EXTSAP | CHAR | 1 | SO_I_FLAG | ||||
| NO_DIR_SND | Direct external sending is not allowed in this system | SO_NDRSND | CHAR | 1 | SO_FLAG | ||||
| NO_EXT_SND | Sending to an external address recipient type not allowed | SO_NEXTSND | CHAR | 1 | SO_FLAG | ||||
| NO_INT_SND | Send internally not allowed in this system | SO_NINTSND | CHAR | 1 | SO_FLAG | ||||
| OUTEXP | Expiration time for documents in outbox | SO_OUT_EXP | NUMC | 3 | SO_NUM3 | ||||
| EXTX500 | Authorization to access the LDAP services | SO_EXTX500 | CHAR | 1 | SO_FLAG | ||||
| UNX_CONFIG | Path specification for a UNIX file | SO_UNXCONF | CHAR | 241 | SO_STRI241 | ||||
| DOC_LENGTH | Query PC documents from this size | SO_MAX_LEN | NUMC | 12 | SO_DOC_LEN | ||||
| RESUB_DATE | Date of next resubmission | SO_RES_DAT | DATS | 8 | DATUM | ||||
| RESUB_TIME | Time of next resubmission in system | SO_RES_TIM | TIMS | 6 | UZEIT | ||||
| RS_BATCHID | ID of the batch item supervising the resubmission | SO_RS_BTID | NUMC | 12 | NUMC12 | ||||
| FAX_EXIST | Connection to fax communications component | SO_EX_FAX | CHAR | 1 | SO_FLAG | ||||
| TLX_EXIST | Connection to telex communications component | SO_EX_TLX | CHAR | 1 | SO_FLAG | ||||
| SMTP_EXIST | Connection to Internet Gateway | SO_EX_SMTP | CHAR | 1 | SO_FLAG | ||||
| X400_EXIST | Connection to X.400 component | SO_EX_X400 | CHAR | 1 | SO_FLAG | ||||
| SAP_EXIST | The SAP system is part of a mail system group | SO_EX_SAP | CHAR | 1 | SO_FLAG | ||||
| X500_EXIST | LDAP service connection | SO_EX_X500 | CHAR | 1 | SO_FLAG | ||||
| ORG_EXIST | HR Org is connected and maintained | SO_EX_ORG | CHAR | 1 | SO_FLAG | ||||
| ARCH_EXIST | Connection to an archive | SO_EX_ARCH | CHAR | 1 | SO_FLAG | ||||
| OBJ_EXIST | Send to Business Objects | SO_EX_OBJ | CHAR | 1 | SO_FLAG | ||||
| DIRADDRESS | Company address for direct addresses (empty or 'unknown') | SO_DIR_ADR | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
| ADDRBUFCLR | Time stamp for invalidation of buffered addresses | SO_ADBUFCL | NUMC | 14 | SYTSTP | ||||
| ADDRBUFINV | No. of hours (interval) before invalidation of addr. buffer | SO_ADBUFIV | NUMC | 4 | SO_BUFIVT | ||||
| REORGDAILY | Search of private or shared folders | SO_FLAG | CHAR | 1 | SO_FLAG | ||||
| REMOTEDEST | RFC destination for SAPoffice server | SO_RFCDES | CHAR | 32 | Assigned to domain | RFCDEST | RFC | ||
| REMOTENAME | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
| REMOTECLNT | Client ID | SYMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| REMOTERELS | Release of SAP System | SYSAPRL | CHAR | 4 | SYCHAR04 | ||||
| DISTRIB | This system is part of a system group | SO_DISTRIB | CHAR | 1 | SO_FLAG | ||||
| MAIL_SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
| MAIL_MANDT | Client ID | SYMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| MAIL_CLNT | Addresses: Client | SO_RML_MD | CHAR | 3 | ALPHA | SO_MAND | |||
| IBND_UPD | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS |
| Key field | Non-key field |
How do I retrieve data from SAP table SOPR using ABAP code
The following ABAP code Example will allow you to do a basic selection on SOPR to SELECT all data from the tableDATA: WA_SOPR TYPE SOPR.
SELECT SINGLE *
FROM SOPR
INTO CORRESPONDING FIELDS OF WA_SOPR
WHERE...
How to access SAP table SOPR
Within an ECC or HANA version of SAP you can also view further information about SOPR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects