SAP Table JHAMOT

IS-M/AM: Ad Spec

JHAMOT (IS-M/AM: Ad Spec) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JHAMOT to other SAP tables.

JHAMOT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AVM_NR IS-M/AM: Sales Document Number AVM_NR JHAK CHAR 10 0
MOTIV IS-M: Ad Spec Number (Ad) MOTIV_NR NUMC 6 0
MOTIVSTAT IS-M: Ad spec status MOTIVSTAT CHAR 2 0
01 Cancelled (logically deleted)
10 Created incompletely
20 Complete, reserved
30 Complete, fixed posting, still to be released
40 Complete, fixed posting, released, modifiable
50 Complete, released, partially processed
60 Processing complete, no longer modifiable
99 Initial value
NOTIZ IS-M: Note for Ad Spec Design MOTIVNOTIZ CHAR 50 0
MOTIVID IS-M: Assigned ad spec/ad spec file in technical system MOTIVID CHAR 12 0
VORL_AVMNR IS-M: Order Number of the Preceding Document VORL_AVMNR JHAK CHAR 10 0
VORL_MOTNR IS-M: Ad Spec Template (Ad) VORL_MOTNR JHAMOT NUMC 6 0
VORL_TECID IS-M: Ad spec template (description in technical system) VORL_TECID CHAR 12 0
DRVORL_NR IS-M: Ad Spec Master DRVORL_NR JHADRV NUMC 6 0
AZART_SOND IS-M: Ad Type - Special Handling Type AZART_SOND TJJ49 CHAR 2 0
ASOND_KOMM IS-M: Comment for Special Ad Handling ASOND_KOMM CHAR 60 0
AZART_GEST IS-M: Design Ad Type AZART_GEST TJJ19 CHAR 4 0
AZART_FORM IS-M: Shape Ad Type AZART_FORM TJJ17 CHAR 4 0
AZART_AREA IS-M/AM: Fixed Format Proposal /Ad Dimensions AZART_AREA TJJ13 CHAR 4 0
AREA_UEBER IS-M: Gutter Bleed Format from Format Proposal Hierarchy AREA_UEBER TJJ13 CHAR 4 0
AREA_BLATT IS-M: End Node Format in Format Proposal Hierarchy AREA_BLATT TJJ13 CHAR 4 0
XMOTLINKS IS-M: Ad spec is located on left-hand side of page indicator XMOTLINKS CHAR 1 0
X Yes
NULL No
XMOTRECHTS IS-M: Ad spec located on right-hand side of page indicator XMOTRECHTS CHAR 1 0
X Yes
NULL No
HOEHE_I IS-M: Actual height of the ad spec HOEHE_I QUAN 7 3
HOEHE_I_EH IS-M: Unit of Measure for Height ISPEINH_H TJH61 UNIT 3 0
BREITE_I IS-M: Actual Ad Spec Width BREITE_I QUAN 7 3
BREITE_IEH IS-M/AM: Unit of Measure for Width BREITE_SEH TJH57 UNIT 3 0
HOEHE_T IS-M: Technical height HOEHE_T QUAN 7 3
HOEHE_T_EH IS-M: Unit of Measure for Height ISPEINH_H TJH61 UNIT 3 0
BREITE_T IS-M: Technical Width Specification BREITE_T QUAN 7 3
BREITE_TEH IS-M/AM: Unit of Measure for Width BREITE_SEH TJH57 UNIT 3 0
HOEHE_S IS-M: Planned Height of the Ad Spec HOEHE_S QUAN 7 3
XHOEHE_GR IS-M: Height cannot be entered XHOEHE_GR CHAR 1 0
X Yes
NULL No
HOEHE_S_EH IS-M: Unit of Measure for Height ISPEINH_H TJH61 UNIT 3 0
XHOEHEH_GR IS-M: Unit of Measurement for Height Cannot be Entered XHOEHEH_GR CHAR 1 0
X Yes
NULL No
BREITE_S IS-M: Planned Ad Spec Width BREITE_S QUAN 7 3
XBREITE_GR IS-M: Width Cannot be Entered XBREITE_GR CHAR 1 0
X Yes
NULL No
BREITE_SEH IS-M/AM: Unit of Measure for Width BREITE_SEH TJH57 UNIT 3 0
XBREIEH_GR IS-M: Unit of measurement for width cannot be entered XBREIEH_GR CHAR 1 0
X Yes
NULL No
NUTZFL_ANT IS-M: Share of Technical Area used for Ad Spec NUTZFL_ANT NUMC 3 0
0
ZUS_BERECH IS-M: Additional Unit of Measure for Settlement MEINH_ZUS TJH57 UNIT 3 0
ZUS_MENGE IS-M: Number of Additional Ad Spec Calculation Units BER_MENGE QUAN 7 3
XHOEHE_ZWI IS-M: Height Indicator XHOEHE_ZWI TJHB3 CHAR 1 0
SEITE_FSP IS-M: Page/column format SEITE_FSP TJJ47 CHAR 4 0
AZART_FARB IS-M: Color Scheme Ad Type AZART_FARB TJJ11 CHAR 4 0
AZFARB_IST IS-M: Actual Color Scheme Ad Type AZFARB_IST TJJ11 CHAR 4 0
GRUNFARBEN IS-M: Color Name FARBNAME TJH33 CHAR 8 0
ZUSATZFA1 IS-M: Color Name FARBNAME TJH33 CHAR 8 0
ZUSATZFA2 IS-M: Color Name FARBNAME TJH33 CHAR 8 0
ZUSATZFA3 IS-M: Color Name FARBNAME TJH33 CHAR 8 0
XSCHMFAAUF IS-M: Indicator: Additional Color Can be Created Using 4C XSCHMFAAUF CHAR 1 0
X Yes
NULL No
FARBKOMM IS-M: Color Comment for Ad/Ad Spec FARBKOM_I CHAR 34 0
TYPO_NR IS-M: Typography Number TYPO_NR CHAR 8 0
RAHMENTYP IS-M: Border Type RAHMENTYP TJH35 CHAR 8 0
RAHMENSTAE IS-M: Border Width RAHMENSTAE NUMC 2 0
RAHMENEINH IS-M: Unit of measurement for border width RAHMENEINH T006 UNIT 3 0
INVERSKNZ IS-M: Reversed Indicator INVERSKNZ CHAR 1 0
X Yes
NULL No
RASTER IS-M: Grid Spacing RASTERUNG TJH37 CHAR 2 0
STYLE IS-M: Style for IS-M/AMC ISM_AMC_STYLE CHAR 30 0
TEMPLATE IS-M: Template for IS-M/AMC ISM_AMC_TEMPLATE CHAR 30 0
TMOT_KENNZ IS-M/AM: Sub ad spec/linked ad specs indicator TMOT_KENNZ TJH75 CHAR 6 0
TMOT_NR IS-M: Position of the Sub Ad Spec Within the Chain TMOT_NR NUMC 2 0
TMOT_ANZ IS-M: Number of sub ad specs in an ad spec chain TMOT_ANZ NUMC 2 0
TMOT_BEZUG IS-M: Reference to header ad spec for linked ad specs TMOT_BEZUG JHAMOT NUMC 6 0
TMOT_LAGE IS-M: Position of Sub Ad Spec (Relative to Header Ad Spec) TMOT_LAGE TJH77 CHAR 4 0
TMOT_KOMM IS-M: Comment on location of sub ad spec TMOT_KOMM CHAR 30 0
TMOT_UEBER IS-M: Assigned Sub Ad Spec for Gutter Bleed Formats TMOT_UEBER JHAMOT NUMC 6 0
BREITETMOT IS-M: Totalled Widths for Linked Sub Ad Specs BREITETMOT QUAN 7 3
BREITETMEH IS-M: Unit of Measure.for the Totalled Sub Ad Specs Width BREITETMEH TJH57 UNIT 3 0
HOEHETMOT IS-M: Totalled Heights for Linked Sub Ad Specs HOEHETMOT QUAN 7 3
HOEHETMEH IS-M: Unit of Measure for Sub Ad Spec Height Totals HOEHETMEH TJH61 UNIT 3 0
STICHW IS-M: Keyword STICHW CHAR 40 0
PRODH IS-M/AM: Product Hierarchy J_PRODH JJT179 CHAR 18 0
TEXTSPITZE IS-M: Ad Text Header TEXTSPITZE CHAR 25 0
ABW_TELLND IS-M: Alternative International Dialing Code for Ad Spec ABW_TELLND T005 CHAR 3 0
ABW_TELVW IS-M: Alternative Area Code for Ad Spec ABW_TELVW CHAR 10 0
ABW_TEL IS-M: Alternative Telephone Number for Ad Spec ABW_TEL CHAR 20 0
TELEF_ART IS-M: Type of telephone number TELEF_ART TJHAG CHAR 2 0
BILOZ_ANZ IS-M: Amount of Artwork Assigned to the Ad Spec BILOZ_ANZ NUMC 2 0
BILOZ_KOMM IS-M: Comment on Artwork to be Used BILOKOMM CHAR 35 0
XANSCHNITT IS-M: Bled Ad Spec Indicator XANSCHNITT CHAR 1 0
X Yes
NULL No
XUEBERBUND IS-M: Indicates That The Ad Spec Overlaps Gutter Margin XUEBERBUND CHAR 1 0
X Yes
NULL No
XCOUPON IS-M: Ad Spec is a Coupon Advertisement Indicator XCOUPON CHAR 1 0
X Yes
NULL No
COUPON_KNZ IS-M: Coupon Identification Number COUPON_KNZ CHAR 10 0
COUPON_LGE IS-M: Position of the Coupon Relative to Ad Spec Position COUPON_LGE TJJAB CHAR 2 0
KENNZIFFER IS-M: Identification Number PAM_KENNZI CHAR 10 0
SUJET_NR IS-M: Subject Number SUJET_NR CHAR 10 0
SERVICENR IS-M: Service Number SERVICENR CHAR 10 0
MOTEXTINF1 IS-M: Freely Definable Additional Information on Ad Spec MOTEXTINF1 CHAR 30 0
MOTEXTINF2 IS-M: Freely Definable Additional Information on Ad Spec MOTEXTINF2 CHAR 30 0
MOTEXTINF3 IS-M: Freely Definable Additional Information on Ad Spec MOTEXTINF3 CHAR 30 0
MOTEXTINF4 IS-M: Freely Definable Additional Information on Ad Spec MOTEXTINF4 CHAR 30 0
XUVMOT IS-M: "Ad spec data incomplete" indicator XUVMOT CHAR 1 0
X Yes
NULL No
XPRNOTW IS-M: Ad Spec Check Required But Not Performed XPRNOTW CHAR 1 0
X Yes
NULL No
XPRINHNOTW IS-M: Content Check Required But Not Performed XPRINHNOTW CHAR 1 0
X Yes
NULL No
XKUNK_NOTW IS-M: Customer correction necessary but not performed XKUNK_NOTW CHAR 1 0
X Yes
NULL No
XMOTPROD IS-M: Ad Spec Technically Complete Indicator XMOTPROD CHAR 1 0
X Yes
NULL No
XDIFF_SIZE IS-M: Alternative Actual Size XDIFF_SIZE CHAR 1 0
X Yes
NULL No
AENVERS_NR IS-M: Last Change Version for Technical System AENVERS_NR NUMC 4 0
MERKMAL0 IS-M: Characteristic 0 for Individual Use (Ad Spec) MERK0_MOT CHAR 1 0
X Yes
NULL No
MERKMAL1 IS-M: Characteristic 1 for Individual Use (Ad Spec) MERK1_MOT CHAR 1 0
X Yes
NULL No
MERKMAL2 IS-M: Characteristic 2 for Individual Use (Ad Spec) MERK2_MOT CHAR 1 0
X Yes
NULL No
MERKMAL3 IS-M: Characteristic 3 for Individual Use (Ad Spec) MERK3_MOT CHAR 1 0
X Yes
NULL No
MERKMAL4 IS-M: Characteristic 4 for Individual Use (Ad Spec) MERK4_MOT CHAR 1 0
X Yes
NULL No
MERKMAL5 IS-M: Characteristic 5 for Individual Use (Ad Spec) MERK5_MOT CHAR 1 0
X Yes
NULL No
MERKMAL6 IS-M: Characteristic 6 for Individual Use (Ad Spec) MERK6_MOT CHAR 1 0
X Yes
NULL No
MERKMAL7 IS-M: Characteristic 7 for Individual Use (Ad Spec) MERK7_MOT CHAR 1 0
X Yes
NULL No
MERKMAL8 IS-M: Characteristic 8 for Individual Use (Ad Spec) MERK8_MOT CHAR 1 0
X Yes
NULL No
MERKMAL9 IS-M: Characteristic 9 for Individual Use (Ad Spec) MERK9_MOT CHAR 1 0
X Yes
NULL No
XSTORNIERT IS-M: Canceled Order Object Indicator XSTORNIERT CHAR 1 0
X Yes
NULL No
XMOTIVTEXT IS-M/AM: Text Exists for the Ad Spec Indicator XMOTIVTEXT CHAR 1 0
X Yes
NULL No
RULE_GROUP_CV IS-M: Ad Content Validation Rule Group in IS-M/AMC ISM_RULE_GROUP_CV_AMC CHAR 20 0
SORTWORD Sort Word at Ad Spec Level ISM_SORTWORD CHAR 25 0
XSRTWD_CHNGD_MAN Sort Word - Indicator: Manual Change ISM_XSRTWD_CHNGD_MAN CHAR 1 0
X Yes
NULL No

