SAP ABAP Table SOPR (SAPoffice: System-wide profile)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     ⤷ SO (Package) SAPoffice

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SOPR	Table Relationship Diagram
Short Description	SAPoffice: System-wide profile

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DELRE	☐	SO_DEL_RE	SO_FLAG	CHAR	1	0	SAPoffice: delete unviewed objects
3	DELRR	☐	SO_DEL_RR	SO_FLAG	CHAR	1	0	SAPoffice: delete unanswered objects
4	DELAC	☐	SO_DEL_AC	SO_FLAG	CHAR	1	0	SAPoffice: delete ToDo objects - no action taken
5	DELREM	☐	SO_DEL_REM	SO_FLAG	CHAR	1	0	SAPoffice: delete unviewed objects with message
6	DELRRM	☐	SO_DEL_RRM	SO_FLAG	CHAR	1	0	SAPoffice: delete unanswered objects with message
7	DELACM	☐	SO_DEL_ACM	SO_FLAG	CHAR	1	0	SAPoffice: del. ToDo objects (no action taken) with message
8	IN_DEX	☐	SO_IN_DEX	SO_FLAG	CHAR	1	0	SAPoffice: Indexing on/off
9	OBJENC	☐	SO_OBJ_ENC	SO_FLAG	CHAR	1	0	Object: coded
10	EXPIN	☐	SO_EXPIN	SO_FLAG	CHAR	1	0	No notification of unviewed mails at logon
11	EXPEX	☐	SO_EXPEX	SO_FLAG	CHAR	1	0	Execution of express messages in new session
12	EXPNA	☐	SO_EXPNA	PROGNAME	CHAR	40	0	Name of exit routine for express messages
13	EXMAX	☐	SO_EXMAX	SO_CNT2	RAW	2	0	Maximum number of express messages allowed per send
14	RCMAX	☐	SO_RCMAX	SO_CNT2	RAW	2	0	Maximum number of recipients allowed per send
15	USRAU	☐	SO_USRAU	SO_FLAG	CHAR	1	0	Maintain user: only the administrator is authorized
16	INMAX	☐	SO_INMAX	SO_CNT2	RAW	2	0	Maximum number of documents allowed in the inbox
17	CRGDL	☐	SO_CRGDL	SO_I_FLAG	CHAR	1	0	Authorization to create shared distribution lists
18	CRFCL	☐	SO_CRFCL	SO_I_FLAG	CHAR	1	0	Authorization to create client folders
19	CRFCC	☐	SO_CRFCC	SO_I_FLAG	CHAR	1	0	Authorization to create company-code-wide folders
20	CRFPL	☐	SO_CRFPL	SO_I_FLAG	CHAR	1	0	Authorization to create plant-wide folders
21	CRFDP	☐	SO_CRFDP	SO_I_FLAG	CHAR	1	0	Authorization to create department-wide folders
22	CRFAD	☐	SO_CRFAD	SO_I_FLAG	CHAR	1	0	Authorization to create cost-center-wide folders
23	CRFGR	☐	SO_CRFGR	SO_I_FLAG	CHAR	1	0	Authorization to create group folders
24	HOMAX	☐	SO_HOMAX	SO_CNT1	RAW	1	0	Max. no. of documents a user can protect from archiving
25	GLMAX	☐	SO_GLMAX	SO_CNT1	RAW	1	0	Maximum size of the access lists of a user
26	GFMAX	☐	SO_GFMAX	SO_CNT1	RAW	1	0	Max. number of group folders which a user can create
27	AUTEXT	☐	SO_AUT_EXT	SO_I_FLAG	CHAR	1	0	Authorization to send externally
28	NOTTP	☐	SO_NOT_TP	SO_OBJ_TP	CHAR	3	0	Default setting of document class	*
29	CALEN	☐	SO_CALEN	SO_CALEN	CHAR	1	0	Day on which the week begins
30	OUTFL	☐	SO_OUTFL	SO_FLAG	CHAR	1	0	Documents are copied to the outbox when sent
31	SQWIN	☐	SO_SQWIN	SO_FLAG	CHAR	1	0	Switch confirmation prompt on or off when deleting
32	SYUSR	☐	SO_SYUSR	SO_FLAG	CHAR	1	0	Your user view is set when you start SAPoffice
33	SYUSRINB	☐	SO_SYUSRIN	SO_TEXT001	CHAR	1	0	Inbox filter (unviewed documents only)
34	SYUSROUT	☐	SO_CONT	SO_TEXT001	CHAR	1	0	SAPoffice: Storage information
35	WSTYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
36	WSTNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
37	PFRYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
38	PFRNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
39	PDLYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
40	PDLNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
41	AFRYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
42	AFRNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
43	RSWORKDAY	☐	SO_RSWD	SO_FLAG	CHAR	1	0	Resubmission on workdays only
44	RSFACID	☐	SO_RSFACID	WFCID	CHAR	2	0	Factory calendar identification code for the resubmission	TFACD
45	USRADR	☐	SO_USRIADR	SO_INTADR	CHAR	10	0	Number of internal company address
46	LFDNR	☐	SO_LFDNR	SO_TEXT003	CHAR	3	0	Addresses: Sequence number
47	SNDART	☐	SO_TEXT003	SO_TEXT003	CHAR	3	0	Text field length 3: for use as required
48	FLAG1	☐	SO_TEXT001	SO_TEXT001	CHAR	1	0	Text field length 1
49	FLAG2	☐	SO_TEXT001	SO_TEXT001	CHAR	1	0	Text field length 1
50	FLAG3	☐	SO_TEXT001	SO_TEXT001	CHAR	1	0	Text field length 1
51	NATIO	☐	SO_NATIO	NATION	CHAR	1	0	SAPoffice: international code for character set	*
52	RFCDES	☐	SO_RFCDES	RFCDEST	CHAR	32	0	RFC destination for SAPoffice server	*
53	DEFEXP	☐	SO_DEFEXP	SO_NUM3	NUMC	3	0	Default expiry time for document
54	LADAT	☐	SO_DEF_LAD	SO_NUM3	NUMC	3	0	Default for last access date (last changed)
55	UNIX_DESTI	☐	SO_UNX_DES	SO_RFCDES	CHAR	32	0	SAPoffice: RFC destination of the UNIX mail server
56	RETURN_ADR	☐	SO_RET_ADR	SO_STRI050	CHAR	50	0	SAPoffice: UNIX address for this Office (UNIX server)
57	EXTTELE	☐	SO_EXTTELE	SO_I_FLAG	CHAR	1	0	Authorization to send via telematic services
58	EXTSMTP	☐	SO_EXTSMTP	SO_I_FLAG	CHAR	1	0	Authorization to send via the Internet
59	EXTX400	☐	SO_EXTX400	SO_I_FLAG	CHAR	1	0	Authorization to send via X.400
60	EXTSAP	☐	SO_EXTSAP	SO_I_FLAG	CHAR	1	0	Authorization to send within SAP system group
61	NO_DIR_SND	☐	SO_NDRSND	SO_FLAG	CHAR	1	0	Direct external sending is not allowed in this system
62	NO_EXT_SND	☐	SO_NEXTSND	SO_FLAG	CHAR	1	0	Sending to an external address recipient type not allowed
63	NO_INT_SND	☐	SO_NINTSND	SO_FLAG	CHAR	1	0	Send internally not allowed in this system
64	OUTEXP	☐	SO_OUT_EXP	SO_NUM3	NUMC	3	0	Expiration time for documents in outbox
65	EXTX500	☐	SO_EXTX500	SO_FLAG	CHAR	1	0	Authorization to access the LDAP services
66	UNX_CONFIG	☐	SO_UNXCONF	SO_STRI241	CHAR	241	0	Path specification for a UNIX file
67	DOC_LENGTH	☐	SO_MAX_LEN	SO_DOC_LEN	NUMC	12	0	Query PC documents from this size
68	RESUB_DATE	☐	SO_RES_DAT	DATUM	DATS	8	0	Date of next resubmission
69	RESUB_TIME	☐	SO_RES_TIM	UZEIT	TIMS	6	0	Time of next resubmission in system
70	RS_BATCHID	☐	SO_RS_BTID	NUMC12	NUMC	12	0	ID of the batch item supervising the resubmission
71	FAX_EXIST	☐	SO_EX_FAX	SO_FLAG	CHAR	1	0	Connection to fax communications component
72	TLX_EXIST	☐	SO_EX_TLX	SO_FLAG	CHAR	1	0	Connection to telex communications component
73	SMTP_EXIST	☐	SO_EX_SMTP	SO_FLAG	CHAR	1	0	Connection to Internet Gateway
74	X400_EXIST	☐	SO_EX_X400	SO_FLAG	CHAR	1	0	Connection to X.400 component
75	SAP_EXIST	☐	SO_EX_SAP	SO_FLAG	CHAR	1	0	The SAP system is part of a mail system group
76	X500_EXIST	☐	SO_EX_X500	SO_FLAG	CHAR	1	0	LDAP service connection
77	ORG_EXIST	☐	SO_EX_ORG	SO_FLAG	CHAR	1	0	HR Org is connected and maintained
78	ARCH_EXIST	☐	SO_EX_ARCH	SO_FLAG	CHAR	1	0	Connection to an archive
79	OBJ_EXIST	☐	SO_EX_OBJ	SO_FLAG	CHAR	1	0	Send to Business Objects
80	DIRADDRESS	☐	SO_DIR_ADR	AD_ADDRNUM	CHAR	10	0	Company address for direct addresses (empty or "unknown")	*
81	ADDRBUFCLR	☐	SO_ADBUFCL	SYTSTP	NUMC	14	0	Time stamp for invalidation of buffered addresses
82	ADDRBUFINV	☐	SO_ADBUFIV	SO_BUFIVT	NUMC	4	0	No. of hours (interval) before invalidation of addr. buffer
83	REORGDAILY	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
84	REMOTEDEST	☐	SO_RFCDES	RFCDEST	CHAR	32	0	RFC destination for SAPoffice server	*
85	REMOTENAME	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
86	REMOTECLNT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
87	REMOTERELS	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
88	DISTRIB	☐	SO_DISTRIB	SO_FLAG	CHAR	1	0	This system is part of a system group
89	MAIL_SYSID	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
90	MAIL_MANDT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
91	MAIL_CLNT	☐	SO_RML_MD	SO_MAND	CHAR	3	0	Addresses: Client
92	IBND_UPD	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SOPR	MANDT	T000	MANDT	KEY	1	1
2	SOPR	RSFACID	TFACD	IDENT

History

Last changed by/on	SAP	20130604
SAP Release Created in