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

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	JHAPA	MANDT	JR	EQ			AND	0	0
7	JHAK	AVM_NR	JL	EQ				0	0
8	JHAPA	AVM_NR	JR	EQ			AND	0	0
9	JHAP	MANDT	JL	EQ				0	0
10	JHAPA	MANDT	JR	EQ			AND	0	0
11	JHAP	AVM_NR	JL	EQ				0	0
12	JHAPA	AVM_NR	JR	EQ			AND	0	0
13	JHAP	POS_NR	JL	EQ				0	0
14	JHAPA	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	XUVMOT	JHAPA	XUVMOT		☐	XUVMOT	☐	IS-M: "Ad spec data incomplete" indicator
36	XUVTECH_AZ	JHAPA	XUVTECH		☐	XUVTECH	☐	IS-M: Incomplete Regarding Technical System (Gen.)
37	XNOCHG_TEC	JHAPA	XNOCHG_TEC		☐	XNOCHG_TEC	☐	IS-M: Cannot be changed for technical reasons indicator
38	XTECH_EEAZ	JHAPA	XTECH_EE		☐	XTECH_EE	☐	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
39	XSPERR_TEC	JHAPA	XSPERR_TEC		☐	XSPERR_TEC	☐	IS-M: Blocked in technical system indicator
40	AZMERKMAL0	JHAPA	MERKMAL0		☐	MERK0_PA	☐	IS-M: Characteristic 0 for Individual Use (Ad Item)
41	AZMERKMAL1	JHAPA	MERKMAL1		☐	MERK1_PA	☐	IS-M: Characteristic 1 for Individual Use (Ad Item)
42	AZMERKMAL2	JHAPA	MERKMAL2		☐	MERK2_PA	☐	IS-M: Characteristic 2 for Individual Use (Ad Item)
43	AZMERKMAL3	JHAPA	MERKMAL3		☐	MERK3_PA	☐	IS-M: Characteristic 3 for Individual Use (Ad Item)
44	AZMERKMAL4	JHAPA	MERKMAL4		☐	MERK4_PA	☐	IS-M: Characteristic 4 for Individual Use (Ad Item)
45	AZMERKMAL5	JHAPA	MERKMAL5		☐	MERK5_PA	☐	IS-M: Characteristic 5 for Individual Use (Ad Item)
46	AZMERKMAL6	JHAPA	MERKMAL6		☐	MERK6_PA	☐	IS-M: Characteristic 6 for Individual Use (Ad Item)
47	AZMERKMAL7	JHAPA	MERKMAL7		☐	MERK7_PA	☐	IS-M: Characteristic 7 for Individual Use (Ad Item)
48	AZMERKMAL8	JHAPA	MERKMAL8		☐	MERK8_PA	☐	IS-M: Characteristic 8 for Individual Use (Ad Item)
49	AZMERKMAL9	JHAPA	MERKMAL9		☐	MERK9_PA	☐	IS-M: Characteristic 9 for Individual Use (Ad Item)
50	XTECH_MINAZ	JHAPA	XTECH_MIN1		☐	XTECH_MIN1	☐	IS-M: Tech.process.started (for at least 1 schedule line)

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