SAP ABAP View JHVSTAT02 (IS-M/AM: View for Ad Insert 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	JHVSTAT02
Short Description	IS-M/AM: View for Ad Insert 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	JHAPS

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	JHAP	MANDT	JR	EQ			AND	0	0
3	JHAK	AVM_NR	JL	EQ				0	0
4	JHAP	AVM_NR	JR	EQ			AND	0	0
5	JHAK	MANDT	JL	EQ				0	0
6	JHAPS	MANDT	JR	EQ			AND	0	0
7	JHAK	AVM_NR	JL	EQ				0	0
8	JHAPS	AVM_NR	JR	EQ			AND	0	0
9	JHAP	MANDT	JL	EQ				0	0
10	JHAPS	MANDT	JR	EQ			AND	0	0
11	JHAP	AVM_NR	JL	EQ				0	0
12	JHAPS	AVM_NR	JR	EQ			AND	0	0
13	JHAP	POS_NR	JL	EQ				0	0
14	JHAPS	POS_NR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAP	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAP	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAP	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
5	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
6	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
7	SPART	JHAK	SPART		☐	SPART	☐	Division
8	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
9	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
10	AUART	JHAK	AUART		☐	AUART_PAM	☐	IS-M: Sales Document Type
11	AVM_HRKNFT	JHAK	AVM_HRKNFT		☐	AVM_HRKNFT	☐	IS-M/AM: Order Origin
12	POS_ART	JHAP	POS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
13	PSTYV	JHAP	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
14	WERBK_TYP	JHAP	WERBK_TYP		☐	WKOMBI_TYP	☐	IS-M: Combination Sale Type
15	XAGENAUFTR	JHAP	XAGENAUFTR		☐	XAGENAUFTR	☐	IS-M: Agency order indicator
16	STATUSK	JHAP	STATUSK		☐	STATUSK	☐	IS-M: Status
17	XUVFAKT	JHAP	XUVFAKT		☐	XUVFAKT	☐	IS-M: Billing is Incomplete
18	XUVGP	JHAP	XUVGP		☐	XUVGP	☐	IS-M: Business Partner Is Incomplete
19	XUVPREIS	JHAP	XUVPREIS		☐	XUVPREIS	☐	IS-M: Incomplete with regard to pricing
20	XUVABSCHL	JHAP	XUVABSCHL		☐	XUVABSCHL	☐	IS-M: Contract Assignment is Incomplete
21	XUVVZ	JHAP	XUVVZ		☐	XUVVZ	☐	IS-M: Sales Agent Assignment Incomplete
22	XUVKPV	JHAP	XUVKPV		☐	XUVKPV	☐	IS-M: Incomplete Manual Header/Item Sales Agent Assignment
23	XGENEINT	JHAP	XGENEINT		☐	XGENEINT	☐	IS-M: Schedule lines are not current
24	XGENGRPF	JHAP	XGENGRPF		☐	XGENGRPF	☐	IS-M: Billing Dataset Is Yet To Be Generated
25	XRESERV	JHAP	XRESERV		☐	XRESERV	☐	IS-M: Reservation indicator
26	XRESBEST	JHAP	XRESBEST		☐	XRESBEST	☐	IS-M: Reservation confirmed
27	XFAKTMIN1	JHAP	XFAKTMIN1		☐	XFAKTMIN1	☐	IS-M: Partially Billed (At Least 1 Billing Dataset Billed)
28	XFAKTALL	JHAP	XFAKTALL		☐	XFAKTALL	☐	IS-M: Billing Performed For All Billing Datasets
29	XSPERR_BON	JHAP	XSPERR_BON		☐	XSPERR_BON	☐	IS-M: "Blocked for reasons of creditworthiness" indicator
30	XKOMMFRGB	JHAP	XKOMMFRGB		☐	XKOMMFRGB	☐	IS-M: Commercial release necessary but not performed
31	XNACHBEARB	JHAP	XNACHBEARB		☐	XNACHBEARB	☐	IS-M: Post-Editing Required
32	XSTORNIERT	JHAP	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
33	SELDAT_VON	JHAP	SELDAT_VON		☐	SELDAT_VON	☐	IS-M: Start Date for Item
34	SELDAT_BIS	JHAP	SELDAT_BIS		☐	SELDAT_BIS	☐	IS-M: End Date for Items
35	ANFANG_PER	JHAPS	ANFANG_PER		☐	ANFANG_PER	☐	IS-M: Start of Copy/Publication Date Period
36	ENDE_PER	JHAPS	ENDE_PER		☐	ENDE_PER	☐	IS-M: End of Period - Issue/Publication Date
37	XUVSI	JHAPS	XUVSI		☐	XUVSI	☐	IS-M: Ad Insert Data Incomplete Indicator
38	XUVTECH_SI	JHAPS	XUVTECH		☐	XUVTECH	☐	IS-M: Incomplete Regarding Technical System (Gen.)
39	XDISPOSITI	JHAPS	XDISPOSITI		☐	XDISPOSITI	☐	IS-M: Planning Has Taken Place Indicator
40	XSI_PLAZ	JHAPS	XSI_PLAZ		☐	XSI_PLAZ	☐	IS-M: Ad insert "positioned" indicator
41	XSI_WARTET	JHAPS	XSI_WARTET		☐	XSI_WARTET	☐	IS-M: Ad Insert Is On The Waiting List Indicator
42	XMUSTER_OK	JHAPS	XMUSTER_OK		☐	XMUSTER_OK	☐	IS-M: Sample Received and Checked Indicator
43	XSI_VORH	JHAPS	XSI_VORH		☐	XSI_VORH	☐	IS-M: AI Copies Exist
44	XUVTECH	JHAPS	XUVTECH		☐	XUVTECH	☐	IS-M: Incomplete Regarding Technical System (Gen.)
45	XTECH_MINSI	JHAPS	XTECH_MIN1		☐	XTECH_MIN1	☐	IS-M: Tech.process.started (for at least 1 schedule line)
46	XTECH_EESI	JHAPS	XTECH_EE		☐	XTECH_EE	☐	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
47	SIMERKMAL0	JHAPS	MERKMAL0		☐	MERK0_PS	☐	IS-M: Characteristic 0 for Individual Use (Ad Insert Item)
48	SIMERKMAL1	JHAPS	MERKMAL1		☐	MERK1_PS	☐	IS-M: Characteristic 1 for Individual Use (Ad Insert Item)
49	SIMERKMAL2	JHAPS	MERKMAL2		☐	MERK2_PS	☐	IS-M: Characteristic 2 for Individual Use (Ad Insert Item)
50	SIMERKMAL3	JHAPS	MERKMAL3		☐	MERK3_PS	☐	IS-M: Characteristic 3 for Individual Use (Ad Insert Item)
51	SIMERKMAL4	JHAPS	MERKMAL4		☐	MERK4_PS	☐	IS-M: Characteristic 4 for Individual Use (Ad Insert Item)
52	SIMERKMAL5	JHAPS	MERKMAL5		☐	MERK5_PS	☐	IS-M: Characteristic 5 for Individual Use (Ad Insert Item)
53	SIMERKMAL6	JHAPS	MERKMAL6		☐	MERK6_PS	☐	IS-M: Characteristic 6 for Individual Use (Ad Insert Item)
54	SIMERKMAL7	JHAPS	MERKMAL7		☐	MERK7_PS	☐	IS-M: Characteristic 7 for Individual Use (Ad Insert Item)
55	SIMERKMAL8	JHAPS	MERKMAL8		☐	MERK8_PS	☐	IS-M: Characteristic 8 for Individual Use (Ad Insert Item)
56	SIMERKMAL9	JHAPS	MERKMAL9		☐	MERK9_PS	☐	IS-M: Characteristic 9 for Individual Use (Ad Insert Item)
57	XRESTHSHLT	JHAPS	XRESTHSHLT		☐	XRESTHSHLT	☐	IS-M: Total Market Coverage
58	RESTHSHLT_DATUM	JHAPS	RESTHSHLT_DATUM		☐	ISM_DELTA_COVERAGE_DATE	☐	IS-M: Alternative Date for Total Market Coverage

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