SAP ABAP Table BAPIBUSISM008_AD_SPEC_OL_OUT (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 INTTAB    Structure 
Structure BAPIBUSISM008_AD_SPEC_OL_OUT   Table Relationship Diagram
Short Description IS-M/AM: Online 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 OLMOTIV_NR MAM_OL_MOT NUMC 6   0   IS-M: Order ad spec number (online) JHAMOTO
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 FORMAT_OL FORMAT_ONL FORMAT_ONL CHAR 4   0   IS-M/AM: Format Proposal (Online) TJHOLFMT
9 PLANNED_HEIGHT HOEHE_S GROESSE QUAN 7   3   IS-M: Planned Height of the Ad Spec  
10 PLANNED_HEIGHT_UOM ONL_HOEHE_SEH ONL_HOEHE_SEH UNIT 3   0   IS-M/AM: Unit of Measurement for Height (Online) TJHOLHME
11 PLANNED_HEIGHT_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
12 PLANNED_WIDTH BREITE_S GROESSE QUAN 7   3   IS-M: Planned Ad Spec Width  
13 PLANNED_WIDTH_UOM ISPEINH_OL ISPEINH_OL UNIT 3   0   IS-M/AM: Unit of Measurement for Online Ad Size Field TJHOLBME
14 PLANNED_WIDTH_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
15 AD_SPEC_FILE_SIZE GROESSE_KB ISM_DEC10_3 DEC 10   3   IS-M/AM: File Size for Online Ad Spec  
16 AD_SPEC_FILE_SIZE_UOM GROESSE_UNIT MEINS UNIT 3   0   IS-M/AM: Unit for Physical Ad Spec Size T006
17 AD_SPEC_FILE_SIZE_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
18 LINK_URL LINK_URL TEXT132 CHAR 132   0   IS-M/AM: Target URL for a banner  
19 CLICK_TEXT CLICKTEXT TEXT132 CHAR 132   0   IS-M/AM: Clicktext for an Online Ad Spec  
20 ALTERNATE_TEXT ALTERN_TEXT TEXT132 CHAR 132   0   IS-M/AM: Alternative Text for an Online Ad Spec  
21 SUB_AD_SPEC_INDICATOR TMOT_KENNZ TMOTIV_KE CHAR 6   0   IS-M/AM: Sub ad spec/linked ad specs indicator TJH75
22 SUB_AD_SPEC_NO TMOT_NR NUMC2 NUMC 2   0   IS-M: Position of the Sub Ad Spec Within the Chain  
23 SUB_AD_SPEC_REFERENCE TMOT_BEZUG_OL MAM_OL_MOT NUMC 6   0   IS-M: Ref.to header ad spec in ad spec linking (online) JHAMOTO
24 SUB_AD_SPEC_POSITION TMOT_LAGE MOT_LAGE CHAR 4   0   IS-M: Position of Sub Ad Spec (Relative to Header Ad Spec) TJH77
25 SUB_AD_SPEC_POSITION_COMMENT TMOT_KOMM TEXT30 CHAR 30   0   IS-M: Comment on location of sub ad spec  
26 AD_SPEC_INCOMPLETE XUVMOT XFELD CHAR 1   0   IS-M: "Ad spec data incomplete" indicator  
27 CHECK_REQUIRED XPRNOTW XFELD CHAR 1   0   IS-M: Ad Spec Check Required But Not Performed  
28 STATUS_CHARACTERISTIC0 MERK0_MOTO XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Online Ad Spec)  
29 STATUS_CHARACTERISTIC1 MERK1_MOTO XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Online Ad Spec)  
30 STATUS_CHARACTERISTIC2 MERK2_MOTO XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Online Ad Spec)  
31 STATUS_CHARACTERISTIC3 MERK3_MOTO XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Online Ad Spec)  
32 STATUS_CHARACTERISTIC4 MERK4_MOTO XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Online Ad Spec)  
33 STATUS_CHARACTERISTIC5 MERK5_MOTO XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Online Ad Spec)  
34 STATUS_CHARACTERISTIC6 MERK6_MOTO XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Online Ad Spec)  
35 STATUS_CHARACTERISTIC7 MERK7_MOTO XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Online Ad Spec)  
36 STATUS_CHARACTERISTIC8 MERK8_MOTO XFELD CHAR 1   0   IS-M: Characteristic 8 for Individual Use (Online Ad Spec)  
37 STATUS_CHARACTERISTIC9 MERK9_MOTO XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Online Ad Spec)  
38 CANCELLED XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
39 STATUS MOTIVSTAT PAM_STATUS CHAR 2   0   IS-M: Ad spec status  
40 TEMPLATE_DOCUMENT_NO VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document JHAK
41 TEMPLATE_AD_SPEC_NO VORL_MOTNR_OL MAM_OL_MOT NUMC 6   0   IS-M: Template ad spec (online) JHAMOTO
42 TEMPLATE_TECHNICAL_AD_SPEC_ID VORL_TECID MOTIVID CHAR 12   0   IS-M: Ad spec template (description in technical system)  
43 CHANGE_VERSION AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BAPIBUSISM008_AD_SPEC_OL_OUT AD_SPEC_FILE_SIZE_UOM T006 MSEHI REF 1 CN
2 BAPIBUSISM008_AD_SPEC_OL_OUT AD_SPEC_FILE_SIZE_UOM_ISO T006I ISOCODE REF 1 CN
3 BAPIBUSISM008_AD_SPEC_OL_OUT AD_SPEC_MASTER_NO JHADRV DRVORL_NR REF 1 CN
4 BAPIBUSISM008_AD_SPEC_OL_OUT AD_SPEC_NO JHAMOTO MOTIV KEY 1 CN
5 BAPIBUSISM008_AD_SPEC_OL_OUT DOCUMENT_NO JHAK AVM_NR KEY 1 CN
6 BAPIBUSISM008_AD_SPEC_OL_OUT FORMAT_OL TJHOLFMT FORMAT_ONL REF 1 CN
7 BAPIBUSISM008_AD_SPEC_OL_OUT PLANNED_HEIGHT_UOM TJHOLHME ONL_HOEHE_SEH REF 1 CN
8 BAPIBUSISM008_AD_SPEC_OL_OUT PLANNED_HEIGHT_UOM_ISO T006I ISOCODE REF 1 CN
9 BAPIBUSISM008_AD_SPEC_OL_OUT PLANNED_WIDTH_UOM TJHOLBME ISPEINH_OL REF 1 CN
10 BAPIBUSISM008_AD_SPEC_OL_OUT PLANNED_WIDTH_UOM_ISO T006I ISOCODE REF 1 CN
11 BAPIBUSISM008_AD_SPEC_OL_OUT PRODUCT_HIERARCHY JJT179 PRODH REF 1 CN
12 BAPIBUSISM008_AD_SPEC_OL_OUT SUB_AD_SPEC_INDICATOR TJH75 TMOT_KENNZ REF 1 CN
13 BAPIBUSISM008_AD_SPEC_OL_OUT SUB_AD_SPEC_POSITION TJH77 TMOT_LAGE REF 1 CN
14 BAPIBUSISM008_AD_SPEC_OL_OUT SUB_AD_SPEC_REFERENCE JHAMOTO MOTIV REF 1 CN
15 BAPIBUSISM008_AD_SPEC_OL_OUT TEMPLATE_AD_SPEC_NO JHAMOTO MOTIV REF 1 CN
16 BAPIBUSISM008_AD_SPEC_OL_OUT TEMPLATE_DOCUMENT_NO JHAK AVM_NR REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 464