SAP ABAP Table JHVSTAT04 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVSTAT04	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	GRUPPABRNR	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset
6	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
9	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
10	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
11	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
12	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
13	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
14	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
15	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
16	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
17	PSTYV_P	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
18	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JHAISZ
19	GF_STATUS	☐	GF_STATUS	PAM_STATUS	CHAR	2	0	IS-M: Billing Dataset Status
20	PSTYV_G	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
21	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
22	FAKSPP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
23	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
24	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
25	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
26	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
27	XPROVMIN1	☐	XPROVMIN1	XFELD	CHAR	1	0	Partial Commission (At Least 1 Sales Agent Assignment Comm.)
28	XPROVALL	☐	XPROVALL	XFELD	CHAR	1	0	Commission Calculated For All Sales Agent Assignments Ind.
29	XABS_EE	☐	XABS_EE	XFELD	CHAR	1	0	IS-M: Contract Final Settlement Performed
30	XPREIS_EE	☐	XPREIS_EE	XFELD	CHAR	1	0	IS-M: Pricing completed
31	XCCAUTNOTW	☐	XCCAUTNOTW	XFELD	CHAR	1	0	IS-M/AM: Payment card authorization required
32	XCMP_FAILED	☐	XCMP_FAILED	XFELD	CHAR	1	0	IS-M/AM: Credit check failed
33	MERKMAL0	☐	MERK0_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
34	MERKMAL1	☐	MERK1_GA	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Billing Dataset)
35	MERKMAL2	☐	MERK2_GA	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Billing Dataset)
36	MERKMAL3	☐	MERK3_GA	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Billing Dataset)
37	MERKMAL4	☐	MERK4_GA	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Billing Dataset)
38	MERKMAL5	☐	MERK5_GA	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Billing Dataset)
39	MERKMAL6	☐	MERK6_GA	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Billing Dataset)
40	MERKMAL7	☐	MERK7_GA	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Billing Dataset)
41	MERKMAL8	☐	MERK8_GA	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Billing Dataset)
42	MERKMAL9	☐	MERK9_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
43	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
44	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
45	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
46	ABSCHL_NR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
47	ABSCHL_POS	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
48	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
49	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
50	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
51	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing
52	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
53	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
54	XMANUELL	☐	XMANUELL1	XFELD	CHAR	1	0	IS-M: Contract Assignments Changed Manually Indicator
55	XRABZU	☐	XRABZU	XFELD	CHAR	1	0	IS-M: Discount/Surcharge Exists Indicator
56	VORAUSKNZ	☐	VORAUSKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Advance Billing Required
57	XKFMAEND	☐	XKFMAEND	XFELD	CHAR	1	0	IS-M: Business Data was Changed Manually Indicator
58	XAB_AUS	☐	XAB_AUS	XFELD	CHAR	1	0	IS-M: Contract Exclusion Requirement Applies Yes/No
59	XPREISAEND	☐	XPREISAEND	XFELD	CHAR	1	0	IS-M: Price Was Changed Indicator
60	XUVVZ	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
61	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVSTAT04	ABSCHL_NR	JHTVABRUF	VTNR	REF	C	CN
2	JHVSTAT04	ABSCHL_POS	JHTVABRUF	POSNR	REF	C	CN
3	JHVSTAT04	AUART	TJHAK	AUART	KEY	1	CN
4	JHVSTAT04	AVM_NR	JHAK	AVM_NR	KEY	1	CN
5	JHVSTAT04	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
6	JHVSTAT04	FAKSPP	TVFS	FAKSP
7	JHVSTAT04	GPAG	JGTGPNR	GPNR	KEY	1	CN
8	JHVSTAT04	INSERENT	JHAISZ	INSERENT	KEY	1	CN
9	JHVSTAT04	KONDA	T188	KONDA
10	JHVSTAT04	MANDT	T000	MANDT	KEY	1	CN
11	JHVSTAT04	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
12	JHVSTAT04	POS_NR	JHAP	POS_NR	KEY	1	CN
13	JHVSTAT04	PSTYV_G	TJHAP	PSTYV	KEY	1	CN
14	JHVSTAT04	PSTYV_P	TJHAP	PSTYV	REF	1	CN
15	JHVSTAT04	SPART	TJHVBER	SPART		1	CN
16	JHVSTAT04	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
17	JHVSTAT04	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
18	JHVSTAT04	VKBUR	TVKBZ	VKBUR		C	CN
19	JHVSTAT04	VKGRP	TVBVK	VKGRP		C	CN
20	JHVSTAT04	VKORG	TJHVBER	VKORG		1	CN
21	JHVSTAT04	VTWEG	TJHVBER	VTWEG		1	CN
22	JHVSTAT04	WAEHRG	TCURC	WAERS	REF	1	CN
23	JHVSTAT04	WAERG	TCURC	WAERS		1	CN
24	JHVSTAT04	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in