SAP ABAP Table BAPIBUSISM008_AD_SPEC_AD_OUT (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 INTTAB    Structure 
Structure BAPIBUSISM008_AD_SPEC_AD_OUT   Table Relationship Diagram
Short Description IS-M/AM: Ad Spec    
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 DOCUMENT_NO AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number JHAK
2 AD_SPEC_NO MOTIV_NR PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Number (Ad) JHAMOT
3 TECHNICAL_AD_SPEC_ID MOTIVID MOTIVID CHAR 12   0   IS-M: Assigned ad spec/ad spec file in technical system  
4 AD_SPEC_MASTER_NO DRVORL_NR DRVORL_NR NUMC 6   0   IS-M: Ad Spec Master JHADRV
5 AD_SPEC_NOTE MOTIVNOTIZ TEXT50 CHAR 50   0   IS-M: Note for Ad Spec Design  
6 KEYWORD STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
7 PRODUCT_HIERARCHY J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy JJT179
8 TEXTHEADER TEXTSPITZE TEXT25 CHAR 25   0   IS-M: Ad Text Header  
9 AD_SPECIAL_HANDLING AZART_SOND AZART_SOND CHAR 2   0   IS-M: Ad Type - Special Handling Type TJJ49
10 AD_SPECIAL_HANDLING_COMMENT ASOND_KOMM TEXT60 CHAR 60   0   IS-M: Comment for Special Ad Handling  
11 AD_DESIGN_TYPE AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
12 AD_SHAPE AZART_FORM AZART_FORM CHAR 4   0   IS-M: Shape Ad Type TJJ17
13 AD_FIXED_FORMAT AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions TJJ13
14 AD_FIXED_FORMAT_GUTTER_BLEED AREA_UEBER AZART_AREA CHAR 4   0   IS-M: Gutter Bleed Format from Format Proposal Hierarchy TJJ13
15 AD_FIXED_FORMAT_HIER_END_NODE AREA_BLATT AZART_AREA CHAR 4   0   IS-M: End Node Format in Format Proposal Hierarchy TJJ13
16 AD_SPEC_LEFT_HAND XMOTLINKS XFELD CHAR 1   0   IS-M: Ad spec is located on left-hand side of page indicator  
17 AD_SPEC_RIGHT_HAND XMOTRECHTS XFELD CHAR 1   0   IS-M: Ad spec located on right-hand side of page indicator  
18 PLANNED_WIDTH BREITE_S GROESSE QUAN 7   3   IS-M: Planned Ad Spec Width  
19 PLANNED_WIDTH_UOM BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
20 PLANNED_WIDTH_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
21 PLANNED_HEIGHT HOEHE_S GROESSE QUAN 7   3   IS-M: Planned Height of the Ad Spec  
22 PLANNED_HEIGHT_UOM ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
23 PLANNED_HEIGHT_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
24 ACTUAL_WIDTH BREITE_I GROESSE QUAN 7   3   IS-M: Actual Ad Spec Width  
25 ACTUAL_WIDTH_UOM BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
26 ACTUAL_WIDTH_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
27 ACTUAL_HEIGHT HOEHE_I GROESSE QUAN 7   3   IS-M: Actual height of the ad spec  
28 ACTUAL_HEIGHT_UOM ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
29 ACTUAL_HEIGHT_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
30 TECHNICAL_WIDTH BREITE_T GROESSE QUAN 7   3   IS-M: Technical Width Specification  
31 TECHNICAL_WIDTH_UOM BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
32 TECHNICAL_WIDTH_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
33 TECHNICAL_HEIGHT HOEHE_T GROESSE QUAN 7   3   IS-M: Technical height  
34 TECHNICAL_HEIGHT_UOM ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
35 TECHNICAL_HEIGHT_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
36 ADD_CALCULATION_QTY BER_MENGE GROESSE QUAN 7   3   IS-M: Number of Additional Ad Spec Calculation Units  
37 ADD_CALCULATION_QTY_UOM MEINH_ZUS ISPEINHEIT UNIT 3   0   IS-M: Additional Unit of Measure for Settlement TJH57
38 ADD_CALCULATION_QTY_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
39 PAGE_COLUMN_FORMAT SEITE_FSP SEITE_FSP CHAR 4   0   IS-M: Page/column format TJJ47
40 HEIGHT_INDICATOR XHOEHE_ZWI XHOEHE_ZWI CHAR 1   0   IS-M: Height Indicator TJHB3
41 BLEED XANSCHNITT XFELD CHAR 1   0   IS-M: Bled Ad Spec Indicator  
42 GUTTER_BLEED XUEBERBUND XFELD CHAR 1   0   IS-M: Indicates That The Ad Spec Overlaps Gutter Margin  
43 PLANNED_AD_COLOR_SCHEME AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
44 ACTUAL_AD_COLOR_SCHEME AZFARB_IST AZART_FARB CHAR 4   0   IS-M: Actual Color Scheme Ad Type TJJ11
45 BASICCOLOR ISM_BASIC_COLOR FARBNAME CHAR 8   0   IS-M: Description of the Primary Color TJH33
46 ADD_COLOR1 ISM_ADD_COLOR FARBNAME CHAR 8   0   IS-M: Description of Additional Color TJH33
47 ADD_COLOR2 ISM_ADD_COLOR FARBNAME CHAR 8   0   IS-M: Description of Additional Color TJH33
48 ADD_COLOR3 ISM_ADD_COLOR FARBNAME CHAR 8   0   IS-M: Description of Additional Color TJH33
49 ADD_COLOR_CONSTRUCTABLE XSCHMFAAUF XFELD CHAR 1   0   IS-M: Indicator: Additional Color Can be Created Using 4C  
50 COLOR_COMMENT FARBKOM_I TEXT34 CHAR 34   0   IS-M: Color Comment for Ad/Ad Spec  
51 TYPOGRAPHY TYPO_NR TYPONR CHAR 8   0   IS-M: Typography Number  
52 BORDER_TYPE RAHMENTYP RAHMENTYP CHAR 8   0   IS-M: Border Type TJH35
53 BORDER_WIDTH RAHMENSTAE NUM2 NUMC 2   0   IS-M: Border Width  
54 BORDER_WIDTH_UOM RAHMENEINH MEINS UNIT 3   0   IS-M: Unit of measurement for border width T006
55 BORDER_WIDTH_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
56 REVERSED INVERSKNZ XFELD CHAR 1   0   IS-M: Reversed Indicator  
57 GRID_SPACING RASTERUNG RASTERUNG CHAR 2   0   IS-M: Grid Spacing TJH37
58 COUPON XCOUPON XFELD CHAR 1   0   IS-M: Ad Spec is a Coupon Advertisement Indicator  
59 COUPON_ID_NO COUPON_KNZ TEXT10 CHAR 10   0   IS-M: Coupon Identification Number  
60 COUPON_POSITION COUPON_LGE PLAZLAGE CHAR 2   0   IS-M: Position of the Coupon Relative to Ad Spec Position TJJAB
61 ID_NO PAM_KENNZI PAM_KENNZI CHAR 10   0   IS-M: Identification Number  
62 SUJET_NO SUJET_NR TEXT10 CHAR 10   0   IS-M: Subject Number  
63 SERVICE_NO SERVICENR TEXT10 CHAR 10   0   IS-M: Service Number  
64 ALT_TELEPHONE_IDC ABW_TELLND LAND1 CHAR 3   0   IS-M: Alternative International Dialing Code for Ad Spec T005
65 ALT_TELEPHONE_IDC_ISO ABW_TELLND_ISO INTCA CHAR 2   0   IS-M: ISO Code of Alternative IDC for Ad Spec  
66 ALT_TELEPHONE_AREA_CODE ABW_TELVW ISPTELVW CHAR 10   0   IS-M: Alternative Area Code for Ad Spec  
67 ALT_TELEPHONE_NO ABW_TEL ISPTEL CHAR 20   0   IS-M: Alternative Telephone Number for Ad Spec  
68 ALT_TELEPHONE_TYPE TELEF_ART TELEF_ART CHAR 2   0   IS-M: Type of telephone number TJHAG
69 ARTWORK_COMMENT BILOKOMM TEXT35 CHAR 35   0   IS-M: Comment on Artwork to be Used  
70 SUB_AD_SPEC_INDICATOR TMOT_KENNZ TMOTIV_KE CHAR 6   0   IS-M/AM: Sub ad spec/linked ad specs indicator TJH75
71 SUB_AD_SPEC_NO TMOT_NR NUMC2 NUMC 2   0   IS-M: Position of the Sub Ad Spec Within the Chain  
72 SUB_AD_SPEC_REFERENCE TMOT_BEZUG PAM_MOTIV NUMC 6   0   IS-M: Reference to header ad spec for linked ad specs JHAMOT
73 SUB_AD_SPEC_POSITION TMOT_LAGE MOT_LAGE CHAR 4   0   IS-M: Position of Sub Ad Spec (Relative to Header Ad Spec) TJH77
74 SUB_AD_SPEC_POSITION_COMMENT TMOT_KOMM TEXT30 CHAR 30   0   IS-M: Comment on location of sub ad spec  
75 SUB_AD_SPEC_GUTTER_BLEED TMOT_UEBER PAM_MOTIV NUMC 6   0   IS-M: Assigned Sub Ad Spec for Gutter Bleed Formats JHAMOT
76 ADD_INFORMATION1 MOTEXTINF1 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
77 ADD_INFORMATION2 MOTEXTINF2 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
78 ADD_INFORMATION3 MOTEXTINF3 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
79 ADD_INFORMATION4 MOTEXTINF4 CHAR30 CHAR 30   0   IS-M: Freely Definable Additional Information on Ad Spec  
80 AD_SPEC_INCOMPLETE XUVMOT XFELD CHAR 1   0   IS-M: "Ad spec data incomplete" indicator  
81 CHECK_REQUIRED XPRNOTW XFELD CHAR 1   0   IS-M: Ad Spec Check Required But Not Performed  
82 CONTENT_CHECK_REQUIRED XPRINHNOTW XFELD CHAR 1   0   IS-M: Content Check Required But Not Performed  
83 CUSTOMER_CORRECTION_REQUIRED XKUNK_NOTW XFELD CHAR 1   0   IS-M: Customer correction necessary but not performed  
84 TECHNICALLY_COMPLETE XMOTPROD XFELD CHAR 1   0   IS-M: Ad Spec Technically Complete Indicator  
85 ALTERNATE_ACTUAL_SIZE XDIFF_SIZE XFELD CHAR 1   0   IS-M: Alternative Actual Size  
86 STATUS_CHARACTERISTIC0 MERK0_MOT XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Ad Spec)  
87 STATUS_CHARACTERISTIC1 MERK1_MOT XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Ad Spec)  
88 STATUS_CHARACTERISTIC2 MERK2_MOT XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Ad Spec)  
89 STATUS_CHARACTERISTIC3 MERK3_MOT XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Ad Spec)  
90 STATUS_CHARACTERISTIC4 MERK4_MOT XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Ad Spec)  
91 STATUS_CHARACTERISTIC5 MERK5_MOT XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Ad Spec)  
92 STATUS_CHARACTERISTIC6 MERK6_MOT XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Ad Spec)  
93 STATUS_CHARACTERISTIC7 MERK7_MOT XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Ad Spec)  
94 STATUS_CHARACTERISTIC8 MERK8_MOT XFELD CHAR 1   0   IS-M: Characteristic 8 for Individual Use (Ad Spec)  
95 STATUS_CHARACTERISTIC9 MERK9_MOT XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Ad Spec)  
96 CANCELLED XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
97 STATUS MOTIVSTAT PAM_STATUS CHAR 2   0   IS-M: Ad spec status  
98 TEMPLATE_DOCUMENT_NO VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document JHAK
99 TEMPLATE_AD_SPEC_NO VORL_MOTNR PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Template (Ad) JHAMOT
100 TEMPLATE_TECHNICAL_AD_SPEC_ID VORL_TECID MOTIVID CHAR 12   0   IS-M: Ad spec template (description in technical system)  
101 CHANGE_VERSION AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
102 STYLE ISM_AMC_STYLE ISM_AMC_STYLE CHAR 30   0   IS-M: Style for IS-M/AMC  
103 TEMPLATE ISM_AMC_TEMPLATE ISM_AMC_TEMPLATE CHAR 30   0   IS-M: Template for IS-M/AMC  
104 SORTWORD_ADSPEC_LEVEL ISM_SORTWORD CHAR25 CHAR 25   0   Sort Word at Ad Spec Level  
105 XSORTWORD_CHANGED 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 BAPIBUSISM008_AD_SPEC_AD_OUT ACTUAL_AD_COLOR_SCHEME TJJ11 AZART_FARB REF 1 CN
2 BAPIBUSISM008_AD_SPEC_AD_OUT ACTUAL_HEIGHT_UOM TJH61 ISPEINH_H REF 1 CN
3 BAPIBUSISM008_AD_SPEC_AD_OUT ACTUAL_HEIGHT_UOM_ISO T006I ISOCODE REF 1 CN
4 BAPIBUSISM008_AD_SPEC_AD_OUT ACTUAL_WIDTH_UOM TJH57 ISPEINHEIT REF 1 CN
5 BAPIBUSISM008_AD_SPEC_AD_OUT ACTUAL_WIDTH_UOM_ISO T006I ISOCODE REF 1 CN
6 BAPIBUSISM008_AD_SPEC_AD_OUT ADD_CALCULATION_QTY_UOM TJH57 ISPEINHEIT REF 1 CN
7 BAPIBUSISM008_AD_SPEC_AD_OUT ADD_CALCULATION_QTY_UOM_ISO T006I ISOCODE REF 1 CN
8 BAPIBUSISM008_AD_SPEC_AD_OUT ADD_COLOR1 TJH33 FARBNAME REF 1 CN
9 BAPIBUSISM008_AD_SPEC_AD_OUT ADD_COLOR2 TJH33 FARBNAME REF 1 CN
10 BAPIBUSISM008_AD_SPEC_AD_OUT ADD_COLOR3 TJH33 FARBNAME REF 1 CN
11 BAPIBUSISM008_AD_SPEC_AD_OUT AD_DESIGN_TYPE TJJ19 AZART_GEST REF 1 CN
12 BAPIBUSISM008_AD_SPEC_AD_OUT AD_FIXED_FORMAT TJJ13 AZART_AREA REF 1 CN
13 BAPIBUSISM008_AD_SPEC_AD_OUT AD_FIXED_FORMAT_GUTTER_BLEED TJJ13 AZART_AREA REF 1 CN
14 BAPIBUSISM008_AD_SPEC_AD_OUT AD_FIXED_FORMAT_HIER_END_NODE TJJ13 AZART_AREA REF 1 CN
15 BAPIBUSISM008_AD_SPEC_AD_OUT AD_SHAPE TJJ17 AZART_FORM REF 1 CN
16 BAPIBUSISM008_AD_SPEC_AD_OUT AD_SPECIAL_HANDLING TJJ49 AZART_SOND REF 1 CN
17 BAPIBUSISM008_AD_SPEC_AD_OUT AD_SPEC_MASTER_NO JHADRV DRVORL_NR REF 1 CN
18 BAPIBUSISM008_AD_SPEC_AD_OUT AD_SPEC_NO JHAMOT MOTIV KEY 1 CN
19 BAPIBUSISM008_AD_SPEC_AD_OUT ALT_TELEPHONE_IDC T005 LAND1 REF 1 CN
20 BAPIBUSISM008_AD_SPEC_AD_OUT ALT_TELEPHONE_TYPE TJHAG TELEF_ART REF 1 CN
21 BAPIBUSISM008_AD_SPEC_AD_OUT BASICCOLOR TJH33 FARBNAME REF 1 CN
22 BAPIBUSISM008_AD_SPEC_AD_OUT BORDER_TYPE TJH35 RAHMENTYP REF 1 CN
23 BAPIBUSISM008_AD_SPEC_AD_OUT BORDER_WIDTH_UOM T006 MSEHI REF 1 CN
24 BAPIBUSISM008_AD_SPEC_AD_OUT BORDER_WIDTH_UOM_ISO T006I ISOCODE REF 1 CN
25 BAPIBUSISM008_AD_SPEC_AD_OUT COUPON_POSITION TJJAB PLAZ_SLAGE REF 1 CN
26 BAPIBUSISM008_AD_SPEC_AD_OUT DOCUMENT_NO JHAK AVM_NR KEY 1 CN
27 BAPIBUSISM008_AD_SPEC_AD_OUT GRID_SPACING TJH37 RASTER REF 1 CN
28 BAPIBUSISM008_AD_SPEC_AD_OUT HEIGHT_INDICATOR TJHB3 XHOEHE_ZWI REF 1 CN
29 BAPIBUSISM008_AD_SPEC_AD_OUT PAGE_COLUMN_FORMAT TJJ47 SEITE_FSP REF 1 CN
30 BAPIBUSISM008_AD_SPEC_AD_OUT PLANNED_AD_COLOR_SCHEME TJJ11 AZART_FARB REF 1 CN
31 BAPIBUSISM008_AD_SPEC_AD_OUT PLANNED_HEIGHT_UOM TJH61 ISPEINH_H REF 1 CN
32 BAPIBUSISM008_AD_SPEC_AD_OUT PLANNED_HEIGHT_UOM_ISO T006I ISOCODE REF 1 CN
33 BAPIBUSISM008_AD_SPEC_AD_OUT PLANNED_WIDTH_UOM TJH57 ISPEINHEIT REF 1 CN
34 BAPIBUSISM008_AD_SPEC_AD_OUT PLANNED_WIDTH_UOM_ISO T006I ISOCODE REF 1 CN
35 BAPIBUSISM008_AD_SPEC_AD_OUT PRODUCT_HIERARCHY JJT179 PRODH REF 1 CN
36 BAPIBUSISM008_AD_SPEC_AD_OUT SUB_AD_SPEC_GUTTER_BLEED JHAMOT MOTIV REF 1 CN
37 BAPIBUSISM008_AD_SPEC_AD_OUT SUB_AD_SPEC_INDICATOR TJH75 TMOT_KENNZ REF 1 CN
38 BAPIBUSISM008_AD_SPEC_AD_OUT SUB_AD_SPEC_POSITION TJH77 TMOT_LAGE REF 1 CN
39 BAPIBUSISM008_AD_SPEC_AD_OUT SUB_AD_SPEC_REFERENCE JHAMOT MOTIV REF 1 CN
40 BAPIBUSISM008_AD_SPEC_AD_OUT TECHNICAL_HEIGHT_UOM TJH61 ISPEINH_H REF 1 CN
41 BAPIBUSISM008_AD_SPEC_AD_OUT TECHNICAL_HEIGHT_UOM_ISO T006I ISOCODE REF 1 CN
42 BAPIBUSISM008_AD_SPEC_AD_OUT TECHNICAL_WIDTH_UOM TJH57 ISPEINHEIT REF 1 CN
43 BAPIBUSISM008_AD_SPEC_AD_OUT TECHNICAL_WIDTH_UOM_ISO T006I ISOCODE REF 1 CN
44 BAPIBUSISM008_AD_SPEC_AD_OUT TEMPLATE_AD_SPEC_NO JHAMOT MOTIV REF 1 CN
45 BAPIBUSISM008_AD_SPEC_AD_OUT TEMPLATE_DOCUMENT_NO JHAK AVM_NR REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 464