JHAMOT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHAMOT ABW_TELLND JHAMOT MANDT T005 Countries MANDT
JHAMOT ABW_TELLND JHAMOT ABW_TELLND T005 Countries LAND1
JHAMOT AREA_BLATT JHAMOT AREA_BLATT TJJ13 IS-M/AM: Format Ad Type AZART_AREA
JHAMOT AREA_BLATT JHAMOT MANDT TJJ13 IS-M/AM: Format Ad Type MANDT
JHAMOT AREA_UEBER JHAMOT MANDT TJJ13 IS-M/AM: Format Ad Type MANDT
JHAMOT AREA_UEBER JHAMOT AREA_UEBER TJJ13 IS-M/AM: Format Ad Type AZART_AREA
JHAMOT AVM_NR JHAMOT MANDT JHAK IS-M/AM: Order-Publishing-Media (Header Data) MANDT
JHAMOT AVM_NR JHAMOT AVM_NR JHAK IS-M/AM: Order-Publishing-Media (Header Data) AVM_NR
JHAMOT AZART_AREA JHAMOT MANDT TJJ13 IS-M/AM: Format Ad Type MANDT
JHAMOT AZART_AREA JHAMOT AZART_AREA TJJ13 IS-M/AM: Format Ad Type AZART_AREA
JHAMOT AZART_FARB SYST MANDT TJJ11 IS-M/AM: Color Scheme Ad Type MANDT
JHAMOT AZART_FARB JHAMOT AZART_FARB TJJ11 IS-M/AM: Color Scheme Ad Type AZART_FARB
JHAMOT AZART_FORM JHAMOT MANDT TJJ17 IS-M/AM: Shape Ad Type MANDT
JHAMOT AZART_FORM JHAMOT AZART_FORM TJJ17 IS-M/AM: Shape Ad Type AZART_FORM
JHAMOT AZART_GEST JHAMOT MANDT TJJ19 IS-M/AM: Design Ad Type MANDT
JHAMOT AZART_GEST JHAMOT AZART_GEST TJJ19 IS-M/AM: Design Ad Type AZART_GEST
JHAMOT AZART_SOND JHAMOT MANDT TJJ49 IS-M/AM: Special Handling Ad Type MANDT
JHAMOT AZART_SOND JHAMOT AZART_SOND TJJ49 IS-M/AM: Special Handling Ad Type AZART_SOND
JHAMOT AZFARB_IST SY MANDT TJJ11 IS-M/AM: Color Scheme Ad Type MANDT
JHAMOT AZFARB_IST JHAMOT AZFARB_IST TJJ11 IS-M/AM: Color Scheme Ad Type AZART_FARB
JHAMOT BREITETMEH SY MANDT TJH57 IS-M/AM: Units of Measurement for Ad Size Fields MANDT
JHAMOT BREITETMEH JHAMOT BREITETMEH TJH57 IS-M/AM: Units of Measurement for Ad Size Fields ISPEINHEIT
JHAMOT BREITE_IEH JHAMOT MANDT TJH57 IS-M/AM: Units of Measurement for Ad Size Fields MANDT
JHAMOT BREITE_IEH JHAMOT BREITE_IEH TJH57 IS-M/AM: Units of Measurement for Ad Size Fields ISPEINHEIT
JHAMOT BREITE_SEH SYST MANDT TJH57 IS-M/AM: Units of Measurement for Ad Size Fields MANDT
JHAMOT BREITE_SEH JHAMOT BREITE_SEH TJH57 IS-M/AM: Units of Measurement for Ad Size Fields ISPEINHEIT
JHAMOT BREITE_TEH JHAMOT MANDT TJH57 IS-M/AM: Units of Measurement for Ad Size Fields MANDT
JHAMOT BREITE_TEH JHAMOT BREITE_TEH TJH57 IS-M/AM: Units of Measurement for Ad Size Fields ISPEINHEIT
JHAMOT COUPON_LGE JHAMOT MANDT TJJAB IS-M/AM: Position on Page MANDT
JHAMOT COUPON_LGE JHAMOT COUPON_LGE TJJAB IS-M/AM: Position on Page PLAZ_SLAGE
JHAMOT DRVORL_NR JHAMOT DRVORL_NR JHADRV IS-M/AM: OPM Ad Spec Master DRVORL_NR
JHAMOT DRVORL_NR JHAMOT MANDT JHADRV IS-M/AM: OPM Ad Spec Master MANDT
JHAMOT DRVORL_NR JHAMOT AVM_NR JHADRV IS-M/AM: OPM Ad Spec Master AVM_NR
JHAMOT GRUNFARBEN SYST MANDT TJH33 IS-M/AM: Color Names for Ad Spec MANDT
JHAMOT GRUNFARBEN JHAMOT GRUNFARBEN TJH33 IS-M/AM: Color Names for Ad Spec FARBNAME
JHAMOT HOEHETMEH SY MANDT TJH61 IS-M/AM: Unit of Measure for Height MANDT
JHAMOT HOEHETMEH JHAMOT HOEHETMEH TJH61 IS-M/AM: Unit of Measure for Height ISPEINH_H
JHAMOT HOEHE_I_EH JHAMOT MANDT TJH61 IS-M/AM: Unit of Measure for Height MANDT
JHAMOT HOEHE_I_EH JHAMOT HOEHE_I_EH TJH61 IS-M/AM: Unit of Measure for Height ISPEINH_H
JHAMOT HOEHE_S_EH JHAMOT HOEHE_S_EH TJH61 IS-M/AM: Unit of Measure for Height ISPEINH_H
JHAMOT HOEHE_S_EH JHAMOT MANDT TJH61 IS-M/AM: Unit of Measure for Height MANDT
JHAMOT HOEHE_T_EH JHAMOT MANDT TJH61 IS-M/AM: Unit of Measure for Height MANDT
JHAMOT HOEHE_T_EH JHAMOT HOEHE_T_EH TJH61 IS-M/AM: Unit of Measure for Height ISPEINH_H
JHAMOT MANDT JHAMOT MANDT T000 Clients MANDT
JHAMOT PRODH JHAMOT MANDT JJT179 IS-M/AM: Product Hierarchy MANDT
JHAMOT PRODH JHAMOT PRODH JJT179 IS-M/AM: Product Hierarchy PRODH
JHAMOT RAHMENEINH SY MANDT T006 Units of Measurement MANDT
JHAMOT RAHMENEINH JHAMOT RAHMENEINH T006 Units of Measurement MSEHI
JHAMOT RAHMENTYP SYST MANDT TJH35 IS-M/AM: Border Type for Ad Spec MANDT
JHAMOT RAHMENTYP JHAMOT RAHMENTYP TJH35 IS-M/AM: Border Type for Ad Spec RAHMENTYP
JHAMOT RASTER JHAMOT RASTER TJH37 IS-M/AM: Grid Spacing for Ad Spec RASTER
JHAMOT RASTER SYST MANDT TJH37 IS-M/AM: Grid Spacing for Ad Spec MANDT
JHAMOT SEITE_FSP JHAMOT SEITE_FSP TJJ47 IS-M/AM: Page/Column Format SEITE_FSP
JHAMOT SEITE_FSP JHAMOT MANDT TJJ47 IS-M/AM: Page/Column Format MANDT
JHAMOT TELEF_ART JHAMOT MANDT TJHAG IS-M/AM: Type of Telephone No. MANDT
JHAMOT TELEF_ART JHAMOT TELEF_ART TJHAG IS-M/AM: Type of Telephone No. TELEF_ART
JHAMOT TMOT_BEZUG SYST MANDT JHAMOT IS-M/AM: Ad Spec MANDT
JHAMOT TMOT_BEZUG JHAMOT AVM_NR JHAMOT IS-M/AM: Ad Spec AVM_NR
JHAMOT TMOT_BEZUG JHAMOT TMOT_BEZUG JHAMOT IS-M/AM: Ad Spec MOTIV
JHAMOT TMOT_KENNZ SYST MANDT TJH75 IS-M/AM: Indicator Sub Ad Spec/Linking MANDT
JHAMOT TMOT_KENNZ JHAMOT TMOT_KENNZ TJH75 IS-M/AM: Indicator Sub Ad Spec/Linking TMOT_KENNZ
JHAMOT TMOT_LAGE SYST MANDT TJH77 IS-M/AM: Location of Sub Ad Spec in Relation to Ref.Ad Spec MANDT
JHAMOT TMOT_LAGE JHAMOT TMOT_LAGE TJH77 IS-M/AM: Location of Sub Ad Spec in Relation to Ref.Ad Spec TMOT_LAGE
JHAMOT TMOT_UEBER JHAMOT TMOT_UEBER JHAMOT IS-M/AM: Ad Spec MOTIV
JHAMOT TMOT_UEBER JHAMOT MANDT JHAMOT IS-M/AM: Ad Spec MANDT
JHAMOT TMOT_UEBER JHAMOT AVM_NR JHAMOT IS-M/AM: Ad Spec AVM_NR
JHAMOT VORL_AVMNR JHAMOT MANDT JHAK IS-M/AM: Order-Publishing-Media (Header Data) MANDT
JHAMOT VORL_AVMNR JHAMOT VORL_AVMNR JHAK IS-M/AM: Order-Publishing-Media (Header Data) AVM_NR
JHAMOT VORL_MOTNR JHAMOT MANDT JHAMOT IS-M/AM: Ad Spec MANDT
JHAMOT VORL_MOTNR JHAMOT AVM_NR JHAMOT IS-M/AM: Ad Spec AVM_NR
JHAMOT VORL_MOTNR JHAMOT VORL_MOTNR JHAMOT IS-M/AM: Ad Spec MOTIV
JHAMOT XHOEHE_ZWI JHAMOT XHOEHE_ZWI TJHB3 IS-M/AM: Height Indicator XHOEHE_ZWI
JHAMOT XHOEHE_ZWI JHAMOT MANDT TJHB3 IS-M/AM: Height Indicator MANDT
JHAMOT ZUSATZFA1 SYST MANDT TJH33 IS-M/AM: Color Names for Ad Spec MANDT
JHAMOT ZUSATZFA1 JHAMOT ZUSATZFA1 TJH33 IS-M/AM: Color Names for Ad Spec FARBNAME
JHAMOT ZUSATZFA2 JHAMOT ZUSATZFA2 TJH33 IS-M/AM: Color Names for Ad Spec FARBNAME
JHAMOT ZUSATZFA2 SYST MANDT TJH33 IS-M/AM: Color Names for Ad Spec MANDT
JHAMOT ZUSATZFA3 SYST MANDT TJH33 IS-M/AM: Color Names for Ad Spec MANDT
JHAMOT ZUSATZFA3 JHAMOT ZUSATZFA3 TJH33 IS-M/AM: Color Names for Ad Spec FARBNAME
JHAMOT ZUS_BERECH JHAMOT ZUS_BERECH TJH57 IS-M/AM: Units of Measurement for Ad Size Fields ISPEINHEIT
JHAMOT ZUS_BERECH JHAMOT MANDT TJH57 IS-M/AM: Units of Measurement for Ad Size Fields MANDT