SAP ABAP View JHVSTAT12 (IS-M/AM: View for Online Items 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	JHVSTAT12
Short Description	IS-M/AM: View for Online Items 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	JHAPO

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	JHAPO	MANDT	JR	EQ			AND	0	0
3	JHAK	AVM_NR	JL	EQ				0	0
4	JHAPO	AVM_NR	JR	EQ			AND	0	0
5	JHAP	MANDT	JL	EQ				0	0
6	JHAPO	MANDT	JR	EQ			AND	0	0
7	JHAP	AVM_NR	JL	EQ				0	0
8	JHAPO	AVM_NR	JR	EQ			AND	0	0
9	JHAP	POS_NR	JL	EQ				0	0
10	JHAPO	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	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	ONLPOS_START	JHAPO	ONLPOS_START		☐	ONLPOS_START	☐	IS-M/AM: Start Date for Online Ad
36	ONLPOS_ENDE	JHAPO	ONLPOS_ENDE		☐	ONLPOS_ENDE	☐	IS-M/AM: End Date for Online Ad
37	XTECH_M_O	JHAPO	XTECH_MIN1		☐	XTECH_MIN1	☐	IS-M: Tech.process.started (for at least 1 schedule line)
38	XTECH_EE_O	JHAPO	XTECH_EE		☐	XTECH_EE	☐	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
39	MERKMAL0	JHAPO	MERKMAL0		☐	MERK0_PO	☐	IS-M: Characteristic 0 for Individual Use (Online Item)
40	MERKMAL1	JHAPO	MERKMAL1		☐	MERK1_PO	☐	IS-M: Characteristic 1 for Individual Use (Online Item)
41	MERKMAL2	JHAPO	MERKMAL2		☐	MERK2_PO	☐	IS-M: Characteristic 2 for Individual Use (Online Item)
42	MERKMAL3	JHAPO	MERKMAL3		☐	MERK3_PO	☐	IS-M: Characteristic 3 for Individual Use (Online Item)
43	MERKMAL4	JHAPO	MERKMAL4		☐	MERK4_PO	☐	IS-M: Characteristic 4 for Individual Use (Online Item)
44	MERKMAL5	JHAPO	MERKMAL5		☐	MERK5_PO	☐	IS-M: Characteristic 5 for Individual Use (Online Item)
45	MERKMAL6	JHAPO	MERKMAL6		☐	MERK6_PO	☐	IS-M: Characteristic 6 for Individual Use (Online Item)
46	MERKMAL7	JHAPO	MERKMAL7		☐	MERK7_PO	☐	IS-M: Characteristic 7 for Individual Use (Online Item)
47	MERKMAL8	JHAPO	MERKMAL8		☐	MERK8_PO	☐	IS-M: Characteristic 8 for Individual Use (Online Item)
48	MERKMAL9	JHAPO	MERKMAL9		☐	MERK9_PO	☐	IS-M: Characteristic 9 for Individual Use (Online Item)

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	20131127
SAP Release Created in