SAP ABAP Table V_SOUSRADR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SOUSRADR	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	SAPNAM	☑	SO_SAP_NAM	USERNAME	CHAR	12	0	SAP name of a SAPoffice user
3	USRTP	☑	SO_USR_TP	SO_OBJ_TP	CHAR	3	0	User type from ID	TSOTD
4	USRYR	☑	SO_USR_YR	SO_OBJ_YR	CHAR	2	0	User year from the ID
5	USRNO	☑	SO_USR_NO	SO_USR_NO	CHAR	12	0	User number from the ID	SOUD
6	USRNAM	☑	SO_USR_NAM	USERNAME	CHAR	12	0	SAPoffice user name
7	DELETED	☑	SO_USR_DEL	SO_FLAG	CHAR	1	0	SAPoffice: Office user was deleted
8	ADRNR	☑	ADRNR	ADRNR	CHAR	10	0	Address
9	NATIO	☑	INTER	NATION	CHAR	1	0	International address version ID
10	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
11	ABTEI	☐	DEPTM	TEXT30	CHAR	30	0	Addresses: Department
12	COSTC	☐	COST_CT	TEXT10	CHAR	10	0	Addresses: Cost center
13	ROOMN	☐	ROOM_NR	TEXT6	CHAR	6	0	Addresses: Room number
14	BUILD	☐	BUIL_NR	TEXT6	CHAR	6	0	Addresses: Building number
15	NAME1	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
16	NAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
17	STDCOM	☐	COM_ART	COM_ART	CHAR	3	0	Addresses: Communication type
18	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
19	CHNAM	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
20	CHDAT	☐	CH_DAT	DATUM	DATS	8	0	Addresses: Change date
21	CHTIM	☐	CH_TIM	UZEIT	TIMS	6	0	Addresses: Changed at
22	CRNAM	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
23	CRDAT	☐	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
24	CRTIM	☐	CR_TIM	UZEIT	TIMS	6	0	Addresses: Creation time
25	KLASSE	☐	SO_KLASSE	KLASSE	CHAR	18	0	Addresses: class assigned to an address
26	DBNAME	☐	SYM_DST	CHAR10	CHAR	10	0	Addresses: System ID
27	CMPYADR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	SADR
28	ANREK	☐	ANREK	ANREK	CHAR	2	0	Addresses: Form of address key
29	SORT1	☐	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
30	SORT2	☐	SORT20	CHAR20	CHAR	20	0	Sort field
31	FNAME	☐	AD_FNAME	TEXT35	CHAR	35	0	A person's first name (Addresses)
32	UCFNAME	☐	AD_UCFNAME	CHAR25	CHAR	25	0	A person's first name in upper case (Addresses)
33	LNAME	☐	AD_LNAME	TEXT35	CHAR	35	0	A person's last name (Addresses)
34	UCLNAME	☐	AD_UCLNAME	CHAR25	CHAR	25	0	A person's last name (Addresses)
35	UCABTEI	☐	AD_UCABTEI	CHAR25	CHAR	25	0	Department in upper case (Addresses)
36	UCNAMECMPY	☐	AD_UCNAMCP	CHAR25	CHAR	25	0	Company name in upper case (addresses)
37	USRTYPE	☐	AD_USRTYPE	XFELD	CHAR	1	0	Flag: Person is internal SAP user
38	REFNR	☐	ADRNR_REF	ADRNR	CHAR	10	0	Address reference for alias names	SADRP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SOUSRADR	CMPYADR	SADR	ADRNR	KEY	1	CN
2	V_SOUSRADR	MANDT	T000	MANDT
3	V_SOUSRADR	REFNR	SADRP	ADRNR
4	V_SOUSRADR	SPRAS	T002	SPRAS	KEY	1	CN
5	V_SOUSRADR	USRNO	SOUD	USRNO	REF	1	1
6	V_SOUSRADR	USRTP	TSOTD	OBJTP	REF	1	1

History

Last changed by/on	SAP	20130604
SAP Release Created in