SAP ABAP Table RJMG072 (IS-P: Address Management Work Structure - Unique)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	RJMG072	Table Relationship Diagram
Short Description	IS-P: Address Management Work Structure - Unique

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in