SAP ABAP Table RJHAMOTOVB (IS-M/AM: Update Structure for JHAMOTO)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	RJHAMOTOVB	Table Relationship Diagram
Short Description	IS-M/AM: Update Structure for JHAMOTO

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	IS-M/AM: Online Ad Spec
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
4	MOTIV	☐	OLMOTIV_NR	MAM_OL_MOT	NUMC	6	0	IS-M: Order ad spec number (online)	*
5	MOTIVSTAT	☐	MOTIVSTAT	PAM_STATUS	CHAR	2	0	IS-M: Ad spec status
6	NOTIZ	☐	MOTIVNOTIZ	TEXT50	CHAR	50	0	IS-M: Note for Ad Spec Design
7	MOTIVID	☐	MOTIVID	MOTIVID	CHAR	12	0	IS-M: Assigned ad spec/ad spec file in technical system
8	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
9	VORL_MOTNR	☐	VORL_MOTNR_OL	MAM_OL_MOT	NUMC	6	0	IS-M: Template ad spec (online)	JHAMOTO
10	VORL_TECID	☐	VORL_TECID	MOTIVID	CHAR	12	0	IS-M: Ad spec template (description in technical system)
11	HOEHE_S	☐	HOEHE_S	GROESSE	QUAN	7	3	IS-M: Planned Height of the Ad Spec
12	HOEHE_S_EH	☐	ONL_HOEHE_SEH	ONL_HOEHE_SEH	UNIT	3	0	IS-M/AM: Unit of Measurement for Height (Online)	TJHOLHME
13	BREITE_S	☐	BREITE_S	GROESSE	QUAN	7	3	IS-M: Planned Ad Spec Width
14	BREITE_SEH	☐	ISPEINH_OL	ISPEINH_OL	UNIT	3	0	IS-M/AM: Unit of Measurement for Online Ad Size Field	TJHOLBME
15	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
16	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
17	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	TJHOLFMT
18	LINK_URL	☐	LINK_URL	TEXT132	CHAR	132	0	IS-M/AM: Target URL for a banner
19	GROESSE	☐	GROESSE_KB	ISM_DEC10_3	DEC	10	3	IS-M/AM: File Size for Online Ad Spec
20	GROESSE_UNIT	☐	GROESSE_UNIT	MEINS	UNIT	3	0	IS-M/AM: Unit for Physical Ad Spec Size	T006
21	CLICK_TEXT	☐	CLICKTEXT	TEXT132	CHAR	132	0	IS-M/AM: Clicktext for an Online Ad Spec
22	ALTERN_TEXT	☐	ALTERN_TEXT	TEXT132	CHAR	132	0	IS-M/AM: Alternative Text for an Online Ad Spec
23	DRVORL_NR	☐	DRVORL_NR	DRVORL_NR	NUMC	6	0	IS-M: Ad Spec Master	JHADRV
24	AENVERS_NR_OL	☐	AENVERS_NR	AENVERS_NR	NUMC	4	0	IS-M: Last Change Version for Technical System
25	XMOTIVTEXT	☐	XMOTIVTEXT	XFELD	CHAR	1	0	IS-M/AM: Text Exists for the Ad Spec Indicator
26	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
27	.INCLUDE	☐				0	0	IS-M/AM: Status Attributes for Online Ad Spec
28	XUVMOT	☐	XUVMOT	XFELD	CHAR	1	0	IS-M: "Ad spec data incomplete" indicator
29	XPRNOTW	☐	XPRNOTW	XFELD	CHAR	1	0	IS-M: Ad Spec Check Required But Not Performed
30	.INCLUDE	☐				0	0	IS-M/AM: Characteristics for Individual Use (Online Ad Spec)
31	MERKMAL0	☐	MERK0_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Online Ad Spec)
32	MERKMAL1	☐	MERK1_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Online Ad Spec)
33	MERKMAL2	☐	MERK2_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Online Ad Spec)
34	MERKMAL3	☐	MERK3_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Online Ad Spec)
35	MERKMAL4	☐	MERK4_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Online Ad Spec)
36	MERKMAL5	☐	MERK5_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Online Ad Spec)
37	MERKMAL6	☐	MERK6_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Online Ad Spec)
38	MERKMAL7	☐	MERK7_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Online Ad Spec)
39	MERKMAL8	☐	MERK8_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Online Ad Spec)
40	MERKMAL9	☐	MERK9_MOTO	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Online Ad Spec)
41	.INCLUDE	☐				0	0	IS-M/AM: Include for Sub Ad Spec/Linking Attributes (Online)
42	TMOT_KENNZ	☐	TMOT_KENNZ	TMOTIV_KE	CHAR	6	0	IS-M/AM: Sub ad spec/linked ad specs indicator	TJH75
43	TMOT_NR	☐	TMOT_NR	NUMC2	NUMC	2	0	IS-M: Position of the Sub Ad Spec Within the Chain
44	TMOT_ANZ	☐	TMOT_ANZ	NUM02	NUMC	2	0	IS-M: Number of sub ad specs in an ad spec chain
45	TMOT_BEZUG	☐	TMOT_BEZUG_OL	MAM_OL_MOT	NUMC	6	0	IS-M: Ref.to header ad spec in ad spec linking (online)	JHAMOTO
46	TMOT_LAGE	☐	TMOT_LAGE	MOT_LAGE	CHAR	4	0	IS-M: Position of Sub Ad Spec (Relative to Header Ad Spec)	TJH77
47	TMOT_KOMM	☐	TMOT_KOMM	TEXT30	CHAR	30	0	IS-M: Comment on location of sub ad spec
48	DBCODE	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHAMOTOVB	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	RJHAMOTOVB	BREITE_SEH	TJHOLBME	ISPEINH_OL
3	RJHAMOTOVB	DRVORL_NR	JHADRV	DRVORL_NR	REF	1	CN
4	RJHAMOTOVB	FORMAT_ONL	TJHOLFMT	FORMAT_ONL	REF	1	CN
5	RJHAMOTOVB	GROESSE_UNIT	T006	MSEHI
6	RJHAMOTOVB	HOEHE_S_EH	TJHOLHME	ONL_HOEHE_SEH
7	RJHAMOTOVB	MANDT	T000	MANDT	KEY	1	CN
8	RJHAMOTOVB	PRODH	JJT179	PRODH
9	RJHAMOTOVB	TMOT_BEZUG	JHAMOTO	MOTIV	REF
10	RJHAMOTOVB	TMOT_KENNZ	TJH75	TMOT_KENNZ	REF	1	CN
11	RJHAMOTOVB	TMOT_LAGE	TJH77	TMOT_LAGE	REF	1	CN
12	RJHAMOTOVB	VORL_AVMNR	JHAK	AVM_NR		1	CN
13	RJHAMOTOVB	VORL_MOTNR	JHAMOTO	MOTIV

History

Last changed by/on	SAP	20130529
SAP Release Created in