SAP ABAP Table JHVAPV1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVAPV1	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
4	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
5	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
8	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
9	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
10	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
11	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
12	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
13	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
14	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
15	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
16	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
17	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
18	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
19	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
20	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
21	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
22	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
23	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
24	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
25	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
26	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
27	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
28	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
29	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
30	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
31	JVTBEPMART	☐	JVTBEPMART	JVTBEPMART	CHAR	4	0	IS-M/AM: Distribution Planned Quantity Types	TJJBEVTPA
32	VRTMENGE_V	☐	VRTMGV_PAM	STMENGE	DEC	9	0	IS-M/AM: Planned Quantity for Distribution Full Booking
33	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
34	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
35	MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	T006
36	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
37	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
38	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
39	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
40	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
41	ENDE_PER	☐	ENDE_PER	PAM_PERIOD	CHAR	14	0	IS-M: End of Period - Issue/Publication Date
42	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
43	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
44	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
45	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
46	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
47	XBERMENGE_FIX	☐	JXBERMENGE_FIX	XFELD	CHAR	1	0	IS-M/AM: Calculation Quantity is Fixed indicator
48	BLGMENGE	☐	JVTLFMNG	STMENGE	DEC	9	0	IS-M/AM: Delivery quantity for distribution
49	XTBEL_VT	☐	XTBEL_VT	XFELD	CHAR	1	0	IS-M: Selective Booking For Distribution BU Indicator
50	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type
51	SI_GEWICHT	☐	ISM_SI_GEWICHT	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVAPV1	AUART	TJHAK	AUART	KEY	1	CN
2	JHVAPV1	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVAPV1	BRAN_PAM	TBRC	BRACO	REF	1	CN
4	JHVAPV1	GPAG	JGTGPNR	GPNR	KEY	1	CN
5	JHVAPV1	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
6	JHVAPV1	JVTBEPMART	TJJBEVTPA	JVTBEPMART
7	JHVAPV1	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
8	JHVAPV1	KONKAUS	TJH89	KONKAUS	KEY	1	CN
9	JHVAPV1	MANDT	T000	MANDT	KEY	1	CN
10	JHVAPV1	MEINHGEWBL	T006	MSEHI
11	JHVAPV1	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
12	JHVAPV1	PRODH	JJT179	PRODH	REF	1	CN
13	JHVAPV1	PSTYV	TJHAP	PSTYV	REF	1	CN
14	JHVAPV1	SPART	TJHVBER	SPART		1	CN
15	JHVAPV1	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
16	JHVAPV1	TERM_TYP	TJH55	TERM_TYP	REF	1	CN
17	JHVAPV1	VKBUR	TVKBZ	VKBUR		C	CN
18	JHVAPV1	VKGRP	TVBVK	VKGRP		C	CN
19	JHVAPV1	VKORG	TJHVBER	VKORG		1	CN
20	JHVAPV1	VTWEG	TJHVBER	VTWEG		1	CN
21	JHVAPV1	WAEHRG	TCURC	WAERS	REF	1	CN
22	JHVAPV1	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in