SAP ABAP Table BAPIBUSISM008_AD_SPEC_OL (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	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	*
2	AD_SPEC_NO	☐	ISM_TMP_MOTIV_NR	ISM_TMP_MOTIV_NR	CHAR	6	0	IS-M: Temporary Ad Spec Number
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	*
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	PLANNED_WIDTH	☐	BREITE_S	GROESSE	QUAN	7	3	IS-M: Planned Ad Spec Width
9	PLANNED_WIDTH_UOM	☐	ISPEINH_OL	ISPEINH_OL	UNIT	3	0	IS-M/AM: Unit of Measurement for Online Ad Size Field	TJHOLBME
10	PLANNED_WIDTH_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
11	PLANNED_HEIGHT	☐	HOEHE_S	GROESSE	QUAN	7	3	IS-M: Planned Height of the Ad Spec
12	PLANNED_HEIGHT_UOM	☐	ONL_HOEHE_SEH	ONL_HOEHE_SEH	UNIT	3	0	IS-M/AM: Unit of Measurement for Height (Online)	TJHOLHME
13	PLANNED_HEIGHT_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
14	FORMAT_OL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	TJHOLFMT
15	LINK_URL	☐	LINK_URL	TEXT132	CHAR	132	0	IS-M/AM: Target URL for a banner
16	AD_SPEC_FILE_SIZE	☐	GROESSE_KB	ISM_DEC10_3	DEC	10	3	IS-M/AM: File Size for Online Ad Spec
17	AD_SPEC_FILE_SIZE_UOM	☐	GROESSE_UNIT	MEINS	UNIT	3	0	IS-M/AM: Unit for Physical Ad Spec Size	T006
18	AD_SPEC_FILE_SIZE_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
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	☐	ISM_TMP_TMOT_BEZUG	ISM_TMP_MOTIV_NR	CHAR	6	0	IS-M: Reference to Hdr Ad Spec in Linked Ad Spcs (Temporary)
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	CHECK_REQUIRED	☐	XPRNOTW	XFELD	CHAR	1	0	IS-M: Ad Spec Check Required But Not Performed
27	STATUS_CHARACTERISTIC0	☐	MERK0_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Ad Spec)
28	STATUS_CHARACTERISTIC1	☐	MERK1_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Ad Spec)
29	STATUS_CHARACTERISTIC2	☐	MERK2_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Ad Spec)
30	STATUS_CHARACTERISTIC3	☐	MERK3_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Ad Spec)
31	STATUS_CHARACTERISTIC4	☐	MERK4_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Ad Spec)
32	STATUS_CHARACTERISTIC5	☐	MERK5_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Ad Spec)
33	STATUS_CHARACTERISTIC6	☐	MERK6_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Ad Spec)
34	STATUS_CHARACTERISTIC7	☐	MERK7_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Ad Spec)
35	STATUS_CHARACTERISTIC8	☐	MERK8_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Ad Spec)
36	STATUS_CHARACTERISTIC9	☐	MERK9_MOT	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Ad Spec)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIBUSISM008_AD_SPEC_OL	AD_SPEC_FILE_SIZE_UOM	T006	MSEHI
2	BAPIBUSISM008_AD_SPEC_OL	FORMAT_OL	TJHOLFMT	FORMAT_ONL
3	BAPIBUSISM008_AD_SPEC_OL	PLANNED_HEIGHT_UOM	TJHOLHME	ONL_HOEHE_SEH
4	BAPIBUSISM008_AD_SPEC_OL	PLANNED_HEIGHT_UOM_ISO	T006I	ISOCODE	REF	1	CN
5	BAPIBUSISM008_AD_SPEC_OL	PLANNED_WIDTH_UOM	TJHOLBME	ISPEINH_OL
6	BAPIBUSISM008_AD_SPEC_OL	PLANNED_WIDTH_UOM_ISO	T006I	ISOCODE	REF	1	CN
7	BAPIBUSISM008_AD_SPEC_OL	PRODUCT_HIERARCHY	JJT179	PRODH	REF	1	CN
8	BAPIBUSISM008_AD_SPEC_OL	SUB_AD_SPEC_INDICATOR	TJH75	TMOT_KENNZ	REF	1	CN
9	BAPIBUSISM008_AD_SPEC_OL	SUB_AD_SPEC_POSITION	TJH77	TMOT_LAGE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	464