SAP ABAP View M_MJHXB (IS-M: View for Search Help MJHXB)

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	M_MJHXB
Short Description	IS-M: View for Search Help MJHXB
Root table	JHTMXK	IS-M: Media-Mix Contract Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHTMXK	JHTMXK
2	JHTMGPZ
3	JHTVKO
4	JHTVPO
5	JGTSADR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHTMXK	MANDT	JL	EQ				0	0
2	JHTMGPZ	MANDT	JR	EQ			AND	0	0
3	JHTMXK	VTNR	JL	EQ				0	0
4	JHTMGPZ	VTNR	JR	EQ			AND	0	0
5	JHTMXK	MANDT	JL	EQ				0	0
6	JHTVKO	MANDT	JR	EQ			AND	0	0
7	JHTMXK	VTNR	JL	EQ				0	0
8	JHTVKO	MM_VTNR	JR	EQ			AND	0	0
9	JHTVKO	MANDT	JL	EQ				0	0
10	JHTVPO	MANDT	JR	EQ			AND	0	0
11	JHTVKO	VTNR	JL	EQ				0	0
12	JHTVPO	VTNR	JR	EQ			AND	0	0
13	JGTSADR	MANDT	JL	EQ				0	0
14	JHTMGPZ	MANDT	JR	EQ			AND	0	0
15	JGTSADR	GP_REF	JL	EQ				0	0
16	JHTMGPZ	GPNR	JR	EQ			AND	0	0
17	JHTMGPZ	GPROLLE		EQ	'AI'		AND	0	0
18	JGTSADR	HERK		EQ	'1'		AND	0	0
19	JHTVPO	POSNR		EQ	'0001'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHTMXK	MANDT		☐	MANDT	☐	Client
2	VTNR	JHTMXK	VTNR		☐	MM_VTNR	☐	IS-M: Contract Number for Media-Mix Contract
3	GPROLLE	JHTMGPZ	GPROLLE		☐	JHPARVW	☐	IS-M: Partner Role (Such As BU for Voucher Copy Recipient)
4	GPNR	JHTMGPZ	GPNR		☐	JHVGPZNR	☐	IS-M/AM: Assigned Business Partner in the Contract
5	ADRNR	JGTSADR	ADRNR		☐	JADRNR	☐	IS-M: Address Number
6	VTNR_A	JHTVKO	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
7	POSNR	JHTVPO	POSNR		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
8	VKORG	JHTVKO	VKORG		☐	VKORG	☐	Sales Organization
9	VTWEG	JHTVKO	VTWEG		☐	VTWEG	☐	Distribution Channel
10	SPART	JHTVKO	SPART		☐	SPART	☐	Division
11	VKGRP	JHTVKO	VKGRP		☐	VKGRP	☐	Sales group
12	VKBUR	JHTVKO	VKBUR		☐	VKBUR	☐	Sales office
13	MENGE1	JHTVKO	MENGE1		☐	ABS_MENGE1	☐	IS-M/AM: Agreed Quantity to be Sold
14	EINH1	JHTVKO	EINH1		☐	AB_MEINH	☐	IS-M: Contract Units of Measurement
15	AB_ZIEL1	JHTVKO	AB_ZIEL1		☐	AB_ZIEL1	☐	IS-M/AM: Target Quantity for Monetary Contract
16	AB_WEINH	JHTVKO	AB_WEINH		☐	AB_WEINH	☐	IS-M: Currency Key for Contract
17	MENGE2	JHTVKO	MENGE2		☐	ABS_MENGE2	☐	IS-M/AM: Agreed Quantity to be Sold
18	EINH2	JHTVKO	EINH2		☐	AB_MEINH	☐	IS-M: Contract Units of Measurement
19	AB_VPREIS	JHTVKO	AB_VPREIS		☐	AB_VPREIS	☐	IS-M: Agreed Price from Contract
20	VRABATT	JHTVKO	VRABATT		☐	VRABATT	☐	IS-M: Agreed Discount
21	XERFUELLT	JHTVKO	XERFUELLT		☐	XERFUELLT	☐	IS-M/AM: Contract Fulfilled Yes/No Indicator
22	VBONUS	JHTVKO	VBONUS		☐	VBONUS	☐	IS-M: Agreed Bonus
23	E_BEDNR	JHTVPO	E_BEDNR		☐	E_BEDNR	☐	IS-M/AM: Inclusive Contract Requirement
24	A_BEDNR	JHTVPO	A_BEDNR		☐	A_BEDNR	☐	IS-M/AM: Exclusive Contract Requirement
25	NAME1	JGTSADR	NAME1		☐	NAME1_ISP	☐	IS-M: Business Partner Name

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