SAP ABAP Table JHVSTAT02 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVSTAT02	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	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
11	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
12	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
13	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
14	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
15	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
16	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
17	XUVFAKT	☐	XUVFAKT	XFELD	CHAR	1	0	IS-M: Billing is Incomplete
18	XUVGP	☐	XUVGP	XFELD	CHAR	1	0	IS-M: Business Partner Is Incomplete
19	XUVPREIS	☐	XUVPREIS	XFELD	CHAR	1	0	IS-M: Incomplete with regard to pricing
20	XUVABSCHL	☐	XUVABSCHL	XFELD	CHAR	1	0	IS-M: Contract Assignment is Incomplete
21	XUVVZ	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
22	XUVKPV	☐	XUVKPV	XFELD	CHAR	1	0	IS-M: Incomplete Manual Header/Item Sales Agent Assignment
23	XGENEINT	☐	XGENEINT	XFELD	CHAR	1	0	IS-M: Schedule lines are not current
24	XGENGRPF	☐	XGENGRPF	XFELD	CHAR	1	0	IS-M: Billing Dataset Is Yet To Be Generated
25	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
26	XRESBEST	☐	XRESBEST	XFELD	CHAR	1	0	IS-M: Reservation confirmed
27	XFAKTMIN1	☐	XFAKTMIN1	XFELD	CHAR	1	0	IS-M: Partially Billed (At Least 1 Billing Dataset Billed)
28	XFAKTALL	☐	XFAKTALL	XFELD	CHAR	1	0	IS-M: Billing Performed For All Billing Datasets
29	XSPERR_BON	☐	XSPERR_BON	XFELD	CHAR	1	0	IS-M: "Blocked for reasons of creditworthiness" indicator
30	XKOMMFRGB	☐	XKOMMFRGB	XFELD	CHAR	1	0	IS-M: Commercial release necessary but not performed
31	XNACHBEARB	☐	XNACHBEARB	XFELD	CHAR	1	0	IS-M: Post-Editing Required
32	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
33	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
34	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
35	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
36	ENDE_PER	☐	ENDE_PER	PAM_PERIOD	CHAR	14	0	IS-M: End of Period - Issue/Publication Date
37	XUVSI	☐	XUVSI	XFELD	CHAR	1	0	IS-M: Ad Insert Data Incomplete Indicator
38	XUVTECH_SI	☐	XUVTECH	XFELD	CHAR	1	0	IS-M: Incomplete Regarding Technical System (Gen.)
39	XDISPOSITI	☐	XDISPOSITI	XFELD	CHAR	1	0	IS-M: Planning Has Taken Place Indicator
40	XSI_PLAZ	☐	XSI_PLAZ	XFELD	CHAR	1	0	IS-M: Ad insert "positioned" indicator
41	XSI_WARTET	☐	XSI_WARTET	XFELD	CHAR	1	0	IS-M: Ad Insert Is On The Waiting List Indicator
42	XMUSTER_OK	☐	XMUSTER_OK	XFELD	CHAR	1	0	IS-M: Sample Received and Checked Indicator
43	XSI_VORH	☐	XSI_VORH	XFELD	CHAR	1	0	IS-M: AI Copies Exist
44	XUVTECH	☐	XUVTECH	XFELD	CHAR	1	0	IS-M: Incomplete Regarding Technical System (Gen.)
45	XTECH_MINSI	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
46	XTECH_EESI	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
47	SIMERKMAL0	☐	MERK0_PS	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Ad Insert Item)
48	SIMERKMAL1	☐	MERK1_PS	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Ad Insert Item)
49	SIMERKMAL2	☐	MERK2_PS	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Ad Insert Item)
50	SIMERKMAL3	☐	MERK3_PS	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Ad Insert Item)
51	SIMERKMAL4	☐	MERK4_PS	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Ad Insert Item)
52	SIMERKMAL5	☐	MERK5_PS	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Ad Insert Item)
53	SIMERKMAL6	☐	MERK6_PS	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Ad Insert Item)
54	SIMERKMAL7	☐	MERK7_PS	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Ad Insert Item)
55	SIMERKMAL8	☐	MERK8_PS	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Ad Insert Item)
56	SIMERKMAL9	☐	MERK9_PS	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Ad Insert Item)
57	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
58	RESTHSHLT_DATUM	☐	ISM_DELTA_COVERAGE_DATE	DATUM	DATS	8	0	IS-M: Alternative Date for Total Market Coverage

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVSTAT02	AUART	TJHAK	AUART	KEY	1	CN
2	JHVSTAT02	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVSTAT02	GPAG	JGTGPNR	GPNR	KEY	1	CN
4	JHVSTAT02	MANDT	T000	MANDT	KEY	1	CN
5	JHVSTAT02	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
6	JHVSTAT02	PSTYV	TJHAP	PSTYV	REF	1	CN
7	JHVSTAT02	SPART	TJHVBER	SPART		1	CN
8	JHVSTAT02	VKBUR	TVKBZ	VKBUR		C	CN
9	JHVSTAT02	VKGRP	TVBVK	VKGRP		C	CN
10	JHVSTAT02	VKORG	TJHVBER	VKORG		1	CN
11	JHVSTAT02	VTWEG	TJHVBER	VTWEG		1	CN
12	JHVSTAT02	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in