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