SAP ABAP Table JHVAPA1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVAPA1	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	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
7	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
8	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
9	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
10	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
11	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
12	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
13	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
14	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
15	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
16	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
17	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
18	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
19	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
20	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
21	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
22	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
23	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
24	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
25	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
26	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
27	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
28	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
29	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
30	TERMINART	☐	TERMINART	TERMINART	CHAR	1	0	IS-M/AM: Type of Publication Date
31	WUNSCH_T	☐	WUNSCH_T	DATUM	DATS	8	0	IS-M/AM: Date Required
32	INHK_TECH1	☐	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	JJTIKO
33	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
34	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
35	TEC_AVM_NR	☐	TEC_AVM_NR	CHAR10	CHAR	10	0	IS-M: Order number in technical system
36	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
37	CHIFFRE_NR	☐	CHIFFRE	CHIFFRE_NR	CHAR	10	0	IS-M/AM: Box Number
38	AZART_PLAZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	TJJ15
39	PLAZIERUNG	☐	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	TJJ65
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	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in