SAP ABAP Table JHVSTAT11 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVSTAT11	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	UPOS_NR	☑	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number
6	EIN_NR	☑	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line
7	MOTIV	☐	OLMOTIV_NR	MAM_OL_MOT	NUMC	6	0	IS-M: Order ad spec number (online)	JHAMOTO
8	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
12	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
13	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
14	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
15	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
16	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
17	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
18	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
19	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
20	EIN_ART	☐	JHAE_ART	AVMPOS_ART	CHAR	2	0	IS-M: Schedule Line Type
21	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
22	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
23	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
24	INHK_EINT	☐	INHK_EINT	INHALTSKOM	CHAR	8	0	IS-M: Schedule line content component	JJTIKO
25	INHK_PLAZ	☐	INHK_PLAZ	INHALTSKOM	CHAR	8	0	IS-M: Positioning content component	JJTIKO
26	INHK_PLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	JJTIKO
27	S_TERMIN	☐	S_TERMIN	DATUM	DATS	8	0	IS-M: Planned Publication Date
28	IST_KONTAKTZAHL	☐	ISM_IST_KONTAKTZAHL	ISM_IST_KONTAKTZAHL	QUAN	17	3	Actual Gross Impressions for Online Advertising
29	UNIT_OL	☐	ISM_UNIT_OL	ISM_UNIT_OL	UNIT	3	0	IS-M/AM: Unit of Measure for Online Advertising
30	XERSCH	☐	XERSCH	XFELD	CHAR	1	0	IS-M: Schedule Line Published Indicator
31	MERKMAL0	☐	MERK0_EO	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Online Schd.Line)
32	MERKMAL1	☐	MERK1_EO	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Online Schd.Line)
33	MERKMAL2	☐	MERK2_EO	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Online Schd.Line)
34	MERKMAL3	☐	MERK3_EO	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Online Schd.Line)
35	MERKMAL4	☐	MERK4_EO	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Online Schd.Line)
36	MERKMAL5	☐	MERK5_EO	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Online Schd.Line)
37	MERKMAL6	☐	MERK6_EO	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Online Schd.Line)
38	MERKMAL7	☐	MERK7_EO	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Online Schd.Line)
39	MERKMAL8	☐	MERK8_EO	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Online Schd.Line)
40	MERKMAL9	☐	MERK9_EO	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Online Schd.Line)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVSTAT11	AUART	TJHAK	AUART	KEY	1	CN
2	JHVSTAT11	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVSTAT11	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
4	JHVSTAT11	GPAG	JGTGPNR	GPNR	KEY	1	CN
5	JHVSTAT11	INHK_EINT	JJTIKO	INHALTSKOM	KEY	1	CN
6	JHVSTAT11	INHK_PLAZ	JJTIKO	INHALTSKOM	REF	1	CN
7	JHVSTAT11	INHK_PLEV1	JJTIKO	INHALTSKOM	REF	1	CN
8	JHVSTAT11	MANDT	T000	MANDT	KEY	1	CN
9	JHVSTAT11	MOTIV	JHAMOTO	MOTIV	KEY	1	CN
10	JHVSTAT11	POS_NR	JHAP	POS_NR	KEY	1	CN
11	JHVSTAT11	PSTYV	TJHAP	PSTYV	REF	1	CN
12	JHVSTAT11	SPART	TJHVBER	SPART		1	CN
13	JHVSTAT11	STORNOGRND	TJHSTOG	STORNOGRD	KEY	1	CN
14	JHVSTAT11	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
15	JHVSTAT11	VKBUR	TVKBZ	VKBUR		C	CN
16	JHVSTAT11	VKGRP	TVBVK	VKGRP		C	CN
17	JHVSTAT11	VKORG	TJHVBER	VKORG		1	CN
18	JHVSTAT11	VTWEG	TJHVBER	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in