SAP ABAP Table SOPRD (SAPoffice: system-wide profile (data part))

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	INTTAB	Structure
Structure	SOPRD	Table Relationship Diagram
Short Description	SAPoffice: system-wide profile (data part)

Delivery and Maintenance

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

History

Last changed by/on	SAP	20130604
SAP Release Created in