SAP ABAP Table SOUD (SAPoffice: user definition)

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	SOUD	Table Relationship Diagram
Short Description	SAPoffice: user definition

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	USRTP	☑	SO_USR_TP	SO_OBJ_TP	CHAR	3	0	User type from ID	TSOTD
3	USRYR	☑	SO_USR_YR	SO_OBJ_YR	CHAR	2	0	User year from the ID
4	USRNO	☑	SO_USR_NO	SO_USR_NO	CHAR	12	0	User number from the ID
5	CROTP	☐	SO_CRO_TP	SO_OBJ_TP	CHAR	3	0	User who created object: Object type from ID	TSOTD
6	CROYR	☐	SO_CRO_YR	SO_OBJ_YR	CHAR	2	0	User that created object: year from the ID
7	CRONO	☐	SO_CRO_NO	SO_OBJ_NO	CHAR	12	0	User that created object: number from the ID	*
8	CRONAM	☐	SO_CRO_NAM	USERNAME	CHAR	12	0	Creator Name
9	CRDAT	☐	SO_DAT_CR	DATUM	DATS	8	0	Date created
10	CRTIM	☐	SO_TIM_CR	UZEIT	TIMS	6	0	Time created
11	CHOTP	☐	SO_CHO_TP	SO_OBJ_TP	CHAR	3	0	User that changed the object: Object type from ID	TSOTD
12	CHOYR	☐	SO_CHO_YR	SO_OBJ_YR	CHAR	2	0	User that changed the object: year from the ID
13	CHONO	☐	SO_CHO_NO	SO_OBJ_NO	CHAR	12	0	User that changed the object: number from the ID	*
14	CHONAM	☐	SO_CHO_NAM	USERNAME	CHAR	12	0	Changed by
15	CHDAT	☐	SO_DAT_CH	DATUM	DATS	8	0	Date of Last Change
16	CHTIM	☐	SO_TIM_CH	UZEIT	TIMS	6	0	Time of Last Change
17	SAPNAM	☐	SO_SAP_NAM	USERNAME	CHAR	12	0	SAP name of a SAPoffice user
18	USRNAM	☐	SO_USR_NAM	USERNAME	CHAR	12	0	SAPoffice user name
19	LOADAT	☐	SO_DAT_LOA	DATUM	DATS	8	0	Last access to SAPoffice by user
20	EXMAX	☐	SO_EXMAX	SO_CNT2	RAW	2	0	Maximum number of express messages allowed per send
21	RCMAX	☐	SO_RCMAX	SO_CNT2	RAW	2	0	Maximum number of recipients allowed per send
22	INMAX	☐	SO_INMAX	SO_CNT2	RAW	2	0	Maximum number of documents allowed in the inbox
23	USRAU	☐	SO_USRAU	SO_FLAG	CHAR	1	0	Maintain user: only the administrator is authorized
24	CRGDL	☐	SO_CRGDL	SO_I_FLAG	CHAR	1	0	Authorization to create shared distribution lists
25	CRFCL	☐	SO_CRFCL	SO_I_FLAG	CHAR	1	0	Authorization to create client folders
26	CRFCC	☐	SO_CRFCC	SO_I_FLAG	CHAR	1	0	Authorization to create company-code-wide folders
27	CRFPL	☐	SO_CRFPL	SO_I_FLAG	CHAR	1	0	Authorization to create plant-wide folders
28	CRFDP	☐	SO_CRFDP	SO_I_FLAG	CHAR	1	0	Authorization to create department-wide folders
29	CRFAD	☐	SO_CRFAD	SO_I_FLAG	CHAR	1	0	Authorization to create cost-center-wide folders
30	CRFGR	☐	SO_CRFGR	SO_I_FLAG	CHAR	1	0	Authorization to create group folders
31	HOMAX	☐	SO_HOMAX	SO_CNT1	RAW	1	0	Max. no. of documents a user can protect from archiving
32	HOCNT	☐	SO_HOCNT	SO_CNT1	RAW	1	0	Number of documents which should not be archived
33	GLMAX	☐	SO_GLMAX	SO_CNT1	RAW	1	0	Maximum size of the access lists of a user
34	GFMAX	☐	SO_GFMAX	SO_CNT1	RAW	1	0	Max. number of group folders which a user can create
35	GFCNT	☐	SO_GFCNT	SO_CNT1	RAW	1	0	Number of group folders created by a user
36	AUTEXT	☐	SO_AUT_EXT	SO_I_FLAG	CHAR	1	0	Authorization to send externally
37	NOTTP	☐	SO_NOT_TP	SO_OBJ_TP	CHAR	3	0	Default setting of document class	TSOTD
38	CALEN	☐	SO_CALEN	SO_CALEN	CHAR	1	0	Day on which the week begins
39	OUTFL	☐	SO_OUTFL	SO_FLAG	CHAR	1	0	Documents are copied to the outbox when sent
40	SQWIN	☐	SO_SQWIN	SO_FLAG	CHAR	1	0	Switch confirmation prompt on or off when deleting
41	SYUSR	☐	SO_SYUSR	SO_FLAG	CHAR	1	0	Your user view is set when you start SAPoffice
42	SYUSRINB	☐	SO_SYUSRIN	SO_TEXT001	CHAR	1	0	Inbox filter (unviewed documents only)
43	SYUSROUT	☐	SO_SYUSROU	SO_TEXT001	CHAR	1	0	User view of outbox
44	ADREXT	☐	SO_ADR_EXT	SO_FLAG	CHAR	1	0	The user has an active external address.
45	PRWYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
46	PRWNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
47	PUWYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
48	PUWNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
49	INBYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
50	INBNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
51	OUTYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
52	OUTNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
53	WSTYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
54	WSTNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
55	PFRYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
56	PFRNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
57	PDLYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
58	PDLNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
59	VORYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
60	VORNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
61	NOTYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
62	NOTNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
63	DELETED	☐	SO_USR_DEL	SO_FLAG	CHAR	1	0	SAPoffice: Office user was deleted
64	RSWORKDAY	☐	SO_RSWD	SO_FLAG	CHAR	1	0	Resubmission on workdays only
65	RSFACID	☐	SO_RSFACID	WFCID	CHAR	2	0	Factory calendar identification code for the resubmission	TFACD
66	USRADR	☐	AD_SO_KEY	AD_SO_KEY	CHAR	10	0	SAP-Office key
67	LFDNR	☐	SO_LFDNR	SO_TEXT003	CHAR	3	0	Addresses: Sequence number
68	SNDART	☐	SO_TEXT003	SO_TEXT003	CHAR	3	0	Text field length 3: for use as required
69	FLAG1	☐	SO_TEXT001	SO_TEXT001	CHAR	1	0	Text field length 1
70	FLAG2	☐	SO_STORE_I	SO_FLAG	CHAR	1	0	Retain default document for entire session
71	FLAG3	☐	SO_TEXT001	SO_TEXT001	CHAR	1	0	Text field length 1
72	NATIO	☐	SO_NATIO	NATION	CHAR	1	0	SAPoffice: international code for character set	*
73	LADAT	☐	SO_DEF_LAD	SO_NUM3	NUMC	3	0	Default for last access date (last changed)
74	VLADAT	☐	SO_DAT_VLA	DATUM	DATS	8	0	Second last access of user to SAPoffice
75	LASDAT	☐	SO_DAT_LAS	DATUM	DATS	8	0	Last access to SAPoffice by substitute
76	EXTTELE	☐	SO_EXTTELE	SO_I_FLAG	CHAR	1	0	Authorization to send via telematic services
77	EXTSMTP	☐	SO_EXTSMTP	SO_I_FLAG	CHAR	1	0	Authorization to send via the Internet
78	EXTX400	☐	SO_EXTX400	SO_I_FLAG	CHAR	1	0	Authorization to send via X.400
79	EXTSAP	☐	SO_EXTSAP	SO_I_FLAG	CHAR	1	0	Authorization to send within SAP system group
80	AREPYR	☐	SO_AAN_YR	SO_OBJ_YR	CHAR	2	0	Automatic reply: year from the ID
81	AREPNO	☐	SO_AAN_NO	SO_OBJ_NO	CHAR	12	0	Automatic reply: number from the ID	*
82	AREPABDAT	☐	SO_DAT_AB	DATUM	DATS	8	0	Date from when the automatic reply is active
83	AREPAEDAT	☐	SO_DAT_AE	DATUM	DATS	8	0	Date up to which automatic reply is active
84	FAXFORM	☐	SO_FAXFORM	SO_FORM	CHAR	16	0	SAPoffice: User layout set name for faxing
85	SCRFORM	☐	SO_SCRFORM	SO_FORM	CHAR	16	0	SAPoffice: User-defined standard SAPscript layout set
86	CHATSEND	☐	SO_CHATSEN	SO_TEXT001	CHAR	1	0	Change options for document after sending
87	NOARSDEX	☐	SO_NOARSDE	SO_FLAG	CHAR	1	0	Send automatic reply externally
88	PRPARCHG	☐	SO_PRPARCH	SO_FLAG	CHAR	1	0	Default settings for calling print parameters
89	PRPARNDH	☐	SO_PRPANDH	SO_FLAG	CHAR	1	0	Default settings for printing of document header
90	PRPARRCL	☐	SO_PRPARRL	SO_FLAG	CHAR	1	0	Default settings for printing of recipient list
91	PRPARNOP	☐	SO_PRPARNP	SO_FLAG	CHAR	1	0	Default settings for printing of notes
92	DELFORIB	☐	SO_DELFOIB	SO_FLAG	CHAR	1	0	Delete document from inbox after forwarding
93	GHRAWDOC	☐	SO_GHRAWDO	SO_FLAG	CHAR	1	0	Display of document header in continuos-text editor
94	FOLDSORT	☐	SO_FOLSORT	SO_TEXT001	CHAR	1	0	Setting for sorting folders subscribed to
95	DELTRASH	☐	SO_DELTRSH	SO_TEXT003	CHAR	3	0	No. of calendar days after which doc. is deleted from trash
96	RSDOCFOR	☐	SO_DAT_RDF	DATUM	DATS	8	0	Resubmission date of forwarded document
97	FOLASDYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
98	FOLASDNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
99	FOLLINYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
100	FOLLINNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
101	FOLCRDYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
102	FOLCRDNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
103	LINKDOYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
104	LINKDONO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
105	NORTFEDIT	☐	SO_NRTFEDT	SO_TEXT001	CHAR	1	0	Continuos-text editor for SAP editor documents
106	PCOLE	☐	SO_PCOLE	SO_TEXT001	CHAR	1	0	Start PC application in SAP window

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SOUD	CHOTP	TSOTD	OBJTP	REF	1	1
2	SOUD	CROTP	TSOTD	OBJTP	REF	1	1
3	SOUD	MANDT	T000	MANDT	KEY	1	1
4	SOUD	NOTTP	TSOTD	OBJTP	REF	1	1
5	SOUD	RSFACID	TFACD	IDENT
6	SOUD	USRTP	TSOTD	OBJTP	KEY	1	1

History

Last changed by/on	SAP	20110908
SAP Release Created in