SAP ABAP Table JSBW_AM_COMPL_1 (IS-M/AM: BW Structure for IS 0ME_ISM_AM_COMPL_1)

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	JSBW_AM_COMPL_1	Table Relationship Diagram
Short Description	IS-M/AM: BW Structure for IS 0ME_ISM_AM_COMPL_1

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: BW Structure for IS 0ME_ISM_AM_compl_1
2	REKLAM_NR	☐	REKLAM_NR	REKLAM	CHAR	10	0	IS-M: Complaint number
3	REKL_GPNR	☐	REKL_GPNR	GPNR	CHAR	10	0	IS-M: Complaining Party	*
4	REKL_GPAS	☐	ISM_CP_COMPLAINT	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for Complaining Party	*
5	REKL_DATUM	☐	REKL_DATUM	DATUM	DATS	8	0	IS-M: Complaint Date
6	REKL_GRUND	☐	REKL_GRUND	CHAR4	CHAR	4	0	IS-M: Reason for Complaint
7	REKL_STAT	☐	REKL_STAT	REKL_STAT	CHAR	2	0	IS-M: Complaint status	*
8	WEITERBEAR	☐	WEITERBEAR	USERNAME	CHAR	12	0	IS-M: Subsequent Processor
9	REKL_KOMM	☐	REKL_KOMM	XFELD	CHAR	1	0	IS-M: Comment has been entered for complaint
10	ORDER_LEVEL	☐	ISM_LEVEL_AUF	LEVEL_AUF	CHAR	2	0	IS-M/AM: Sales Document Level
11	.INCLUDE	☐				0	0	IS-M/AM: BW Structure for IS 0ME_ISM_AM_ORDER_1
12	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
13	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
14	GPAG	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
15	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
16	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	*
17	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
18	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
19	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
20	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
21	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
22	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
23	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
24	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
25	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	*
26	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
27	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
28	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
29	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
30	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	*
31	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
32	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
33	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
34	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	*
35	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
36	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
37	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
38	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
39	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
40	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
41	INHK_TECH1	☐	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	*
42	INHK_TLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
43	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
44	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
45	AZART_PLAZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
46	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
47	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
48	BLGMENGE	☐	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
49	DISPMENGE	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
50	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
51	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
52	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
53	SI_GEWICHT	☐	JSBW_SIGEW	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight for BW
54	MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	*
55	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	*
56	MENGE	☐	DIEN_MENGE	MENG13	QUAN	13	3	IS-M: Service Quantity
57	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	*
58	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
59	DIEN_BE	☐	DIEN_BE	BELEINH	CHAR	10	0	IS-M: Service: Assigned Booking Unit	*
60	DIEN_IKO	☐	DIEN_IKO	INHALTSKOM	CHAR	8	0	IS-M: Service: Assigned Content Component	*
61	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
62	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
63	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
64	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
65	GPNR_RECH	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
66	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
67	BER_HEFT	☐	ISM_BER_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Service Creation Copy Number for Settlement
68	VAVARTYP	☐	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	*
69	IHKOMP	☐	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	*
70	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	*
71	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	*
72	SMM_SFSP	☐	JSBW_SMM_SFSP	DECV13_3	DEC	13	3	IS-M/AM: Size in Column mm
73	SFSP_ABR	☐	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	*
74	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
75	BREITE	☐	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
76	BREITE_EH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
77	HOEHE	☐	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
78	HOEHE_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
79	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
80	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	*
81	MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
82	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
83	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	*
84	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	*
85	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	*
86	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
87	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
88	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
89	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
90	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
91	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
92	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
93	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
94	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
95	INHK_KLEV1	☐	JSBW_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
96	SMM_ABR	☐	JSBW_SMM_ABR	DECV13_3	DEC	13	3	IS-M/AM: Size in Column mm JSBW
97	BNAME	☐	JSBW_B_V	TEXT32	CHAR	32	0	IS-M: Name of Ordering Party JSBW
98	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
99	BOOK_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	*
100	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
101	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
102	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
103	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
104	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
105	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
106	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
107	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
108	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
109	XAEPROV	☐	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
110	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
111	IKO_STAT	☐	IKO_STAT	INHALTSKOM	CHAR	8	0	IS-M: Statistical content component	*
112	BEGRP_STAT	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	*
113	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	*
114	STGVB_PAM	☐	STGVB_PAM	STGVB_PAM	CHAR	2	0	IS-M: Statistics Group for Sales Documents	*
115	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
116	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
117	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
118	CAMPAIGN_PSP	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
119	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	*
120	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	*
121	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
122	RESTHSHLT_DATUM	☐	ISM_DELTA_COVERAGE_DATE	DATUM	DATS	8	0	IS-M: Alternative Date for Total Market Coverage
123	COPY_NO_START	☐	ISM_COPY_NO_START	PAM_PERIOD	CHAR	14	0	IS-M/AM: Start of Period for Copy
124	COPY_NO_END	☐	ISM_COPY_NO_END	PAM_PERIOD	CHAR	14	0	IS-M/AM: End of Period for Copy
125	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	*
126	KUKARR_K	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	*
127	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
128	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
129	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
130	MF_BER_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
131	MF_COA_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
132	MF_COA_LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
133	INS_SERIES_RULE	☐	ISM_INSERTION_SERIES_RULE	ISM_INSERTION_SERIES_RULE	CHAR	4	0	IS-M/AM: Series Rule	*
134	INS_SERIES	☐	ISM_INSERTION_SERIES	CHAR4	CHAR	4	0	IS-M/AM: Unique Identification of a Series Found
135	INS_SERIES_NO	☐	ISM_INSERTION_SERIES_NO	NUM4	NUMC	4	0	IS-M/AM: Unique Billing Dataset Number Within a Series
136	.INCLUDE	☐				0	0	IS-M/AM: BW Structure for 0ME_AM_COMPL1_2
137	EIN_NR	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	*
138	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
139	E_BELEINH	☐	E_BE_BASIS	BELEINH	CHAR	10	0	IS-M: Publication Basic Booking Unit	*
140	INHK_EINT	☐	INHK_EINT	INHALTSKOM	CHAR	8	0	IS-M: Schedule line content component	*
141	INHK_PLAZ	☐	INHK_PLAZ	INHALTSKOM	CHAR	8	0	IS-M: Positioning content component	*
142	INHK_PLEV1	☐	JSBW_LE1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
143	INHK_SOVER	☐	JSBW_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
144	E_HEFT	☐	E_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Publication Copy Number
145	S_HEFT	☐	S_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Planned Copy Number
146	PLAZIERUNG	☐	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	*
147	XERSCH	☐	XERSCH	XFELD	CHAR	1	0	IS-M: Schedule Line Published Indicator
148	E_TERMIN	☐	E_TERMIN	DATUM	DATS	8	0	IS-M: Publication Date
149	E_TERM_KOM	☐	E_TERM_KOM	DATUM	DATS	8	0	IS-M: Publication Date for Leading BU in Combined BU
150	S_TERMIN	☐	S_TERMIN	DATUM	DATS	8	0	IS-M: Planned Publication Date
151	HEFT_NR	☐	HEFT_NR	PAM_PERIOD	CHAR	14	0	IS-M: Copy Number with Year
152	E_VAVARTYP	☐	E_VAVARTYP	VAVARTYP	CHAR	2	0	IS-M: Issue Variant Type for Schedule Line	*
153	ERSCHDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
154	WS_SENDUNG	☐	WS_SENDUNG	WS_SENDUNG	CHAR	4	0	IS-M: Commercial Broadcast	*
155	VRTMENGE_V	☐	VRTMGV_PAM	STMENGE	DEC	9	0	IS-M/AM: Planned Quantity for Distribution Full Booking
156	MOTIV	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	*
157	MOTIVSTAT	☐	MOTIVSTAT	PAM_STATUS	CHAR	2	0	IS-M: Ad spec status
158	HOEHE_I	☐	HOEHE_I	GROESSE	QUAN	7	3	IS-M: Actual height of the ad spec
159	HOEHE_I_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
160	BREITE_I	☐	BREITE_I	GROESSE	QUAN	7	3	IS-M: Actual Ad Spec Width
161	BREITE_IEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
162	HOEHE_S	☐	HOEHE_S	GROESSE	QUAN	7	3	IS-M: Planned Height of the Ad Spec
163	HOEHE_S_EH	☐	JSBW_EINHH	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
164	BREITE_S	☐	BREITE_S	GROESSE	QUAN	7	3	IS-M: Planned Ad Spec Width
165	BREITE_SEH	☐	JSBW_B_SEH	ISPEINHEIT	UNIT	3	0	IS-M: Unit of Measure for Width JSBW	*
166	TMOT_KENNZ	☐	TMOT_KENNZ	TMOTIV_KE	CHAR	6	0	IS-M/AM: Sub ad spec/linked ad specs indicator	*
167	BREITETMOT	☐	BREITETMOT	GROESSE	QUAN	7	3	IS-M: Totalled Widths for Linked Sub Ad Specs
168	BREITETMEH	☐	BREITETMEH	ISPEINHEIT	UNIT	3	0	IS-M: Unit of Measure.for the Totalled Sub Ad Specs Width	*
169	HOEHETMOT	☐	HOEHETMOT	GROESSE	QUAN	7	3	IS-M: Totalled Heights for Linked Sub Ad Specs
170	HOEHETMEH	☐	HOEHETMEH	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Sub Ad Spec Height Totals	*
171	AZFARB_IST	☐	AZFARB_IST	AZART_FARB	CHAR	4	0	IS-M: Actual Color Scheme Ad Type	*
172	UPOS_NR	☐	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number
173	MOT_SIZE	☐	MOT_SIZE	MENGE	QUAN	13	3	IS-M: Ad spec size(actual) for update
174	MOT_SIZE_S	☐	MOT_SIZE_S	MENGE	QUAN	13	3	IS-M: Ad spec size (planned) for update
175	MOTSIZE_ME	☐	ISPEINHEIT	ISPEINHEIT	UNIT	3	0	IS-M: Unit of Measurement for Calculating Ad Spec Dimensions	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_AM_COMPL_1	POS_ART	TJH17	AVMPOS_ART	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in