SAP ABAP Table JGVADDRES3 (IS-PSD: View for Bus.Partner Addresses (replaces JGVADDRES1))

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	JGVADDRES3	Table Relationship Diagram
Short Description	IS-PSD: View for Bus.Partner Addresses (replaces JGVADDRES1)

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
3	LOGADR	☐	JLOGADR	JLOGADR	NUMC	4	0	IS-M: Logical Address Number
4	ADRZA	☐	JADRZA	JADRTA	NUMC	4	0	IS-M: Time Slice Counter in Logical Address
5	JPARVW	☐	JPARVW2	JPARVW	CHAR	2	0	IS-M: Business Partner Roles	*
6	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
7	WDAT1	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
8	WDAT2	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
9	VADRNR	☐	JVADRNR	JADRNR	CHAR	10	0	IS-M: Address Number of Previous Address (Relocation)	*
10	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
11	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
12	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
13	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
14	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
15	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
16	XKAHS	☐	XKAHS	XFELD	CHAR	1	0	IS-M: Customer Pickup Point Indicator
17	SD_UPDA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
18	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
19	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
20	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
21	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
22	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
23	ERFUSER_AD	☐	ERFUSER	USNAM	CHAR	12	0	Created By
24	ERFDATE_AD	☐	ERFDATE	DATUM	DATS	8	0	Created On
25	ERFTIME_AD	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
26	AENUSER_AD	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
27	AENDATE_AD	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
28	AENTIME_AD	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
29	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	*
30	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
31	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
32	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
33	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
34	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	*
35	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	*
36	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	*
37	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
38	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
39	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
40	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
41	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
42	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
43	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
44	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
45	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
46	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
47	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
48	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
49	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
50	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
51	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	*
52	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	*
53	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
54	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
55	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
56	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
57	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
58	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
59	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
60	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
61	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
62	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
63	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
64	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
65	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
66	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
67	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
68	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
69	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
70	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
71	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
72	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
73	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
74	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
75	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
76	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
77	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
78	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
79	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
80	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	*
81	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
82	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
83	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
84	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	*
85	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	*
86	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
87	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
88	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
89	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
90	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
91	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
92	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
93	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
94	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
95	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
96	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
97	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address

History

Last changed by/on	SAP	20130529
SAP Release Created in