SAP ABAP View JHVSTAT04 (IS-M/AM: View for Billing Dataset Status Selection)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JHVSTAT04
Short Description	IS-M/AM: View for Billing Dataset Status Selection
Root table	JHAK	IS-M/AM: Order-Publishing-Media (Header Data)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAK	JHAK
2	JHAP
3	JHAGA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAK	MANDT	JL	EQ				0	0
2	JHAGA	MANDT	JR	EQ			AND	0	0
3	JHAK	AVM_NR	JL	EQ				0	0
4	JHAGA	AVM_NR	JR	EQ			AND	0	0
5	JHAP	MANDT	JL	EQ				0	0
6	JHAGA	MANDT	JR	EQ			AND	0	0
7	JHAP	AVM_NR	JL	EQ				0	0
8	JHAGA	AVM_NR	JR	EQ			AND	0	0
9	JHAP	POS_NR	JL	EQ				0	0
10	JHAGA	POS_NR	JR	EQ			AND	0	0
11	JHAK	MANDT	JL	EQ				0	0
12	JHAP	MANDT	JR	EQ			AND	0	0
13	JHAK	AVM_NR	JL	EQ				0	0
14	JHAP	AVM_NR	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in