SAP ABAP View M_MJJVD (Generated View for Matchcode ID MJJV-D)

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_MJJVD
Short Description	Generated View for Matchcode ID MJJV-D
Root table	JJTBB	IS-M/AM: Requirement Element of Media Sales Agent Contract

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTBB	JJTBB
2	JJTVV
3	JJTVB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTVV	MANDT	JL	EQ				0	1	XLOEKZBB
2	JJTVB	MANDT	JR	EQ			AND	0	1	XLOEKZBB
3	JJTVV	VNR	JL	EQ				0	1	XLOEKZBB
4	JJTVB	VNR	JR	EQ			AND	0	1	XLOEKZBB
5	JJTVB	MANDT	JL	EQ				0	1	XLOEKZBB
6	JJTBB	MANDT	JR	EQ			AND	0	1	XLOEKZBB
7	JJTVB	VNR	JL	EQ				0	1	XLOEKZBB
8	JJTBB	VNR	JR	EQ			AND	0	1	XLOEKZBB
9	JJTVB	BEDNR	JL	EQ				0	1	XLOEKZBB
10	JJTBB	BEDNR	JR	EQ			AND	0	1	XLOEKZBB
11	JJTBB	XLOEKZ		EQ	' '			0	1	XLOEKZBB

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTBB	MANDT		☐	MANDT	☐	Client
2	ZUOFUNKT	JJTBB	ZUOFUNKT		☐	JZFKT	☐	IS-M: Assignment Function (Inclusive, Exclusive)
3	BELEINH	JJTBB	BELEINH		☐	BELEGEINH	☐	IS-M/AM: Booking Unit
4	INHK_TECH2	JJTBB	INHK_TECH2		☐	INHK_SOVER	☐	IS-M: Special Publication Content Component
5	INHK_KFM	JJTBB	INHK_KFM		☐	INHK_KFM	☐	IS-M: Business Content Component
6	AVMPOS_ART	JJTBB	AVMPOS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
7	BRAN1	JJTBB	BRAN1		☐	BRAN_PAM	☐	IS-M: Industry Sector for Advertiser
8	KUKARR	JJTBB	KUKARR		☐	JKUKARR	☐	IS-M: Customer Profile
9	IN_GPNR	JJTBB	IN_GPNR		☐	INSERENT	☐	IS-M: Advertiser
10	AR_GPNR	JJTBB	AR_GPNR		☐	AGENTUR	☐	IS-M: Agency
11	BEZIRK_AG	JJTBB	BEZIRK_AG		☐	VERMBEZ_AG	☐	IS-M: Sales Agent Zone of the Agency
12	BEZIRK_IS	JJTBB	BEZIRK_IS		☐	VERMBEZ_IS	☐	IS-M: Sales Agent Zone of Advertiser
13	PRDHA	JJTBB	PRDHA		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
14	VTNR	JJTBB	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
15	MATNR	JJTBB	MATNR		☐	MATNR_DIEN	☐	IS-M: Service material number
16	DIENTYP	JJTBB	DIENTYP		☐	DIENTYP	☐	IS-M: Service Type
17	FATBB1	JJTBB	FATBB1		☐	JJFATBB1	☐	IS-M: Free Attribute 1 Requirement Element
18	FATBB2	JJTBB	FATBB2		☐	JJFATBB2	☐	IS-M: Free Attribute 2 Requirement Element
19	FATBB3	JJTBB	FATBB3		☐	JJFATBB3	☐	IS-M: Free Attribute 3 Requirement Element
20	FATBB4	JJTBB	FATBB4		☐	JJFATBB4	☐	IS-M: Free Attribute 4 Requirement Element
21	FATBB5	JJTBB	FATBB5		☐	JJFATBB5	☐	IS-M: Free Attribute 5 Requirement Element
22	FATBB6	JJTBB	FATBB6		☐	JJFATBB6	☐	IS-M: Free Attribute 6 Requirement Element
23	FATBB7	JJTBB	FATBB7		☐	JJFATBB7	☐	IS-M: Free Attribute 7 Requirement Element
24	VNR	JJTVV	VNR		☐	JVMVVNR	☐	IS-M: Media Sales Agent Contract Number

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