SAP ABAP Table JHVGVZ03 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVGVZ03	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	BELEG_ART	☐	PAM_BELART	PAM_BELART	CHAR	4	0	IS-M: Voucher Type (Proof)	TJJB1
14	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
15	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
16	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
17	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
18	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
19	TRVOG	☐	TRVOG_PAM	TRVOG_PAM	CHAR	1	0	IS-M: Transaction Process Group - Order Processing
20	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
21	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)
22	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
23	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
24	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
25	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
26	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
27	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
28	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
29	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
30	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
31	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
32	FKARA	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document
33	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
34	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
35	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
36	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
37	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
38	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
39	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
40	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
41	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
42	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
43	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
44	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
45	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
46	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
47	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
48	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
49	MANUSERF	☐	MANUSERF	TEXT12	CHAR	12	0	IS-M: Order data entered by (entry on paper)
50	MAN_VKBUR	☐	MAN_VKBUR	VKBUR	CHAR	4	0	IS-M/AM: Sales Office of Person who Entered Booking Details	TVBUR
51	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
52	FRD_AVM_NR	☐	FRD_AVM_NR	CHAR20	CHAR	20	0	IS-M: Externally Assigned Order Number
53	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
54	NOTIZKNZ	☐	NOTIZKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Notes are Available for an OPM Objct
55	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen
56	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
57	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
58	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
59	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
60	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
61	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
62	RAB1_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
63	RAB1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
64	RAB1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
65	RAB2_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
66	RAB2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
67	RAB2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
68	RAB3_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
69	RAB3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
70	RAB3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
71	RAB4_BETR	☐	JRABMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent discount
72	RAB4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
73	RAB4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)
74	RAB4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
75	RAB4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
76	RAB5_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
77	RAB5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
78	RAB5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
79	ZUS1_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
80	ZUS1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
81	ZUS1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
82	ZUS2_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
83	ZUS2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
84	ZUS2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
85	ZUS3_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
86	ZUS3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
87	ZUS3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
88	ZUS4_BETR	☐	JZUSMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent surcharge
89	ZUS4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
90	ZUS4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)
91	ZUS4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
92	ZUS4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
93	ZUS5_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
94	ZUS5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
95	ZUS5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
96	FPRG_BETR	☐	JGPRBETR	WERTV6	CURR	11	2	IS-M/AM: Basic Price
97	FPRG_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
98	FPRG_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)
99	FPRG_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
100	FPRG_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
101	FPR1_BETR	☐	JVPRBETR	WERTV6	CURR	11	2	IS-M/AM: Agreed price
102	FPR1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
103	FPR1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
104	XRABZU	☐	XRABZU	XFELD	CHAR	1	0	IS-M: Discount/Surcharge Exists Indicator
105	WAER_IPZA	☐	WAERK	WAERS	CUKY	5	0	SD document currency
106	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
107	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
108	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
109	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
110	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
111	STATUS_P	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVGVZ03	ADRNR	JGTSADR	ADRNR	KEY	C	CN
2	JHVGVZ03	AUART	TJHAK	AUART	KEY	1	CN
3	JHVGVZ03	AVM_NR	JHAK	AVM_NR	KEY	1	CN
4	JHVGVZ03	BELEG_ART	TJJB1	BLART	REF	1	CN
5	JHVGVZ03	BRAN_PAM	TBRC	BRACO	REF	1	CN
6	JHVGVZ03	BSARK	T176	BSARK	REF	C	CN
7	JHVGVZ03	CMWAE	TCURC	WAERS	REF	C	CN
8	JHVGVZ03	CTLPC	T691A	CTLPC	REF	C	CN
9	JHVGVZ03	EIN_NR	JHAE	EIN_NR	KEY	1	CN
10	JHVGVZ03	GPAG	JGTGPNR	GPNR	KEY	1	CN
11	JHVGVZ03	GPNR	JGTGPNR	GPNR	KEY	1	CN
12	JHVGVZ03	GPROLLE	TJG39	JPARVW	KEY	1	CN
13	JHVGVZ03	GRUPP	T691B	GRUPP
14	JHVGVZ03	GRUPPABRNR	JHAGA	GRUPPABRNR	KEY	1	CN
15	JHVGVZ03	GSBER	TGSB	GSBER	REF	C	CN
16	JHVGVZ03	GSKST	TGSB	GSBER	REF	C	CN
17	JHVGVZ03	KALSM	T683	KALSM	REF	C	CN
18	JHVGVZ03	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
19	JHVGVZ03	KKBER	T014	KKBER	REF	C	CN
20	JHVGVZ03	KNKLI	KNA1	KUNNR	REF	C	CN
21	JHVGVZ03	MANDT	T000	MANDT	KEY	1	CN
22	JHVGVZ03	MAN_VKBUR	TVBUR	VKBUR	REF	1	CN
23	JHVGVZ03	MOTIV	JHAMOT	MOTIV		1	CN
24	JHVGVZ03	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
25	JHVGVZ03	POS_NR	JHAP	POS_NR	KEY	1	CN
26	JHVGVZ03	REF_AVM_NR	JHAK	AVM_NR	REF	C	CN
27	JHVGVZ03	SBGRP	T024B	SBGRP	REF	C	CN
28	JHVGVZ03	SPART	TJHVBER	SPART		1	CN
29	JHVGVZ03	STAFO	TMCB	STAFO	REF	C	CN
30	JHVGVZ03	STWAE	TCURC	WAERS	REF	C	CN
31	JHVGVZ03	UPOS_NR	JHAU	UPOS_NR	KEY	1	CN
32	JHVGVZ03	VKBUR	TVKBZ	VKBUR		C	CN
33	JHVGVZ03	VKGRP	TVBVK	VKGRP		C	CN
34	JHVGVZ03	VKORG	TJHVBER	VKORG		1	CN
35	JHVGVZ03	VTWEG	TJHVBER	VTWEG		1	CN
36	JHVGVZ03	WAEHRG	TCURC	WAERS	REF	1	CN
37	JHVGVZ03	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in