SAP ABAP Table RJGAU_ADR (IS-M/SD: Data Transfer, Address Fields)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	INTTAB	Structure
Structure	RJGAU_ADR	Table Relationship Diagram
Short Description	IS-M/SD: Data Transfer, Address Fields

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	JPARVW	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
2	WDAT1	☐	WDAT1	DATUM	DATS	8	0	Valid from date
3	WDAT2	☐	WDAT2	DATUM	DATS	8	0	To
4	.INCLUDE	☐				0	0	IS-M/SD: Address Fields from Screen Input
5	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
6	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
7	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
8	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
9	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
10	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
11	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
12	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
13	.INCLUDE	☐				0	0	Core address data
14	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
15	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
16	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
17	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
18	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
19	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
20	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
21	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
22	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
23	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
24	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
25	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
26	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
27	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
28	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
29	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
30	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
31	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
32	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
33	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
34	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
35	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
36	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
37	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
38	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
39	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
40	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
41	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
42	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
43	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
44	.INCLUDE	☐				0	0	IS-P: Home/Work Telephone Data
45	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
46	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
47	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
48	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
49	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
50	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
51	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJGAU_ADR	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	RJGAU_ADR	ANRED	TJG43	JANRED
3	RJGAU_ADR	JPARVW	TJG39	JPARVW
4	RJGAU_ADR	LAND1	T005	LAND1
5	RJGAU_ADR	NAMZU	T535N	TITEL
6	RJGAU_ADR	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
7	RJGAU_ADR	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
8	RJGAU_ADR	REGIO	T005S	BLAND
9	RJGAU_ADR	SPRAS	T002	SPRAS
10	RJGAU_ADR	TITEL	T535N	TITEL
11	RJGAU_ADR	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in