SAP ABAP View JHVPRDFI (IS-M/AM: Selection View for RJHPRDFI)

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	JHVPRDFI
Short Description	IS-M/AM: Selection View for RJHPRDFI
Root table	JHAEA	IS-M/AM: Order-Publishing-Media Ad Schedule Line

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAEA	JHAEA
2	JHAE
3	JHAMOZ
4	JHAMOT
5	JHAK
6	JHAP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAE	MANDT	JL	EQ				0	0
2	JHAEA	MANDT	JR	EQ			AND	0	0
3	JHAE	AVM_NR	JL	EQ				0	0
4	JHAEA	AVM_NR	JR	EQ			AND	0	0
5	JHAE	POS_NR	JL	EQ				0	0
6	JHAEA	POS_NR	JR	EQ			AND	0	0
7	JHAE	UPOS_NR	JL	EQ				0	0
8	JHAEA	UPOS_NR	JR	EQ			AND	0	0
9	JHAE	EIN_NR	JL	EQ				0	0
10	JHAEA	EIN_NR	JR	EQ			AND	0	0
11	JHAEA	MANDT	JL	EQ				0	0
12	JHAMOZ	MANDT	JR	EQ			AND	0	0
13	JHAEA	AVM_NR	JL	EQ				0	0
14	JHAMOZ	AVM_NR	JR	EQ			AND	0	0
15	JHAEA	POS_NR	JL	EQ				0	0
16	JHAMOZ	POS_NR	JR	EQ			AND	0	0
17	JHAEA	UPOS_NR	JL	EQ				0	0
18	JHAMOZ	UPOS_NR	JR	EQ			AND	0	0
19	JHAEA	EIN_NR	JL	EQ				0	0
20	JHAMOZ	EIN_NR	JR	EQ			AND	0	0
21	JHAMOT	MANDT	JL	EQ				0	0
22	JHAMOZ	MANDT	JR	EQ			AND	0	0
23	JHAMOT	AVM_NR	JL	EQ				0	0
24	JHAMOZ	AVM_NR	JR	EQ			AND	0	0
25	JHAMOT	MOTIV	JL	EQ				0	0
26	JHAMOZ	MOTIV	JR	EQ			AND	0	0
27	JHAK	MANDT	JL	EQ				0	0
28	JHAEA	MANDT	JR	EQ			AND	0	0
29	JHAK	AVM_NR	JL	EQ				0	0
30	JHAEA	AVM_NR	JR	EQ			AND	0	0
31	JHAP	MANDT	JL	EQ				0	0
32	JHAEA	MANDT	JR	EQ			AND	0	0
33	JHAP	AVM_NR	JL	EQ				0	0
34	JHAEA	AVM_NR	JR	EQ			AND	0	0
35	JHAP	POS_NR	JL	EQ				0	0
36	JHAEA	POS_NR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAEA	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAEA	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAEA	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	UPOS_NR	JHAEA	UPOS_NR		☐	UPOS_NR	☐	IS-M: Order Sub-Item Number
5	EIN_NR	JHAEA	EIN_NR		☐	EIN_NR	☐	IS-M: Schedule Line
6	MOTIV	JHAMOT	MOTIV		☐	MOTIV_NR	☐	IS-M: Ad Spec Number (Ad)
7	UR_BELEINH	JHAEA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
8	BELEGEINH	JHAEA	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
9	E_BELEINH	JHAEA	E_BELEINH		☐	E_BE_BASIS	☐	IS-M: Publication Basic Booking Unit
10	INHK_PLAZ	JHAEA	INHK_PLAZ		☐	INHK_PLAZ	☐	IS-M: Positioning content component
11	INHK_SOVER	JHAEA	INHK_SOVER		☐	INHK_SOVER	☐	IS-M: Special Publication Content Component
12	E_TERMIN	JHAEA	E_TERMIN		☐	E_TERMIN	☐	IS-M: Publication Date
13	E_HEFT	JHAEA	E_HEFT		☐	E_HEFT	☐	IS-M: Publication Copy Number
14	AENVERS_NR	JHAEA	AENVERS_NR		☐	AENVERS_NR	☐	IS-M: Last Change Version for Technical System
15	XANNSCHLAB	JHAEA	XANNSCHLAB		☐	XANNSCHLAB	☐	IS-M: Order Deadline is Past
16	XSTPLAZ	JHAEA	XSTPLAZ		☐	XSTPLAZ	☐	IS-M: Positioned indicator
17	XBELICHTET	JHAEA	XBELICHTET		☐	XBELICHTET	☐	IS-M: "Exposed" Indicator
18	XERSCH	JHAEA	XERSCH		☐	XERSCH	☐	IS-M: Schedule Line Published Indicator
19	SEITE_FSPEA	JHAEA	SEITE_FSP		☐	SEITE_FSP	☐	IS-M: Page/column format
20	XSTORNIERT	JHAE	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
21	STATUSK	JHAE	STATUSK		☐	STATUSK	☐	IS-M: Status
22	MOTIVSTAT	JHAMOT	MOTIVSTAT		☐	MOTIVSTAT	☐	IS-M: Ad spec status
23	MOTAENVNR	JHAMOT	AENVERS_NR		☐	AENVERS_NR	☐	IS-M: Last Change Version for Technical System
24	MOTIVID	JHAMOT	MOTIVID		☐	MOTIVID	☐	IS-M: Assigned ad spec/ad spec file in technical system
25	AZART_GEST	JHAMOT	AZART_GEST		☐	AZART_GEST	☐	IS-M: Design Ad Type
26	HOEHE_I	JHAMOT	HOEHE_I		☐	HOEHE_I	☐	IS-M: Actual height of the ad spec
27	HOEHE_I_EH	JHAMOT	HOEHE_I_EH		☐	ISPEINH_H	☐	IS-M: Unit of Measure for Height
28	BREITE_I	JHAMOT	BREITE_I		☐	BREITE_I	☐	IS-M: Actual Ad Spec Width
29	BREITE_IEH	JHAMOT	BREITE_IEH		☐	BREITE_SEH	☐	IS-M/AM: Unit of Measure for Width
30	HOEHE_T	JHAMOT	HOEHE_T		☐	HOEHE_T	☐	IS-M: Technical height
31	HOEHE_T_EH	JHAMOT	HOEHE_T_EH		☐	ISPEINH_H	☐	IS-M: Unit of Measure for Height
32	BREITE_T	JHAMOT	BREITE_T		☐	BREITE_T	☐	IS-M: Technical Width Specification
33	BREITE_TEH	JHAMOT	BREITE_TEH		☐	BREITE_SEH	☐	IS-M/AM: Unit of Measure for Width
34	HOEHE_S	JHAMOT	HOEHE_S		☐	HOEHE_S	☐	IS-M: Planned Height of the Ad Spec
35	HOEHE_S_EH	JHAMOT	HOEHE_S_EH		☐	ISPEINH_H	☐	IS-M: Unit of Measure for Height
36	BREITE_S	JHAMOT	BREITE_S		☐	BREITE_S	☐	IS-M: Planned Ad Spec Width
37	BREITE_SEH	JHAMOT	BREITE_SEH		☐	BREITE_SEH	☐	IS-M/AM: Unit of Measure for Width
38	NUTZFL_ANT	JHAMOT	NUTZFL_ANT		☐	NUTZFL_ANT	☐	IS-M: Share of Technical Area used for Ad Spec
39	ZUS_BERECH	JHAMOT	ZUS_BERECH		☐	MEINH_ZUS	☐	IS-M: Additional Unit of Measure for Settlement
40	ZUS_MENGE	JHAMOT	ZUS_MENGE		☐	BER_MENGE	☐	IS-M: Number of Additional Ad Spec Calculation Units
41	SEITE_FSP	JHAMOT	SEITE_FSP		☐	SEITE_FSP	☐	IS-M: Page/column format
42	AZART_FARB	JHAMOT	AZART_FARB		☐	AZART_FARB	☐	IS-M: Color Scheme Ad Type
43	AZFARB_IST	JHAMOT	AZFARB_IST		☐	AZFARB_IST	☐	IS-M: Actual Color Scheme Ad Type
44	GRUNFARBEN	JHAMOT	GRUNFARBEN		☐	FARBNAME	☐	IS-M: Color Name
45	ZUSATZFA1	JHAMOT	ZUSATZFA1		☐	FARBNAME	☐	IS-M: Color Name
46	ZUSATZFA2	JHAMOT	ZUSATZFA2		☐	FARBNAME	☐	IS-M: Color Name
47	ZUSATZFA3	JHAMOT	ZUSATZFA3		☐	FARBNAME	☐	IS-M: Color Name
48	TYPO_NR	JHAMOT	TYPO_NR		☐	TYPO_NR	☐	IS-M: Typography Number
49	RAHMENTYP	JHAMOT	RAHMENTYP		☐	RAHMENTYP	☐	IS-M: Border Type
50	RAHMENSTAE	JHAMOT	RAHMENSTAE		☐	RAHMENSTAE	☐	IS-M: Border Width
51	RAHMENEINH	JHAMOT	RAHMENEINH		☐	RAHMENEINH	☐	IS-M: Unit of measurement for border width
52	INVERSKNZ	JHAMOT	INVERSKNZ		☐	INVERSKNZ	☐	IS-M: Reversed Indicator
53	RASTER	JHAMOT	RASTER		☐	RASTERUNG	☐	IS-M: Grid Spacing
54	STICHW	JHAMOT	STICHW		☐	STICHW	☐	IS-M: Keyword
55	TEXTSPITZE	JHAMOT	TEXTSPITZE		☐	TEXTSPITZE	☐	IS-M: Ad Text Header
56	BILOZ_ANZ	JHAMOT	BILOZ_ANZ		☐	BILOZ_ANZ	☐	IS-M: Amount of Artwork Assigned to the Ad Spec
57	AZART_AREA	JHAMOT	AZART_AREA		☐	AZART_AREA	☐	IS-M/AM: Fixed Format Proposal /Ad Dimensions
58	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
59	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
60	SPART	JHAK	SPART		☐	SPART	☐	Division
61	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
62	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
63	AUART	JHAK	AUART		☐	AUART_PAM	☐	IS-M: Sales Document Type
64	PSTYV	JHAP	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document

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