SAP ABAP View JHVSI_EIN (IS-M/AM: Ad Insert Read Schedule Lines)

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_EIN
Short Description	IS-M/AM: Ad Insert Read Schedule Lines
Root table	JHAK	IS-M/AM: Order-Publishing-Media (Header Data)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAK	JHAK
2	JHAPS
3	JHAE
4	JHAES
5	JHAP

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	JHAES	MANDT	JR	EQ			AND	0	0
3	JHAK	AVM_NR	JL	EQ				0	0
4	JHAES	AVM_NR	JR	EQ			AND	0	0
5	JHAP	MANDT	JL	EQ				0	0
6	JHAES	MANDT	JR	EQ			AND	0	0
7	JHAP	AVM_NR	JL	EQ				0	0
8	JHAES	AVM_NR	JR	EQ			AND	0	0
9	JHAP	POS_NR	JL	EQ				0	0
10	JHAES	POS_NR	JR	EQ			AND	0	0
11	JHAPS	MANDT	JL	EQ				0	0
12	JHAES	MANDT	JR	EQ			AND	0	0
13	JHAPS	AVM_NR	JL	EQ				0	0
14	JHAES	AVM_NR	JR	EQ			AND	0	0
15	JHAPS	POS_NR	JL	EQ				0	0
16	JHAES	POS_NR	JR	EQ			AND	0	0
17	JHAE	MANDT	JL	EQ				0	0
18	JHAES	MANDT	JR	EQ			AND	0	0
19	JHAE	AVM_NR	JL	EQ				0	0
20	JHAES	AVM_NR	JR	EQ			AND	0	0
21	JHAE	POS_NR	JL	EQ				0	0
22	JHAES	POS_NR	JR	EQ			AND	0	0
23	JHAE	UPOS_NR	JL	EQ				0	0
24	JHAES	UPOS_NR	JR	EQ			AND	0	0
25	JHAE	EIN_NR	JL	EQ				0	0
26	JHAES	EIN_NR	JR	EQ			AND	0	0
27	JHAP	MANDT	JL	EQ				0	0
28	JHAES	MANDT	JR	EQ			AND	0	0
29	JHAP	AVM_NR	JL	EQ				0	0
30	JHAES	AVM_NR	JR	EQ			AND	0	0
31	JHAP	POS_NR	JL	EQ				0	0
32	JHAES	POS_NR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAES	MANDT		☐	MANDT	☐	Client
2	SELDAT_VON	JHAES	ERSCHDAT		☐	ERSCHDAT	☐	Publication Date
3	BELEGEINH	JHAES	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
4	AVM_NR	JHAES	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
5	POS_NR	JHAES	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
6	UPOS_NR	JHAES	UPOS_NR		☐	UPOS_NR	☐	IS-M: Order Sub-Item Number
7	EIN_NR	JHAES	EIN_NR		☐	EIN_NR	☐	IS-M: Schedule Line
8	BEARB	JHAPS	BEARB		☐	SINSBEARB	☐	IS-M: Ad Insert Processing Type
9	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
10	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
11	SPART	JHAK	SPART		☐	SPART	☐	Division
12	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
13	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
14	PSTYV	JHAP	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
15	SELDAT_BIS	JHAP	SELDAT_BIS		☐	SELDAT_BIS	☐	IS-M: End Date for Items
16	XTBEL_SI	JHAPS	XTBEL_SI		☐	XTBEL_SI	☐	IS-M: Selective Booking of an AI BU
17	XSI_PLAZ	JHAPS	XSI_PLAZ		☐	XSI_PLAZ	☐	IS-M: Ad insert "positioned" indicator
18	XSI_WARTET	JHAPS	XSI_WARTET		☐	XSI_WARTET	☐	IS-M: Ad Insert Is On The Waiting List Indicator
19	XRESERV	JHAP	XRESERV		☐	XRESERV	☐	IS-M: Reservation indicator
20	XRESBEST	JHAP	XRESBEST		☐	XRESBEST	☐	IS-M: Reservation confirmed
21	UR_BELEINH	JHAES	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
22	STATUSK	JHAP	STATUSK		☐	STATUSK	☐	IS-M: Status
23	PRODH	JHAPS	PRODH		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
24	KONKAUS	JHAPS	KONKAUS		☐	KONKAUS	☐	IS-M: Competitor exclusion
25	KAMPAGNE	JHAP	KAMPAGNE		☐	KAMPAGNE	☐	IS-M: Campaign (customer)
26	DISPMENGE	JHAES	DISPMENGE		☐	DSPMGE_PAM	☐	IS-M: Planning Quantity for Ad Inserts
27	SIMENGE_RH	JHAES	SIMENGE_RH		☐	DSPMGE_RH	☐	IS-M: Non-Reader Circulation for TMC
28	POSTMENGE	JHAES	POSTMENGE		☐	POSTMENGE	☐	IS-M: Postal Circulation Quantity
29	STICHW	JHAPS	STICHW		☐	STICHW	☐	IS-M: Keyword
30	XSTORNIERT	JHAE	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
31	STORNOGRND	JHAE	STORNOGRND		☐	STOGRD_PAM	☐	IS-M: Cancellation Reason
32	EIN_ART	JHAE	EIN_ART		☐	JHAE_ART	☐	IS-M: Schedule Line Type
33	XRESTHSHLT	JHAPS	XRESTHSHLT		☐	XRESTHSHLT	☐	IS-M: Total Market Coverage
34	POS_ANZSEITEN	JHAPS	ANZSEITEN		☐	ANZSEITEN	☐	Number of Pages in Issue
35	POS_SI_TYP	JHAPS	SI_TYP		☐	SITYP	☐	IS-M: Ad Insert Type
36	POS_SI_GEWICHT	JHAPS	SI_GEWICHT		☐	ISM_SI_GEWICHT	☐	IS-M: Ad Insert Weight
37	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