SAP ABAP Table V_SOUDADRP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SOUDADRP	Table Relationship Diagram
Short Description	Generated Table for View

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	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	ADREXT	☐	SO_ADR_EXT	SO_FLAG	CHAR	1	0	The user has an active external address.
43	PRWYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
44	PRWNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
45	PUWYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
46	PUWNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
47	INBYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
48	INBNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
49	OUTYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
50	OUTNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
51	WSTYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
52	WSTNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
53	PFRYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
54	PFRNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
55	PDLYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
56	PDLNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
57	VORYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
58	VORNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
59	NOTYR	☐	SO_OBJ_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
60	NOTNO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID
61	DELETED	☐	SO_USR_DEL	SO_FLAG	CHAR	1	0	SAPoffice: Office user was deleted
62	RSWORKDAY	☐	SO_RSWD	SO_FLAG	CHAR	1	0	Resubmission on workdays only
63	RSFACID	☐	SO_RSFACID	WFCID	CHAR	2	0	Factory calendar identification code for the resubmission	TFACD
64	USRADR	☐	AD_SO_KEY	AD_SO_KEY	CHAR	10	0	SAP-Office key
65	LFDNR	☐	SO_LFDNR	SO_TEXT003	CHAR	3	0	Addresses: Sequence number
66	SNDART	☐	SO_TEXT003	SO_TEXT003	CHAR	3	0	Text field length 3: for use as required
67	FLAG1	☐	SO_TEXT001	SO_TEXT001	CHAR	1	0	Text field length 1
68	FLAG2	☐	SO_STORE_I	SO_FLAG	CHAR	1	0	Retain default document for entire session
69	FLAG3	☐	SO_TEXT001	SO_TEXT001	CHAR	1	0	Text field length 1
70	NATIO	☐	SO_NATIO	NATION	CHAR	1	0	SAPoffice: international code for character set
71	LADAT	☐	SO_DEF_LAD	SO_NUM3	NUMC	3	0	Default for last access date (last changed)
72	VLADAT	☐	SO_DAT_VLA	DATUM	DATS	8	0	Second last access of user to SAPoffice
73	LASDAT	☐	SO_DAT_LAS	DATUM	DATS	8	0	Last access to SAPoffice by substitute
74	EXTTELE	☐	SO_EXTTELE	SO_I_FLAG	CHAR	1	0	Authorization to send via telematic services
75	EXTSMTP	☐	SO_EXTSMTP	SO_I_FLAG	CHAR	1	0	Authorization to send via the Internet
76	EXTX400	☐	SO_EXTX400	SO_I_FLAG	CHAR	1	0	Authorization to send via X.400
77	EXTSAP	☐	SO_EXTSAP	SO_I_FLAG	CHAR	1	0	Authorization to send within SAP system group
78	ABTEI	☐	DEPTM	TEXT30	CHAR	30	0	Addresses: Department
79	ROOMN	☐	ROOM_NR	TEXT6	CHAR	6	0	Addresses: Room number
80	BUILD	☐	BUIL_NR	TEXT6	CHAR	6	0	Addresses: Building number
81	ADRNAME	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
82	NAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
83	AREPYR	☐	SO_AAN_YR	SO_OBJ_YR	CHAR	2	0	Automatic reply: year from the ID
84	AREPNO	☐	SO_AAN_NO	SO_OBJ_NO	CHAR	12	0	Automatic reply: number from the ID
85	AREPABDAT	☐	SO_DAT_AB	DATUM	DATS	8	0	Date from when the automatic reply is active
86	AREPAEDAT	☐	SO_DAT_AE	DATUM	DATS	8	0	Date up to which automatic reply is active
87	SCRFORM	☐	SO_SCRFORM	SO_FORM	CHAR	16	0	SAPoffice: User-defined standard SAPscript layout set
88	FAXFORM	☐	SO_FAXFORM	SO_FORM	CHAR	16	0	SAPoffice: User layout set name for faxing
89	SYUSRINB	☐	SO_SYUSRIN	SO_TEXT001	CHAR	1	0	Inbox filter (unviewed documents only)
90	SYUSROUT	☐	SO_SYUSROU	SO_TEXT001	CHAR	1	0	User view of outbox

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in