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