SAP ABAP Table V_SOUDADCP (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20141013
SAP Release Created in