SAP ABAP View JHVSI_PLZ (IS-M/AM: Ad Insert Read AI Sub-Items)

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	JHVSI_PLZ
Short Description	IS-M/AM: Ad Insert Read AI Sub-Items
Root table	JHAPS	IS-M/AM: OPM Ad Insert Item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAPS	JHAPS
2	JHAUSI
3	JHAP
4	JHAK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAUSI	MANDT	JL	EQ				0	0
2	JHAPS	MANDT	JR	EQ			AND	0	0
3	JHAUSI	AVM_NR	JL	EQ				0	0
4	JHAPS	AVM_NR	JR	EQ			AND	0	0
5	JHAUSI	POS_NR	JL	EQ				0	0
6	JHAPS	POS_NR	JR	EQ			AND	0	0
7	JHAP	MANDT	JL	EQ				0	0
8	JHAPS	MANDT	JR	EQ			AND	0	0
9	JHAP	AVM_NR	JL	EQ				0	0
10	JHAPS	AVM_NR	JR	EQ			AND	0	0
11	JHAP	POS_NR	JL	EQ				0	0
12	JHAPS	POS_NR	JR	EQ			AND	0	0
13	JHAK	MANDT	JL	EQ				0	0
14	JHAPS	MANDT	JR	EQ			AND	0	0
15	JHAK	AVM_NR	JL	EQ				0	0
16	JHAPS	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	SELDAT_VON	JHAP	SELDAT_VON		☐	SELDAT_VON	☐	IS-M: Start Date for Item
3	BELEGEINH	JHAUSI	PLAZ_BE		☐	ISM_SI_PLAZBE	☐	IS-M: AI Booking Unit for Positioning
4	AVM_NR	JHAUSI	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
5	POS_NR	JHAUSI	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
6	UPOS_NR	JHAUSI	UPOS_NR		☐	UPOS_NR	☐	IS-M: Order Sub-Item Number
7	BEARB	JHAPS	BEARB		☐	SINSBEARB	☐	IS-M: Ad Insert Processing Type
8	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
9	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
10	SPART	JHAK	SPART		☐	SPART	☐	Division
11	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
12	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
13	PSTYV	JHAP	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
14	SELDAT_BIS	JHAP	SELDAT_BIS		☐	SELDAT_BIS	☐	IS-M: End Date for Items
15	XTBEL_SI	JHAPS	XTBEL_SI		☐	XTBEL_SI	☐	IS-M: Selective Booking of an AI BU
16	XSI_PLAZ	JHAPS	XSI_PLAZ		☐	XSI_PLAZ	☐	IS-M: Ad insert "positioned" indicator
17	XSI_WARTET	JHAPS	XSI_WARTET		☐	XSI_WARTET	☐	IS-M: Ad Insert Is On The Waiting List Indicator
18	XRESERV	JHAP	XRESERV		☐	XRESERV	☐	IS-M: Reservation indicator
19	XRESBEST	JHAP	XRESBEST		☐	XRESBEST	☐	IS-M: Reservation confirmed
20	UR_BELEINH	JHAUSI	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
21	STATUSK	JHAP	STATUSK		☐	STATUSK	☐	IS-M: Status
22	PRODH	JHAPS	PRODH		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
23	KONKAUS	JHAPS	KONKAUS		☐	KONKAUS	☐	IS-M: Competitor exclusion
24	KAMPAGNE	JHAP	KAMPAGNE		☐	KAMPAGNE	☐	IS-M: Campaign (customer)
25	DISPMENGE	JHAUSI	DISPMENGE		☐	DSPMGE_PAM	☐	IS-M: Planning Quantity for Ad Inserts
26	SIMENGE_RH	JHAUSI	SIMENGE_RH		☐	DSPMGE_RH	☐	IS-M: Non-Reader Circulation for TMC
27	POSTMENGE	JHAUSI	POSTMENGE		☐	POSTMENGE	☐	IS-M: Postal Circulation Quantity
28	STICHW	JHAPS	STICHW		☐	STICHW	☐	IS-M: Keyword
29	XSTORNIERT	JHAP	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
30	STORNOGRND	JHAP	STORNOGRND		☐	STOGRD_PAM	☐	IS-M: Cancellation Reason
31	XRESTHSHLT	JHAPS	XRESTHSHLT		☐	XRESTHSHLT	☐	IS-M: Total Market Coverage
32	POS_ANZSEITEN	JHAPS	ANZSEITEN		☐	ANZSEITEN	☐	Number of Pages in Issue
33	POS_SI_TYP	JHAPS	SI_TYP		☐	SITYP	☐	IS-M: Ad Insert Type
34	POS_SI_GEWICHT	JHAPS	SI_GEWICHT		☐	ISM_SI_GEWICHT	☐	IS-M: Ad Insert Weight
35	POS_MEINHGEWBL	JHAPS	MEINHGEWBL		☐	MEINHGEWBL	☐	IS-M: Unit of Weight for Ad Insert

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