SAP ABAP Table J_7LUSR03 (REA Declar.: Personal Data for Communication Structure Doc.)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
     ⤷ J7LR (Package) REA Core Functionality

Basic Data

Table Category	INTTAB	Structure
Structure	J_7LUSR03	Table Relationship Diagram
Short Description	REA Declar.: Personal Data for Communication Structure Doc.

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	.INCLU-USR	☐				0	0	User address data
2	MANDTUSR	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BNAMEUSR	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
4	NAME1USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
5	NAME2USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
6	NAME3USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
7	NAME4USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
8	SALUTUSR	☐	XUSALUT	XUSALUT	CHAR	15	0	Form of address for letters
9	ABTLGUSR	☐	XUABTEI	ABTEI	CHAR	12	0	Department
10	KOSTLUSR	☐	XUKOSTL	CHAR8	CHAR	8	0	Cost center
11	BUINRUSR	☐	XUBUINR	XUBUINR	CHAR	6	0	Building number
12	ROONRUSR	☐	XUROONR	XUROONR	CHAR	6	0	Room number
13	STRASUSR	☐	XUSTRAS	TEXT30	CHAR	30	0	Street and House Number
14	PFACHUSR	☐	XUPFACH	XUPFACH	CHAR	10	0	PO box
15	PSTLZUSR	☐	XUPSTLZ	XUPSTLZ	CHAR	10	0	Postal code
16	ORT01USR	☐	XUORT01	TEXT25	CHAR	25	0	Location
17	REGIOUSR	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
18	LAND1USR	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
19	SPRASUSR	☐	XUSPRAS	SPRAS	LANG	1	0	Language Key	T002
20	TELPRUSR	☐	XUTELPR	XUTELNR	CHAR	16	0	Telephone number (private)
21	TELNRUSR	☐	XUTELNR	XUTELNR	CHAR	16	0	Telephone number (work)
22	TEL01USR	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
23	TEL02USR	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
24	TELX1USR	☐	XUTELX1	TEXT30	CHAR	30	0	Telex number
25	TELFXUSR	☐	XUTELFX	TEXT31	CHAR	31	0	Fax Number
26	TELTXUSR	☐	XUTELTX	TEXT30	CHAR	30	0	Teletex number
27	ORT02USR	☐	XUORT02	TEXT25	CHAR	25	0	Location
28	PSTL2USR	☐	XUPSTL2	XUPSTLZ	CHAR	10	0	District Postal Code
29	TZONEUSR	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
30	UNAME	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
31	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
32	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LUSR03	LAND1USR	T005	LAND1
2	J_7LUSR03	MANDTUSR	T000	MANDT	KEY	1	CN
3	J_7LUSR03	REGIOUSR	T005S	BLAND
4	J_7LUSR03	SPRASUSR	T002	SPRAS	KEY	1	CN
5	J_7LUSR03	TZONEUSR	TTZZ	TZONE

History

Last changed by/on	SAP	20130529
SAP Release Created in