SAP ABAP View M_MJHWA (Generated View for Matchcode ID MJHW-A)

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_MJHWA
Short Description	Generated View for Matchcode ID MJHW-A
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	JHTVKO	JHTVKO
3	JGTADRA
4	JGTSADR
5	JHTVPO

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	JHTVKO	MANDT	JR	EQ			AND	0	0
3	JHTVGPZ	VTNR	JL	EQ				0	0
4	JHTVKO	VTNR	JR	EQ			AND	0	0
5	JHTVGPZ	MANDT	JL	EQ				0	0
6	JGTADRA	MANDT	JR	EQ			AND	0	0
7	JHTVGPZ	GPNR	JL	EQ				0	0
8	JGTADRA	GPNR	JR	EQ			AND	0	0
9	JGTSADR	MANDT	JL	EQ				0	0
10	JGTADRA	MANDT	JR	EQ			AND	0	0
11	JGTSADR	ADRNR	JL	EQ				0	0
12	JGTADRA	ADRNR	JR	EQ			AND	0	0
13	JHTVKO	MANDT	JL	EQ				0	0
14	JHTVPO	MANDT	JR	EQ			AND	0	0
15	JHTVKO	VTNR	JL	EQ				0	0
16	JHTVPO	VTNR	JR	EQ			AND	0	0
17	JHTVKO	MM_VTNR		EQ	' '		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	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	LOGADR	JGTADRA	LOGADR		☐	JLOGADR	☐	IS-M: Logical Address Number
6	ADRZA	JGTADRA	ADRZA		☐	JADRZA	☐	IS-M: Time Slice Counter in Logical Address
7	JPARVW	JGTADRA	JPARVW		☐	JPARVW2	☐	IS-M: Business Partner Roles
8	POSNR	JHTVPO	POSNR		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
9	ABS_TYP1	JHTVKO	ABS_TYP1		☐	ABS_TYP	☐	IS-M/AM: Contract Category
10	LFZBEG	JHTVKO	LFZBEG		☐	LFZBEG	☐	IS-M: Start of Validity Period
11	LFZEND	JHTVKO	LFZEND		☐	LFZEND	☐	IS-M: End of Validity Period
12	VKORG	JHTVKO	VKORG		☐	VKORG	☐	Sales Organization
13	VTWEG	JHTVKO	VTWEG		☐	VTWEG	☐	Distribution Channel
14	SPART	JHTVKO	SPART		☐	SPART	☐	Division
15	VKGRP	JHTVKO	VKGRP		☐	VKGRP	☐	Sales group
16	VKBUR	JHTVKO	VKBUR		☐	VKBUR	☐	Sales office
17	WDAT1	JGTADRA	WDAT1		☐	GUELTIGVON	☐	Valid-From Date
18	WDAT2	JGTADRA	WDAT2		☐	GUELTIGBIS	☐	Valid-To Date
19	NAME1	JGTSADR	NAME1		☐	NAME1_ISP	☐	IS-M: Business Partner Name
20	NAME2	JGTSADR	NAME2		☐	NAME2_ISP	☐	IS-M: First Name of Business Partner
21	PSTLZ	JGTSADR	PSTLZ		☐	PLZ_ISP	☐	IS-M: Postal Code
22	ORT01	JGTSADR	ORT01		☐	ORT01_ISP	☐	IS-M: City
23	STRAS	JGTSADR	STRAS		☐	STRAS_ISP	☐	IS-M: Street Name
24	HAUSN	JGTSADR	HAUSN		☐	HSNMR1	☐	IS-M: House Number
25	NAME1_MACO	JGTSADR	NAME1_MACO		☐	NAME1_ISPM	☐	IS-M: Business Partner Name (Upper Case for Matchcode)
26	NAME2_MACO	JGTSADR	NAME2_MACO		☐	NAME2_ISPM	☐	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
27	STRAS_MACO	JGTSADR	STRAS_MACO		☐	STRAS_ISPM	☐	IS-M: Street Name
28	ORT01_MACO	JGTSADR	ORT01_MACO		☐	ORT01_ISPM	☐	IS-M/SD: City Name (Upper Case for Matchcode)
29	E_BEDNR	JHTVPO	E_BEDNR		☐	E_BEDNR	☐	IS-M/AM: Inclusive Contract Requirement

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