SAP ABAP Table USR03 (User address data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-USR-ADM (Application Component) User and Authorization Management
     ⤷ SUSR (Package) ABAP User Administration

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	USR03	Table Relationship Diagram
Short Description	User address data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	BNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
3	NAME1	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
4	NAME2	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
5	NAME3	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
6	NAME4	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
7	SALUT	☐	XUSALUT	XUSALUT	CHAR	15	0	Form of address for letters
8	ABTLG	☐	XUABTEI	ABTEI	CHAR	12	0	Department
9	KOSTL	☐	XUKOSTL	CHAR8	CHAR	8	0	Cost center
10	BUINR	☐	XUBUINR	XUBUINR	CHAR	6	0	Building number
11	ROONR	☐	XUROONR	XUROONR	CHAR	6	0	Room number
12	STRAS	☐	XUSTRAS	TEXT30	CHAR	30	0	Street and House Number
13	PFACH	☐	XUPFACH	XUPFACH	CHAR	10	0	PO box
14	PSTLZ	☐	XUPSTLZ	XUPSTLZ	CHAR	10	0	Postal code
15	ORT01	☐	XUORT01	TEXT25	CHAR	25	0	Location
16	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
17	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
18	SPRAS	☐	XUSPRAS	SPRAS	LANG	1	0	Language Key	T002
19	TELPR	☐	XUTELPR	XUTELNR	CHAR	16	0	Telephone number (private)
20	TELNR	☐	XUTELNR	XUTELNR	CHAR	16	0	Telephone number (work)
21	TEL01	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
22	TEL02	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
23	TELX1	☐	XUTELX1	TEXT30	CHAR	30	0	Telex number
24	TELFX	☐	XUTELFX	TEXT31	CHAR	31	0	Fax Number
25	TELTX	☐	XUTELTX	TEXT30	CHAR	30	0	Teletex number
26	ORT02	☐	XUORT02	TEXT25	CHAR	25	0	Location
27	PSTL2	☐	XUPSTL2	XUPSTLZ	CHAR	10	0	District Postal Code
28	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USR03	LAND1	T005	LAND1
2	USR03	MANDT	T000	MANDT	KEY	1	CN
3	USR03	REGIO	T005S	BLAND
4	USR03	SPRAS	T002	SPRAS	KEY	1	CN
5	USR03	TZONE	TTZZ	TZONE

History

Last changed by/on	SAP	20130604
SAP Release Created in