SAP ABAP Table JHVGPZ05 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVGPZ05	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	AVM_HRKNFT	☑	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
4	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
5	GPROLLE	☑	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
6	GPNR	☑	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
7	PARZA	☑	JPARZA	JPARZA	NUMC	3	0	IS-M: Partner Role Counter
8	GRUPPABRNR	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
9	UPOS_NR	☑	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number	JHAU
10	EIN_NR	☑	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAE
11	MOTIV	☑	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	JHAMOT
12	ADRNR	☑	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
13	LOGADR	☑	JLOGADR	JLOGADR	NUMC	4	0	IS-M: Logical Address Number
14	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
15	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
16	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
17	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
18	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
19	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
20	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
21	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
22	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
23	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
24	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
25	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
26	VERMITT_K	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen
27	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen
28	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
29	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
30	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
31	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
32	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
33	BELEG_ART	☐	PAM_BELART	PAM_BELART	CHAR	4	0	IS-M: Voucher Type (Proof)	TJJB1
34	BELEG_ANZ	☐	PAM_BELANZ	NUMC5	NUMC	5	0	IS-M: Number of Voucher Copies

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVGPZ05	ADRNR	JGTSADR	ADRNR	KEY	C	CN
2	JHVGPZ05	AUART	TJHAK	AUART	KEY	1	CN
3	JHVGPZ05	AVM_NR	JHAK	AVM_NR	KEY	1	CN
4	JHVGPZ05	BELEG_ART	TJJB1	BLART	REF	1	CN
5	JHVGPZ05	BRAN_PAM	TBRC	BRACO	REF	1	CN
6	JHVGPZ05	EIN_NR	JHAE	EIN_NR	KEY	1	CN
7	JHVGPZ05	GPAG	JGTGPNR	GPNR	KEY	1	CN
8	JHVGPZ05	GPNR	JGTGPNR	GPNR	KEY	1	CN
9	JHVGPZ05	GPROLLE	TJG39	JPARVW	KEY	1	CN
10	JHVGPZ05	GRUPPABRNR	JHAGA	GRUPPABRNR	KEY	1	CN
11	JHVGPZ05	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
12	JHVGPZ05	MANDT	T000	MANDT	KEY	1	CN
13	JHVGPZ05	MOTIV	JHAMOT	MOTIV		1	CN
14	JHVGPZ05	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
15	JHVGPZ05	POS_NR	JHAP	POS_NR	KEY	1	CN
16	JHVGPZ05	PRODH	JJT179	PRODH	REF	1	CN
17	JHVGPZ05	PSTYV	TJHAP	PSTYV	REF	1	CN
18	JHVGPZ05	SPART	TJHVBER	SPART		1	CN
19	JHVGPZ05	UPOS_NR	JHAU	UPOS_NR	KEY	1	CN
20	JHVGPZ05	VKBUR	TVKBZ	VKBUR		C	CN
21	JHVGPZ05	VKGRP	TVBVK	VKGRP		C	CN
22	JHVGPZ05	VKORG	TJHVBER	VKORG		1	CN
23	JHVGPZ05	VTWEG	TJHVBER	VTWEG		1	CN
24	JHVGPZ05	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in