SAP ABAP Table USER_ADDRS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	USER_ADDRS	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	DATE_FROM	☑	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
4	NATION	☑	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
5	DATE_FROMCP	☑	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
6	DATE_FROMC	☑	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
7	NAME_FIRST	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
8	NAME_LAST	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
9	NAME_TEXT	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
10	MC_NAMEFIR	☐	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
11	MC_NAMELAS	☐	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
12	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
13	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
14	BUILDING	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
15	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
16	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
17	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
18	INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
19	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
20	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
21	MC_NAME1	☐	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
22	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	USER_ADDRS	BNAME	USR02	BNAME
2	USER_ADDRS	NATION	TSADV	NATION	KEY	1	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in