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