SAP ABAP Table USER_ADDR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	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_EXTENS	☑	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
7	KOSTL	☑	XUKOSTL	CHAR8	CHAR	8	0	Cost center
8	BUILDING	☑	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
9	ROOMNUMBER	☑	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
10	DEPARTMENT	☑	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
11	INHOUSE_ML	☑	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
12	NAME1	☑	AD_NAME1	TEXT40	CHAR	40	0	Name 1
13	CITY1	☑	AD_CITY1	TEXT40	CHAR	40	0	City
14	POST_CODE1	☑	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
15	MC_NAMEFIR	☑	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
16	MC_NAMELAS	☑	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
17	MC_NAME1	☑	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
18	MC_CITY1	☑	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
19	COMPANY	☑	USCOMP	USCOMP	CHAR	42	0	Company address, cross-system key

Foreign Keys

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

History

Last changed by/on	SAP	20141013
SAP Release Created in