SAP ABAP View JHVBPOVR (IS-M: Overlapping of Requirement Elements)

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	JHVBPOVR
Short Description	IS-M: Overlapping of Requirement Elements
Root table	JHTVGPZ	IS-M/AM: Business Partner Assignment to the Contract

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHTVGPZ	JHTVGPZ
2	JHTVPO
3	JHTVBPO
4	JHTVKO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHTVGPZ	MANDT	JL	EQ				0	0
2	JHTVPO	MANDT	JR	EQ			AND	0	0
3	JHTVGPZ	VTNR	JL	EQ				0	0
4	JHTVPO	VTNR	JR	EQ			AND	0	0
5	JHTVBPO	MANDT	JL	EQ				0	0
6	JHTVPO	MANDT	JR	EQ			AND	0	0
7	JHTVBPO	BEDNR	JL	EQ				0	0
8	JHTVPO	E_BEDNR	JR	EQ			AND	0	0
9	JHTVKO	MANDT	JL	EQ				0	0
10	JHTVGPZ	MANDT	JR	EQ			AND	0	0
11	JHTVKO	VTNR	JL	EQ				0	0
12	JHTVGPZ	VTNR	JR	EQ			AND	0	0
13	JHTVKO	ABRECHK		NE	'2'		AND	0	0
14	JHTVKO	XLOEVM		EQ	' '		AND	0	0
15	JHTVKO	KOFRS		EQ	'000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHTVGPZ	MANDT		☐	MANDT	☐	Client
2	VTNR	JHTVGPZ	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
3	GPROLLE	JHTVGPZ	GPROLLE		☐	JHPARVW	☐	IS-M: Partner Role (Such As BU for Voucher Copy Recipient)
4	GPNR	JHTVGPZ	GPNR		☐	JHVGPZNR	☐	IS-M/AM: Assigned Business Partner in the Contract
5	COA_POSNR	JHTVPO	POSNR		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
6	*	JHTVBPO	*		☐		☐
7	-	JHTVBPO	MANDT		☐	MANDT	☐	Client
8	BEDNR	JHTVBPO	BEDNR		☐	ABS_BEDNR	☐	IS-M/AM: Key for a Requirement in the Contract
9	POSNR	JHTVBPO	POSNR		☐	BED_POSNR	☐	IS-M: Requirement Element Number
10	AVMPOS_AR1	JHTVBPO	AVMPOS_AR1		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
11	AVMPOS_AR2	JHTVBPO	AVMPOS_AR2		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
12	AVMPOS_AR3	JHTVBPO	AVMPOS_AR3		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
13	AVMPOS_AR4	JHTVBPO	AVMPOS_AR4		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
14	AVMPOS_AR5	JHTVBPO	AVMPOS_AR5		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
15	AVMPOS_AR6	JHTVBPO	AVMPOS_AR6		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
16	PSTYV	JHTVBPO	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
17	AZART_AREA	JHTVBPO	AZART_AREA		☐	AZART_AREA	☐	IS-M/AM: Fixed Format Proposal /Ad Dimensions
18	AZART_FORM	JHTVBPO	AZART_FORM		☐	AZART_FORM	☐	IS-M: Shape Ad Type
19	AZART_FARB	JHTVBPO	AZART_FARB		☐	AZART_FARB	☐	IS-M: Color Scheme Ad Type
20	AZART_GEST	JHTVBPO	AZART_GEST		☐	AZART_GEST	☐	IS-M: Design Ad Type
21	AZART_RECH	JHTVBPO	AZART_RECH		☐	AZART_RECH	☐	IS-M: Calculation Ad Type
22	INHK_KFM	JHTVBPO	INHK_KFM		☐	INHK_KFM	☐	IS-M: Business Content Component
23	INHK_SOVER	JHTVBPO	INHK_SOVER		☐	INHK_SOVER	☐	IS-M: Special Publication Content Component
24	BELEINH1	JHTVBPO	BELEINH1		☐	BELEGEINH	☐	IS-M/AM: Booking Unit
25	KONDA	JHTVBPO	KONDA		☐	KONDA	☐	Price Group (Customer)
26	SINSBEARB	JHTVBPO	SINSBEARB		☐	SINSBEARB	☐	IS-M: Ad Insert Processing Type
27	SI_TYP	JHTVBPO	SI_TYP		☐	SITYP	☐	IS-M: Ad Insert Type
28	XRESTHSHLT	JHTVBPO	XRESTHSHLT		☐	JHRHHABD	☐	IS-M: Total Market Coverage Indicator
29	XTEILBELEG	JHTVBPO	XTEILBELEG		☐	JHTEILBEL	☐	IS-M: Selective/Full Booking Indicator
30	-	JHTVBPO	MIN_BELEG		☐	MIN_BELEG	☐	IS-M: Minimum Booking in Percent
31	DIENTYP	JHTVBPO	DIENTYP		☐	DIENTYP	☐	IS-M: Service Type
32	WS_ART	JHTVBPO	WS_ART		☐	WSPOT_ART	☐	IS-M: Commercial Type
33	PRODH	JHTVBPO	PRODH		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
34	KAMPAGNE	JHTVBPO	KAMPAGNE		☐	KAMPAGNE	☐	IS-M: Campaign (customer)
35	SI_TYP_V	JHTVBPO	SI_TYP_V		☐	SITYP	☐	IS-M: Ad Insert Type
36	JVTBEPMART	JHTVBPO	JVTBEPMART		☐	JVTBEPMART	☐	IS-M/AM: Distribution Planned Quantity Types
37	XVTEILBELEG	JHTVBPO	XVTEILBELEG		☐	JHTEILBEL	☐	IS-M: Selective/Full Booking Indicator
38	BOOK_OL	JHTVBPO	BOOK_OL		☐	ISM_BOOK_OL	☐	IS-M/AM: Booking Type for Online Advertising
39	FORMAT_ONL	JHTVBPO	FORMAT_ONL		☐	FORMAT_ONL	☐	IS-M/AM: Format Proposal (Online)
40	VAVTYP	JHTVBPO	VAVTYP		☐	VAVARTYP	☐	Issue Variant Type
41	VKORG	JHTVKO	VKORG		☐	VKORG	☐	Sales Organization
42	VTWEG	JHTVKO	VTWEG		☐	VTWEG	☐	Distribution Channel
43	SPART	JHTVKO	SPART		☐	SPART	☐	Division
44	LFZBEG	JHTVKO	LFZBEG		☐	LFZBEG	☐	IS-M: Start of Validity Period
45	LFZEND	JHTVKO	LFZEND		☐	LFZEND	☐	IS-M: End of Validity Period
46	XRABSPERR	JHTVKO	XRABSPERR		☐	XRABSPERR	☐	IS-M: Block higher-level discounts indicator
47	XRABAEN	JHTVKO	XRABAEN		☐	XRABAEN	☐	IS-M/AM: Discount Changed Manually
48	RABATT	JHTVKO	RABATT		☐	AB_RABATT	☐	IS-M: Current Valid Contract Discount Rate
49	VRABATT	JHTVKO	VRABATT		☐	VRABATT	☐	IS-M: Agreed Discount
50	AKTBONUS	JHTVKO	AKTBONUS		☐	AKTBONUS	☐	IS-M/AM: Current Valid Contract Bonus
51	VBONUS	JHTVKO	VBONUS		☐	VBONUS	☐	IS-M: Agreed Bonus
52	XQUASI	JHTVKO	XQUASI		☐	XQUASI	☐	IS-M: System Contracts Yes/No Indicator

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