SAP ABAP Table /VIRSA/USER_ADDR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/VIRSA/USER_ADDR	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
2	BNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
3	NAME_FIRST	☑	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
4	NAME_LAST	☑	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
5	NAME_TEXTC	☑	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
6	TEL_NUMBER	☑	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
7	TEL_EXTENS	☑	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
8	KOSTL	☑	XUKOSTL	CHAR8	CHAR	8	0	Cost center
9	BUILDING	☑	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
10	ROOMNUMBER	☑	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
11	DEPARTMENT	☑	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
12	INHOUSE_ML	☑	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
13	NAME1	☑	AD_NAME1	TEXT40	CHAR	40	0	Name 1
14	CITY1	☑	AD_CITY1	TEXT40	CHAR	40	0	City
15	POST_CODE1	☑	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
16	MC_NAMEFIR	☑	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
17	MC_NAMELAS	☑	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
18	MC_NAME1	☑	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
19	MC_CITY1	☑	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/VIRSA/USER_ADDR	BNAME	USR02	BNAME

History

Last changed by/on	DDIC	20141106
SAP Release Created in