SAP ABAP Table JHAMOTO (IS-M/AM: Online 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 JHAMOTO   Table Relationship Diagram
Short Description IS-M/AM: Online 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 OLMOTIV_NR MAM_OL_MOT NUMC 6   0   IS-M: Order ad spec number (online)  
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_OL MAM_OL_MOT NUMC 6   0   IS-M: Template ad spec (online) JHAMOTO
9 VORL_TECID VORL_TECID MOTIVID CHAR 12   0   IS-M: Ad spec template (description in technical system)  
10 HOEHE_S HOEHE_S GROESSE QUAN 7   3   IS-M: Planned Height of the Ad Spec  
11 HOEHE_S_EH ONL_HOEHE_SEH ONL_HOEHE_SEH UNIT 3   0   IS-M/AM: Unit of Measurement for Height (Online) TJHOLHME
12 BREITE_S BREITE_S GROESSE QUAN 7   3   IS-M: Planned Ad Spec Width  
13 BREITE_SEH ISPEINH_OL ISPEINH_OL UNIT 3   0   IS-M/AM: Unit of Measurement for Online Ad Size Field TJHOLBME
14 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
15 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy JJT179
16 FORMAT_ONL FORMAT_ONL FORMAT_ONL CHAR 4   0   IS-M/AM: Format Proposal (Online) TJHOLFMT
17 LINK_URL LINK_URL TEXT132 CHAR 132   0   IS-M/AM: Target URL for a banner  
18 GROESSE GROESSE_KB ISM_DEC10_3 DEC 10   3   IS-M/AM: File Size for Online Ad Spec  
19 GROESSE_UNIT GROESSE_UNIT MEINS UNIT 3   0   IS-M/AM: Unit for Physical Ad Spec Size T006
20 CLICK_TEXT CLICKTEXT TEXT132 CHAR 132   0   IS-M/AM: Clicktext for an Online Ad Spec  
21 ALTERN_TEXT ALTERN_TEXT TEXT132 CHAR 132   0   IS-M/AM: Alternative Text for an Online Ad Spec  
22 DRVORL_NR DRVORL_NR DRVORL_NR NUMC 6   0   IS-M: Ad Spec Master JHADRV
23 AENVERS_NR_OL AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
24 XMOTIVTEXT XMOTIVTEXT XFELD CHAR 1   0   IS-M/AM: Text Exists for the Ad Spec Indicator  
25 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
26 .INCLUDE       0   0   IS-M/AM: Status Attributes for Online Ad Spec  
27 XUVMOT XUVMOT XFELD CHAR 1   0   IS-M: "Ad spec data incomplete" indicator  
28 XPRNOTW XPRNOTW XFELD CHAR 1   0   IS-M: Ad Spec Check Required But Not Performed  
29 .INCLUDE       0   0   IS-M/AM: Characteristics for Individual Use (Online Ad Spec)  
30 MERKMAL0 MERK0_MOTO XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Online Ad Spec)  
31 MERKMAL1 MERK1_MOTO XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Online Ad Spec)  
32 MERKMAL2 MERK2_MOTO XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Online Ad Spec)  
33 MERKMAL3 MERK3_MOTO XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Online Ad Spec)  
34 MERKMAL4 MERK4_MOTO XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Online Ad Spec)  
35 MERKMAL5 MERK5_MOTO XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Online Ad Spec)  
36 MERKMAL6 MERK6_MOTO XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Online Ad Spec)  
37 MERKMAL7 MERK7_MOTO XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Online Ad Spec)  
38 MERKMAL8 MERK8_MOTO XFELD CHAR 1   0   IS-M: Characteristic 8 for Individual Use (Online Ad Spec)  
39 MERKMAL9 MERK9_MOTO XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Online Ad Spec)  
40 .INCLUDE       0   0   IS-M/AM: Include for Sub Ad Spec/Linking Attributes (Online)  
41 TMOT_KENNZ TMOT_KENNZ TMOTIV_KE CHAR 6   0   IS-M/AM: Sub ad spec/linked ad specs indicator TJH75
42 TMOT_NR TMOT_NR NUMC2 NUMC 2   0   IS-M: Position of the Sub Ad Spec Within the Chain  
43 TMOT_ANZ TMOT_ANZ NUM02 NUMC 2   0   IS-M: Number of sub ad specs in an ad spec chain  
44 TMOT_BEZUG TMOT_BEZUG_OL MAM_OL_MOT NUMC 6   0   IS-M: Ref.to header ad spec in ad spec linking (online) JHAMOTO
45 TMOT_LAGE TMOT_LAGE MOT_LAGE CHAR 4   0   IS-M: Position of Sub Ad Spec (Relative to Header Ad Spec) TJH77
46 TMOT_KOMM TMOT_KOMM TEXT30 CHAR 30   0   IS-M: Comment on location of sub ad spec  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHAMOTO AVM_NR JHAK AVM_NR KEY 1 CN
2 JHAMOTO BREITE_SEH TJHOLBME ISPEINH_OL    
3 JHAMOTO DRVORL_NR JHADRV DRVORL_NR REF 1 CN
4 JHAMOTO FORMAT_ONL TJHOLFMT FORMAT_ONL REF 1 CN
5 JHAMOTO GROESSE_UNIT T006 MSEHI    
6 JHAMOTO HOEHE_S_EH TJHOLHME ONL_HOEHE_SEH    
7 JHAMOTO MANDT T000 MANDT KEY 1 CN
8 JHAMOTO PRODH JJT179 PRODH    
9 JHAMOTO TMOT_BEZUG JHAMOTO MOTIV REF    
10 JHAMOTO TMOT_KENNZ TJH75 TMOT_KENNZ REF 1 CN
11 JHAMOTO TMOT_LAGE TJH77 TMOT_LAGE REF 1 CN
12 JHAMOTO VORL_AVMNR JHAK AVM_NR 1 CN
13 JHAMOTO VORL_MOTNR JHAMOTO MOTIV    
History
Last changed by/on SAP  20130529 
SAP Release Created in