SAP ABAP Table JHVGPZADR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVGPZADR	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
2	AVM_NR	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
3	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
4	GPROLLE	☑	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
5	GPNR	☑	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
6	PARZA	☑	JPARZA	JPARZA	NUMC	3	0	IS-M: Partner Role Counter
7	GRUPPABRNR	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
8	UPOS_NR	☑	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number	JHAU
9	EIN_NR	☑	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAE
10	MOTIV	☑	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	JHAMOT
11	ADRNR	☑	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
12	LOGADR	☑	JLOGADR	JLOGADR	NUMC	4	0	IS-M: Logical Address Number
13	SADR_ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	SADR
14	ADRC_ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
15	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
16	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
17	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
18	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
19	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
20	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
21	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
22	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
23	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
24	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
25	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
26	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
27	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
28	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
29	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
30	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
31	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
32	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
33	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
34	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
35	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
36	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
37	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
38	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
39	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
40	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
41	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
42	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
43	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
44	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
45	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
46	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
47	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
48	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
49	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
50	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
51	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
52	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
53	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
54	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
55	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
56	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
57	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
58	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
59	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
60	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
61	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
62	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
63	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
64	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
65	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
66	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
67	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
68	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
69	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
70	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
71	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
72	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
73	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
74	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
75	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
76	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
77	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
78	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
79	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
80	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
81	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
82	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
83	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
84	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
85	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
86	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
87	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
88	TECHNUMZUG	☐	TECHNUMZUG	XFELD	CHAR	1	0	IS-M: Technical Relocation Due to Postal Data Change
89	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
90	ANI_TELNRP	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
91	ANI_TELNRD	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVGPZADR	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	JHVGPZADR	ADRC_ADDRNUMBER	ADRC	ADDRNUMBER	REF	1	CN
3	JHVGPZADR	ADRNR	JGTSADR	ADRNR	KEY	C	CN
4	JHVGPZADR	ANRED	TJG43	JANRED	REF	C	CN
5	JHVGPZADR	AVM_NR	JHAK	AVM_NR	KEY	1	CN
6	JHVGPZADR	BEABLS_REF	JRTBEABST	BEABLST	REF	C	CN
7	JHVGPZADR	CITYC	T005G	CITYC	REF	C	CN
8	JHVGPZADR	COUNC	T005E	COUNC	REF	C	CN
9	JHVGPZADR	EIN_NR	JHAE	EIN_NR	KEY	1	CN
10	JHVGPZADR	GPNR	JGTGPNR	GPNR	KEY	1	CN
11	JHVGPZADR	GPROLLE	TJG39	JPARVW	KEY	1	CN
12	JHVGPZADR	GRUPPABRNR	JHAGA	GRUPPABRNR	KEY	1	CN
13	JHVGPZADR	LAND1	T005	LAND1	REF	C	CN
14	JHVGPZADR	MANDT	T000	MANDT	KEY	1	CN
15	JHVGPZADR	MOTIV	JHAMOT	MOTIV		1	CN
16	JHVGPZADR	NAMZU	T535N	TITEL
17	JHVGPZADR	NIELS	TNLS	NIELS	REF	C	CN
18	JHVGPZADR	PEINORTPF	JSTORTPRO	ALORT	REF	C	CN
19	JHVGPZADR	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
20	JHVGPZADR	POSTEINORT	JSTORTPRO	ALORT	REF	C	CN
21	JHVGPZADR	POSTEINSTR	JSTSTRPRO	STRASSENNR	REF	C	CN
22	JHVGPZADR	POS_NR	JHAP	POS_NR	KEY	1	CN
23	JHVGPZADR	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
24	JHVGPZADR	REGIO	T005S	BLAND	REF	C	CN
25	JHVGPZADR	SADR_ADRNR	SADR	ADRNR	REF	1	CN
26	JHVGPZADR	SPRAS	T002	SPRAS	REF	C	CN
27	JHVGPZADR	TITEL	T535N	TITEL
28	JHVGPZADR	TXJCD	TTXJ	TXJCD	REF	C	CN
29	JHVGPZADR	UPOS_NR	JHAU	UPOS_NR	KEY	1	CN
30	JHVGPZADR	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in