SAP ABAP View V_SOUDADRP (SAPoffice: View of SOUD and Fields of SADRP (Addresses))

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_SOUDADRP
Short Description	SAPoffice: View of SOUD and Fields of SADRP (Addresses)
Root table	SOUD	SAPoffice: user definition

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SOUD	SOUD
2	SADRP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SADRP	MANDT	JL	EQ				0	0
2	SOUD	MANDT	JR	EQ			AND	0	0
3	SADRP	ADRNR	JL	EQ				0	0
4	SOUD	USRADR	JR	EQ			AND	0	0
5	SADRP	NATIO	JL	EQ				0	0
6	SOUD	NATIO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SOUD	MANDT		☐	MANDT	☐	Client
2	USRTP	SOUD	USRTP		☐	SO_USR_TP	☐	User type from ID
3	USRYR	SOUD	USRYR		☐	SO_USR_YR	☐	User year from the ID
4	USRNO	SOUD	USRNO		☐	SO_USR_NO	☐	User number from the ID
5	CROTP	SOUD	CROTP		☐	SO_CRO_TP	☐	User who created object: Object type from ID
6	CROYR	SOUD	CROYR		☐	SO_CRO_YR	☐	User that created object: year from the ID
7	CRONO	SOUD	CRONO		☐	SO_CRO_NO	☐	User that created object: number from the ID
8	CRONAM	SOUD	CRONAM		☐	SO_CRO_NAM	☐	Creator Name
9	CRDAT	SOUD	CRDAT		☐	SO_DAT_CR	☐	Date created
10	CRTIM	SOUD	CRTIM		☐	SO_TIM_CR	☐	Time created
11	CHOTP	SOUD	CHOTP		☐	SO_CHO_TP	☐	User that changed the object: Object type from ID
12	CHOYR	SOUD	CHOYR		☐	SO_CHO_YR	☐	User that changed the object: year from the ID
13	CHONO	SOUD	CHONO		☐	SO_CHO_NO	☐	User that changed the object: number from the ID
14	CHONAM	SOUD	CHONAM		☐	SO_CHO_NAM	☐	Changed by
15	CHDAT	SOUD	CHDAT		☐	SO_DAT_CH	☐	Date of Last Change
16	CHTIM	SOUD	CHTIM		☐	SO_TIM_CH	☐	Time of Last Change
17	SAPNAM	SOUD	SAPNAM		☐	SO_SAP_NAM	☐	SAP name of a SAPoffice user
18	USRNAM	SOUD	USRNAM		☐	SO_USR_NAM	☐	SAPoffice user name
19	LOADAT	SOUD	LOADAT		☐	SO_DAT_LOA	☐	Last access to SAPoffice by user
20	EXMAX	SOUD	EXMAX		☐	SO_EXMAX	☐	Maximum number of express messages allowed per send
21	RCMAX	SOUD	RCMAX		☐	SO_RCMAX	☐	Maximum number of recipients allowed per send
22	INMAX	SOUD	INMAX		☐	SO_INMAX	☐	Maximum number of documents allowed in the inbox
23	USRAU	SOUD	USRAU		☐	SO_USRAU	☐	Maintain user: only the administrator is authorized
24	CRGDL	SOUD	CRGDL		☐	SO_CRGDL	☐	Authorization to create shared distribution lists
25	CRFCL	SOUD	CRFCL		☐	SO_CRFCL	☐	Authorization to create client folders
26	CRFCC	SOUD	CRFCC		☐	SO_CRFCC	☐	Authorization to create company-code-wide folders
27	CRFPL	SOUD	CRFPL		☐	SO_CRFPL	☐	Authorization to create plant-wide folders
28	CRFDP	SOUD	CRFDP		☐	SO_CRFDP	☐	Authorization to create department-wide folders
29	CRFAD	SOUD	CRFAD		☐	SO_CRFAD	☐	Authorization to create cost-center-wide folders
30	CRFGR	SOUD	CRFGR		☐	SO_CRFGR	☐	Authorization to create group folders
31	HOMAX	SOUD	HOMAX		☐	SO_HOMAX	☐	Max. no. of documents a user can protect from archiving
32	HOCNT	SOUD	HOCNT		☐	SO_HOCNT	☐	Number of documents which should not be archived
33	GLMAX	SOUD	GLMAX		☐	SO_GLMAX	☐	Maximum size of the access lists of a user
34	GFMAX	SOUD	GFMAX		☐	SO_GFMAX	☐	Max. number of group folders which a user can create
35	GFCNT	SOUD	GFCNT		☐	SO_GFCNT	☐	Number of group folders created by a user
36	AUTEXT	SOUD	AUTEXT		☐	SO_AUT_EXT	☐	Authorization to send externally
37	NOTTP	SOUD	NOTTP		☐	SO_NOT_TP	☐	Default setting of document class
38	CALEN	SOUD	CALEN		☐	SO_CALEN	☐	Day on which the week begins
39	OUTFL	SOUD	OUTFL		☐	SO_OUTFL	☐	Documents are copied to the outbox when sent
40	SQWIN	SOUD	SQWIN		☐	SO_SQWIN	☐	Switch confirmation prompt on or off when deleting
41	SYUSR	SOUD	SYUSR		☐	SO_SYUSR	☐	Your user view is set when you start SAPoffice
42	ADREXT	SOUD	ADREXT		☐	SO_ADR_EXT	☐	The user has an active external address.
43	PRWYR	SOUD	PRWYR		☐	SO_OBJ_YR	☐	Object: Year from ID
44	PRWNO	SOUD	PRWNO		☐	SO_OBJ_NO	☐	Object: Number from ID
45	PUWYR	SOUD	PUWYR		☐	SO_OBJ_YR	☐	Object: Year from ID
46	PUWNO	SOUD	PUWNO		☐	SO_OBJ_NO	☐	Object: Number from ID
47	INBYR	SOUD	INBYR		☐	SO_OBJ_YR	☐	Object: Year from ID
48	INBNO	SOUD	INBNO		☐	SO_OBJ_NO	☐	Object: Number from ID
49	OUTYR	SOUD	OUTYR		☐	SO_OBJ_YR	☐	Object: Year from ID
50	OUTNO	SOUD	OUTNO		☐	SO_OBJ_NO	☐	Object: Number from ID
51	WSTYR	SOUD	WSTYR		☐	SO_OBJ_YR	☐	Object: Year from ID
52	WSTNO	SOUD	WSTNO		☐	SO_OBJ_NO	☐	Object: Number from ID
53	PFRYR	SOUD	PFRYR		☐	SO_OBJ_YR	☐	Object: Year from ID
54	PFRNO	SOUD	PFRNO		☐	SO_OBJ_NO	☐	Object: Number from ID
55	PDLYR	SOUD	PDLYR		☐	SO_OBJ_YR	☐	Object: Year from ID
56	PDLNO	SOUD	PDLNO		☐	SO_OBJ_NO	☐	Object: Number from ID
57	VORYR	SOUD	VORYR		☐	SO_OBJ_YR	☐	Object: Year from ID
58	VORNO	SOUD	VORNO		☐	SO_OBJ_NO	☐	Object: Number from ID
59	NOTYR	SOUD	NOTYR		☐	SO_OBJ_YR	☐	Object: Year from ID
60	NOTNO	SOUD	NOTNO		☐	SO_OBJ_NO	☐	Object: Number from ID
61	DELETED	SOUD	DELETED		☐	SO_USR_DEL	☐	SAPoffice: Office user was deleted
62	RSWORKDAY	SOUD	RSWORKDAY		☐	SO_RSWD	☐	Resubmission on workdays only
63	RSFACID	SOUD	RSFACID		☐	SO_RSFACID	☐	Factory calendar identification code for the resubmission
64	USRADR	SOUD	USRADR		☐	AD_SO_KEY	☐	SAP-Office key
65	LFDNR	SOUD	LFDNR		☐	SO_LFDNR	☐	Addresses: Sequence number
66	SNDART	SOUD	SNDART		☐	SO_TEXT003	☐	Text field length 3: for use as required
67	FLAG1	SOUD	FLAG1		☐	SO_TEXT001	☐	Text field length 1
68	FLAG2	SOUD	FLAG2		☐	SO_STORE_I	☐	Retain default document for entire session
69	FLAG3	SOUD	FLAG3		☐	SO_TEXT001	☐	Text field length 1
70	NATIO	SOUD	NATIO		☐	SO_NATIO	☐	SAPoffice: international code for character set
71	LADAT	SOUD	LADAT		☐	SO_DEF_LAD	☐	Default for last access date (last changed)
72	VLADAT	SOUD	VLADAT		☐	SO_DAT_VLA	☐	Second last access of user to SAPoffice
73	LASDAT	SOUD	LASDAT		☐	SO_DAT_LAS	☐	Last access to SAPoffice by substitute
74	EXTTELE	SOUD	EXTTELE		☐	SO_EXTTELE	☐	Authorization to send via telematic services
75	EXTSMTP	SOUD	EXTSMTP		☐	SO_EXTSMTP	☐	Authorization to send via the Internet
76	EXTX400	SOUD	EXTX400		☐	SO_EXTX400	☐	Authorization to send via X.400
77	EXTSAP	SOUD	EXTSAP		☐	SO_EXTSAP	☐	Authorization to send within SAP system group
78	ABTEI	SADRP	ABTEI		☐	DEPTM	☐	Addresses: Department
79	ROOMN	SADRP	ROOMN		☐	ROOM_NR	☐	Addresses: Room number
80	BUILD	SADRP	BUILD		☐	BUIL_NR	☐	Addresses: Building number
81	ADRNAME	SADRP	NAME1		☐	NAME1_BAS	☐	Name 1
82	NAME2	SADRP	NAME2		☐	NAME2_BAS	☐	Name 2
83	AREPYR	SOUD	AREPYR		☐	SO_AAN_YR	☐	Automatic reply: year from the ID
84	AREPNO	SOUD	AREPNO		☐	SO_AAN_NO	☐	Automatic reply: number from the ID
85	AREPABDAT	SOUD	AREPABDAT		☐	SO_DAT_AB	☐	Date from when the automatic reply is active
86	AREPAEDAT	SOUD	AREPAEDAT		☐	SO_DAT_AE	☐	Date up to which automatic reply is active
87	SCRFORM	SOUD	SCRFORM		☐	SO_SCRFORM	☐	SAPoffice: User-defined standard SAPscript layout set
88	FAXFORM	SOUD	FAXFORM		☐	SO_FAXFORM	☐	SAPoffice: User layout set name for faxing
89	SYUSRINB	SOUD	SYUSRINB		☐	SO_SYUSRIN	☐	Inbox filter (unviewed documents only)
90	SYUSROUT	SOUD	SYUSROUT		☐	SO_SYUSROU	☐	User view of outbox

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in