SAP ABAP Table RJGADRA (IS-M: Address Data - Transfer Structure)

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	RJGADRA	Table Relationship Diagram
Short Description	IS-M: Address Data - Transfer Structure

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	LOGADR	☐	JLOGADR	JLOGADR	NUMC	4	0	IS-M: Logical Address Number
2	ADRZA	☐	JADRZA	JADRTA	NUMC	4	0	IS-M: Time Slice Counter in Logical Address
3	.INCLUDE	☐				0	0	IS-M: Extended Adress Management
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
6	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
7	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
8	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
9	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
10	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
11	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
12	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
13	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
14	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
15	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
16	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
17	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
18	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
19	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
20	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
21	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
22	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
23	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
24	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
25	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
26	.INCLUDE	☐				0	0	Core address data
27	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
28	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
29	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
30	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
31	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
32	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
33	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
34	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
35	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
36	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
37	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
38	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
39	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
40	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
41	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
42	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
43	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
44	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
45	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
46	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
47	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
48	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
49	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
50	.INCLUDE	☐				0	0	Include Structure for Alias (Direction, Area, Search Field)
51	ALIASPREDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
52	ALIASPOSTDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
53	ALIASDELADDRLOW	☐	ADDRPRIMLOW	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Lower Limit)
54	ALIASDELADDRHIGH	☐	ADDRPRIMHIGH	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Upper Limit)
55	ALIASDELODDEVEN	☐	ODDEVENCODE	ODDEVENCODE	CHAR	1	0	IS-M: Indicator - Even/Odd/All
56	SUCHFELDALIAS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
57	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
58	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
59	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
60	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
61	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
62	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
63	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
64	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
65	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
66	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
67	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
68	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
69	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
70	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
71	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
72	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
73	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
74	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
75	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
76	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
77	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
78	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
79	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
80	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
81	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
82	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
83	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
84	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
85	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
86	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
87	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
88	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
89	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
90	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
91	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
92	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
93	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
94	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
95	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
96	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
97	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
98	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
99	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
100	.INCLUDE	☐				0	0	IS-P: Home/Work Telephone Data
101	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
102	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
103	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
104	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
105	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
106	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
107	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
108	TECHNUMZUG	☐	TECHNUMZUG	XFELD	CHAR	1	0	IS-M: Technical Relocation Due to Postal Data Change
109	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
110	ALIASLFDNR	☐	ALIASLFDNR	NUMC10	NUMC	10	0	IS-M: Sequence Number for Alias Table (Key)	JSTALIAS
111	XNOCARPERMESS	☐	XNOCARPERMESS	XFELD	CHAR	1	0	IS-M: No Change of Carrier When Address Changes
112	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
113	ANI_TELNRP	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
114	ANI_TELNRD	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
115	ANI_ISPHANDY	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
116	HH_REF	☐	GPNR_HH	BU_PARTNER	CHAR	10	0	IS-M: Business Partner Number of Household	JGTHH
117	HH_EXCLUDE	☐	HH_EXCLUDE	XFELD	CHAR	1	0	IS-M: Indicator: Exclude Household Assignment
118	PRIVACY_STATUS	☐	ADDRESS_PRIVACY_STATUS	ADDRESS_PRIVACY_STATUS	CHAR	1	0	IS-M: Status of Address As Regards Data Protection
119	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
120	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJGADRA	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	RJGADRA	ALIASLFDNR	JSTALIAS	ALIASLFDNR	KEY	C	CN
3	RJGADRA	ANRED	TJG43	JANRED
4	RJGADRA	BEABLS_REF	JRTBEABST	BEABLST
5	RJGADRA	CITYC	T005G	CITYC
6	RJGADRA	COUNC	T005E	COUNC
7	RJGADRA	GPHERK	TJG41	GPHERK
8	RJGADRA	GP_REF	JGTGPNR	GPNR
9	RJGADRA	HH_REF	JGTHH	PARTNER
10	RJGADRA	JPARVW_REF	TJG39	JPARVW
11	RJGADRA	LAND1	T005	LAND1
12	RJGADRA	MANDT	T000	MANDT
13	RJGADRA	NAMZU	T535N	TITEL
14	RJGADRA	NIELS	TNLS	NIELS
15	RJGADRA	PEINORTPF	JSTORTPRO	ALORT
16	RJGADRA	POSNR_REF	JKAP	POSNR
17	RJGADRA	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
18	RJGADRA	POSTEINORT	JSTORTPRO	ALORT
19	RJGADRA	POSTEINSTR	JSTSTRPRO	STRASSENNR
20	RJGADRA	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
21	RJGADRA	REGIO	T005S	BLAND
22	RJGADRA	SPRAS	T002	SPRAS
23	RJGADRA	TITEL	T535N	TITEL
24	RJGADRA	TXJCD	TTXJ	TXJCD	REF	C	CN
25	RJGADRA	VBELN_REF	JKAK	VBELN
26	RJGADRA	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in