SAP ABAP View JHVAMOZMOT (IS-M/AM: View of Ad Spec Assignment and Ad Specs)

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	JHVAMOZMOT
Short Description	IS-M/AM: View of Ad Spec Assignment and Ad Specs
Root table	JHAMOZ	IS-M/AM: Assign Ad Specs to Order Objects

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAMOZ	JHAMOZ
2	JHAMOT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAMOT	MANDT	JL	EQ				0	0
2	JHAMOZ	MANDT	JR	EQ			AND	0	0
3	JHAMOT	AVM_NR	JL	EQ				0	0
4	JHAMOZ	AVM_NR	JR	EQ			AND	0	0
5	JHAMOT	MOTIV	JL	EQ				0	0
6	JHAMOZ	MOTIV	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAMOZ	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAMOZ	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAMOZ	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	UPOS_NR	JHAMOZ	UPOS_NR		☐	UPOS_NR	☐	IS-M: Order Sub-Item Number
5	EIN_NR	JHAMOZ	EIN_NR		☐	EIN_NR	☐	IS-M: Schedule Line
6	MOTIV	JHAMOZ	MOTIV		☐	MOTIV_NR	☐	IS-M: Ad Spec Number (Ad)
7	NOTIZ	JHAMOT	NOTIZ		☐	MOTIVNOTIZ	☐	IS-M: Note for Ad Spec Design
8	STICHW	JHAMOT	STICHW		☐	STICHW	☐	IS-M: Keyword
9	TEXTSPITZE	JHAMOT	TEXTSPITZE		☐	TEXTSPITZE	☐	IS-M: Ad Text Header
10	ABW_TELLND	JHAMOT	ABW_TELLND		☐	ABW_TELLND	☐	IS-M: Alternative International Dialing Code for Ad Spec
11	ABW_TELVW	JHAMOT	ABW_TELVW		☐	ABW_TELVW	☐	IS-M: Alternative Area Code for Ad Spec
12	ABW_TEL	JHAMOT	ABW_TEL		☐	ABW_TEL	☐	IS-M: Alternative Telephone Number for Ad Spec
13	AZART_GEST	JHAMOT	AZART_GEST		☐	AZART_GEST	☐	IS-M: Design Ad Type
14	AZART_FARB	JHAMOT	AZART_FARB		☐	AZART_FARB	☐	IS-M: Color Scheme Ad Type
15	AZART_AREA	JHAMOT	AZART_AREA		☐	AZART_AREA	☐	IS-M/AM: Fixed Format Proposal /Ad Dimensions
16	HOEHE_I	JHAMOT	HOEHE_I		☐	HOEHE_I	☐	IS-M: Actual height of the ad spec
17	HOEHE_I_EH	JHAMOT	HOEHE_I_EH		☐	ISPEINH_H	☐	IS-M: Unit of Measure for Height
18	BREITE_I	JHAMOT	BREITE_I		☐	BREITE_I	☐	IS-M: Actual Ad Spec Width
19	BREITE_IEH	JHAMOT	BREITE_IEH		☐	BREITE_SEH	☐	IS-M/AM: Unit of Measure for Width
20	HOEHE_S	JHAMOT	HOEHE_S		☐	HOEHE_S	☐	IS-M: Planned Height of the Ad Spec
21	HOEHE_S_EH	JHAMOT	HOEHE_S_EH		☐	ISPEINH_H	☐	IS-M: Unit of Measure for Height
22	BREITE_S	JHAMOT	BREITE_S		☐	BREITE_S	☐	IS-M: Planned Ad Spec Width
23	BREITE_SEH	JHAMOT	BREITE_SEH		☐	BREITE_SEH	☐	IS-M/AM: Unit of Measure for Width
24	COUPON_KNZ	JHAMOT	COUPON_KNZ		☐	COUPON_KNZ	☐	IS-M: Coupon Identification Number
25	KENNZIFFER	JHAMOT	KENNZIFFER		☐	PAM_KENNZI	☐	IS-M: Identification Number
26	SUJET_NR	JHAMOT	SUJET_NR		☐	SUJET_NR	☐	IS-M: Subject Number
27	SERVICENR	JHAMOT	SERVICENR		☐	SERVICENR	☐	IS-M: Service Number
28	PRODH	JHAMOT	PRODH		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
29	TYPO_NR	JHAMOT	TYPO_NR		☐	TYPO_NR	☐	IS-M: Typography 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