SAP ABAP Table RJHAMOTVB (IS-PAM: Update structure for JHAMOT)
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 RJHAMOTVB   Table Relationship Diagram
Short Description IS-PAM: Update structure for JHAMOT    
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: 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 MOTIV_NR PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Number (Ad) *
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 PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Template (Ad) JHAMOT
10 VORL_TECID VORL_TECID MOTIVID CHAR 12   0   IS-M: Ad spec template (description in technical system)  
11 DRVORL_NR DRVORL_NR DRVORL_NR NUMC 6   0   IS-M: Ad Spec Master JHADRV
12 AZART_SOND AZART_SOND AZART_SOND CHAR 2   0   IS-M: Ad Type - Special Handling Type TJJ49
13 ASOND_KOMM ASOND_KOMM TEXT60 CHAR 60   0   IS-M: Comment for Special Ad Handling  
14 AZART_GEST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
15 AZART_FORM AZART_FORM AZART_FORM CHAR 4   0   IS-M: Shape Ad Type TJJ17
16 AZART_AREA AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions TJJ13
17 AREA_UEBER AREA_UEBER AZART_AREA CHAR 4   0   IS-M: Gutter Bleed Format from Format Proposal Hierarchy TJJ13
18 AREA_BLATT AREA_BLATT AZART_AREA CHAR 4   0   IS-M: End Node Format in Format Proposal Hierarchy TJJ13
19 XMOTLINKS XMOTLINKS XFELD CHAR 1   0   IS-M: Ad spec is located on left-hand side of page indicator  
20 XMOTRECHTS XMOTRECHTS XFELD CHAR 1   0   IS-M: Ad spec located on right-hand side of page indicator  
21 HOEHE_I HOEHE_I GROESSE QUAN 7   3   IS-M: Actual height of the ad spec  
22 HOEHE_I_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
23 BREITE_I BREITE_I GROESSE QUAN 7   3   IS-M: Actual Ad Spec Width  
24 BREITE_IEH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
25 HOEHE_T HOEHE_T GROESSE QUAN 7   3   IS-M: Technical height  
26 HOEHE_T_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
27 BREITE_T BREITE_T GROESSE QUAN 7   3   IS-M: Technical Width Specification  
28 BREITE_TEH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
29 HOEHE_S HOEHE_S GROESSE QUAN 7   3   IS-M: Planned Height of the Ad Spec  
30 XHOEHE_GR XHOEHE_GR XFELD CHAR 1   0   IS-M: Height cannot be entered  
31 HOEHE_S_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
32 XHOEHEH_GR XHOEHEH_GR XFELD CHAR 1   0   IS-M: Unit of Measurement for Height Cannot be Entered  
33 BREITE_S BREITE_S GROESSE QUAN 7   3   IS-M: Planned Ad Spec Width  
34 XBREITE_GR XBREITE_GR XFELD CHAR 1   0   IS-M: Width Cannot be Entered  
35 BREITE_SEH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
36 XBREIEH_GR XBREIEH_GR XFELD CHAR 1   0   IS-M: Unit of measurement for width cannot be entered  
37 NUTZFL_ANT NUTZFL_ANT PROZENT100 NUMC 3   0   IS-M: Share of Technical Area used for Ad Spec  
38 ZUS_BERECH MEINH_ZUS ISPEINHEIT UNIT 3   0   IS-M: Additional Unit of Measure for Settlement TJH57
39 ZUS_MENGE BER_MENGE GROESSE QUAN 7   3   IS-M: Number of Additional Ad Spec Calculation Units  
40 XHOEHE_ZWI XHOEHE_ZWI XHOEHE_ZWI CHAR 1   0   IS-M: Height Indicator TJHB3
41 SEITE_FSP SEITE_FSP SEITE_FSP CHAR 4   0   IS-M: Page/column format TJJ47
42 .INCLUDE       0   0   IS-M: Include For Color Attributes for Ad Spec/Ad  
43 AZART_FARB AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
44 AZFARB_IST AZFARB_IST AZART_FARB CHAR 4   0   IS-M: Actual Color Scheme Ad Type TJJ11
45 GRUNFARBEN FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
46 ZUSATZFA1 FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
47 ZUSATZFA2 FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
48 ZUSATZFA3 FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
49 XSCHMFAAUF XSCHMFAAUF XFELD CHAR 1   0   IS-M: Indicator: Additional Color Can be Created Using 4C  
50 FARBKOMM FARBKOM_I TEXT34 CHAR 34   0   IS-M: Color Comment for Ad/Ad Spec  
51 .INCLUDE       0   0   IS-M/AM: Include for Ad Spec Design  
52 TYPO_NR TYPO_NR TYPONR CHAR 8   0   IS-M: Typography Number  
53 RAHMENTYP RAHMENTYP RAHMENTYP CHAR 8   0   IS-M: Border Type TJH35
54 RAHMENSTAE RAHMENSTAE NUM2 NUMC 2   0   IS-M: Border Width  
55 RAHMENEINH RAHMENEINH MEINS UNIT 3   0   IS-M: Unit of measurement for border width T006
56 INVERSKNZ INVERSKNZ XFELD CHAR 1   0   IS-M: Reversed Indicator  
57 RASTER RASTERUNG RASTERUNG CHAR 2   0   IS-M: Grid Spacing TJH37
58 STYLE ISM_AMC_STYLE ISM_AMC_STYLE CHAR 30   0   IS-M: Style for IS-M/AMC  
59 TEMPLATE ISM_AMC_TEMPLATE ISM_AMC_TEMPLATE CHAR 30   0   IS-M: Template for IS-M/AMC  
60 .INCLUDE       0   0   IS-M/AM: Include for Attributes for Sub Ad Specs/Linking  
61 TMOT_KENNZ TMOT_KENNZ TMOTIV_KE CHAR 6   0   IS-M/AM: Sub ad spec/linked ad specs indicator TJH75
62 TMOT_NR TMOT_NR NUMC2 NUMC 2   0   IS-M: Position of the Sub Ad Spec Within the Chain  
63 TMOT_ANZ TMOT_ANZ NUM02 NUMC 2   0   IS-M: Number of sub ad specs in an ad spec chain  
64 TMOT_BEZUG TMOT_BEZUG PAM_MOTIV NUMC 6   0   IS-M: Reference to header ad spec for linked ad specs JHAMOT
65 TMOT_LAGE TMOT_LAGE MOT_LAGE CHAR 4   0   IS-M: Position of Sub Ad Spec (Relative to Header Ad Spec) TJH77
66 TMOT_KOMM TMOT_KOMM TEXT30 CHAR 30   0   IS-M: Comment on location of sub ad spec  
67 TMOT_UEBER TMOT_UEBER PAM_MOTIV NUMC 6   0   IS-M: Assigned Sub Ad Spec for Gutter Bleed Formats JHAMOT
68 BREITETMOT BREITETMOT GROESSE QUAN 7   3   IS-M: Totalled Widths for Linked Sub Ad Specs  
69 BREITETMEH BREITETMEH ISPEINHEIT UNIT 3   0   IS-M: Unit of Measure.for the Totalled Sub Ad Specs Width TJH57
70 HOEHETMOT HOEHETMOT GROESSE QUAN 7   3   IS-M: Totalled Heights for Linked Sub Ad Specs  
71 HOEHETMEH HOEHETMEH ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Sub Ad Spec Height Totals TJH61
72 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
73 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy JJT179
74 TEXTSPITZE TEXTSPITZE TEXT25 CHAR 25   0   IS-M: Ad Text Header  
75 ABW_TELLND ABW_TELLND LAND1 CHAR 3   0   IS-M: Alternative International Dialing Code for Ad Spec T005
76 ABW_TELVW ABW_TELVW ISPTELVW CHAR 10   0   IS-M: Alternative Area Code for Ad Spec  
77 ABW_TEL ABW_TEL ISPTEL CHAR 20   0   IS-M: Alternative Telephone Number for Ad Spec  
78 TELEF_ART TELEF_ART TELEF_ART CHAR 2   0   IS-M: Type of telephone number TJHAG
79 BILOZ_ANZ BILOZ_ANZ NUMC2 NUMC 2   0   IS-M: Amount of Artwork Assigned to the Ad Spec  
80 BILOZ_KOMM BILOKOMM TEXT35 CHAR 35   0   IS-M: Comment on Artwork to be Used  
81 XANSCHNITT XANSCHNITT XFELD CHAR 1   0   IS-M: Bled Ad Spec Indicator  
82 XUEBERBUND XUEBERBUND XFELD CHAR 1   0   IS-M: Indicates That The Ad Spec Overlaps Gutter Margin  
83 XCOUPON XCOUPON XFELD CHAR 1   0   IS-M: Ad Spec is a Coupon Advertisement Indicator  
84 COUPON_KNZ COUPON_KNZ TEXT10 CHAR 10   0   IS-M: Coupon Identification Number  
85 COUPON_LGE COUPON_LGE PLAZLAGE CHAR 2   0   IS-M: Position of the Coupon Relative to Ad Spec Position TJJAB
86 KENNZIFFER PAM_KENNZI PAM_KENNZI CHAR 10   0   IS-M: Identification Number  
87 SUJET_NR SUJET_NR TEXT10 CHAR 10   0   IS-M: Subject Number  
88 SERVICENR SERVICENR TEXT10 CHAR 10   0   IS-M: Service Number  
89 MOTEXTINF1 MOTEXTINF1 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
90 MOTEXTINF2 MOTEXTINF2 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
91 MOTEXTINF3 MOTEXTINF3 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
92 MOTEXTINF4 MOTEXTINF4 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
93 .INCLUDE       0   0   IS-M/AM: Ad Spec Status Attributes  
94 XUVMOT XUVMOT XFELD CHAR 1   0   IS-M: "Ad spec data incomplete" indicator  
95 XPRNOTW XPRNOTW XFELD CHAR 1   0   IS-M: Ad Spec Check Required But Not Performed  
96 XPRINHNOTW XPRINHNOTW XFELD CHAR 1   0   IS-M: Content Check Required But Not Performed  
97 XKUNK_NOTW XKUNK_NOTW XFELD CHAR 1   0   IS-M: Customer correction necessary but not performed  
98 XMOTPROD XMOTPROD XFELD CHAR 1   0   IS-M: Ad Spec Technically Complete Indicator  
99 XDIFF_SIZE XDIFF_SIZE XFELD CHAR 1   0   IS-M: Alternative Actual Size  
100 AENVERS_NR AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
101 .INCLUDE       0   0   IS-M/AM: Characteristics for Individual Use (Ad Spec)  
102 MERKMAL0 MERK0_MOT XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Ad Spec)  
103 MERKMAL1 MERK1_MOT XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Ad Spec)  
104 MERKMAL2 MERK2_MOT XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Ad Spec)  
105 MERKMAL3 MERK3_MOT XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Ad Spec)  
106 MERKMAL4 MERK4_MOT XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Ad Spec)  
107 MERKMAL5 MERK5_MOT XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Ad Spec)  
108 MERKMAL6 MERK6_MOT XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Ad Spec)  
109 MERKMAL7 MERK7_MOT XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Ad Spec)  
110 MERKMAL8 MERK8_MOT XFELD CHAR 1   0   IS-M: Characteristic 8 for Individual Use (Ad Spec)  
111 MERKMAL9 MERK9_MOT XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Ad Spec)  
112 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
113 XMOTIVTEXT XMOTIVTEXT XFELD CHAR 1   0   IS-M/AM: Text Exists for the Ad Spec Indicator  
114 RULE_GROUP_CV ISM_RULE_GROUP_CV_AMC ISM_RULE_GROUP_CV_AMC CHAR 20   0   IS-M: Ad Content Validation Rule Group in IS-M/AMC  
115 SORTWORD ISM_SORTWORD CHAR25 CHAR 25   0   Sort Word at Ad Spec Level  
116 XSRTWD_CHNGD_MAN ISM_XSRTWD_CHNGD_MAN XFELD CHAR 1   0   Sort Word - Indicator: Manual Change  
117 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 RJHAMOTVB ABW_TELLND T005 LAND1 REF 1 CN
2 RJHAMOTVB AREA_BLATT TJJ13 AZART_AREA REF 1 CN
3 RJHAMOTVB AREA_UEBER TJJ13 AZART_AREA REF 1 CN
4 RJHAMOTVB AVM_NR JHAK AVM_NR    
5 RJHAMOTVB AZART_AREA TJJ13 AZART_AREA REF 1 CN
6 RJHAMOTVB AZART_FARB TJJ11 AZART_FARB    
7 RJHAMOTVB AZART_FORM TJJ17 AZART_FORM REF 1 CN
8 RJHAMOTVB AZART_GEST TJJ19 AZART_GEST REF 1 CN
9 RJHAMOTVB AZART_SOND TJJ49 AZART_SOND REF 1 CN
10 RJHAMOTVB AZFARB_IST TJJ11 AZART_FARB REF 1 CN
11 RJHAMOTVB BREITETMEH TJH57 ISPEINHEIT REF 1 CN
12 RJHAMOTVB BREITE_IEH TJH57 ISPEINHEIT 1 CN
13 RJHAMOTVB BREITE_SEH TJH57 ISPEINHEIT REF 1 CN
14 RJHAMOTVB BREITE_TEH TJH57 ISPEINHEIT 1 CN
15 RJHAMOTVB COUPON_LGE TJJAB PLAZ_SLAGE REF 1 CN
16 RJHAMOTVB DRVORL_NR JHADRV DRVORL_NR 1 CN
17 RJHAMOTVB GRUNFARBEN TJH33 FARBNAME 1 CN
18 RJHAMOTVB HOEHETMEH TJH61 ISPEINH_H REF 1 CN
19 RJHAMOTVB HOEHE_I_EH TJH61 ISPEINH_H 1 CN
20 RJHAMOTVB HOEHE_S_EH TJH61 ISPEINH_H REF 1 CN
21 RJHAMOTVB HOEHE_T_EH TJH61 ISPEINH_H 1 CN
22 RJHAMOTVB MANDT T000 MANDT    
23 RJHAMOTVB PRODH JJT179 PRODH REF 1 CN
24 RJHAMOTVB RAHMENEINH T006 MSEHI REF 1 CN
25 RJHAMOTVB RAHMENTYP TJH35 RAHMENTYP 1 CN
26 RJHAMOTVB RASTER TJH37 RASTER 1 CN
27 RJHAMOTVB SEITE_FSP TJJ47 SEITE_FSP REF 1 CN
28 RJHAMOTVB TELEF_ART TJHAG TELEF_ART REF 1 CN
29 RJHAMOTVB TMOT_BEZUG JHAMOT MOTIV    
30 RJHAMOTVB TMOT_KENNZ TJH75 TMOT_KENNZ 1 CN
31 RJHAMOTVB TMOT_LAGE TJH77 TMOT_LAGE 1 CN
32 RJHAMOTVB TMOT_UEBER JHAMOT MOTIV REF 1 CN
33 RJHAMOTVB VORL_AVMNR JHAK AVM_NR 1 CN
34 RJHAMOTVB VORL_MOTNR JHAMOT MOTIV 1 CN
35 RJHAMOTVB XHOEHE_ZWI TJHB3 XHOEHE_ZWI REF 1 CN
36 RJHAMOTVB ZUSATZFA1 TJH33 FARBNAME 1 CN
37 RJHAMOTVB ZUSATZFA2 TJH33 FARBNAME 1 CN
38 RJHAMOTVB ZUSATZFA3 TJH33 FARBNAME 1 CN
39 RJHAMOTVB ZUS_BERECH TJH57 ISPEINHEIT 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in