SAP ABAP Table JSBW_ORDER_SPEC (IS-M/AM: BW Structure for zm_order_spec)

Hierarchy

☛

IS-M (Software Component) SAP MEDIA
⤷

IS-M-IS (Application Component) Information System
⤷

JSBW (Package) IS-M: Link to Business Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	JSBW_ORDER_SPEC	Table Relationship Diagram
Short Description	IS-M/AM: BW Structure for zm_order_spec

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	AVM_NR	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
2	GPAG	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
3	POS_ART	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	*
4	BELEGEINH	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	*
5	UR_BELEINH	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	*
6	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
7	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
8	SPART	SPART	SPART	CHAR	2	0	Division	*
9	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
10	AZART_GEST	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	*
11	PSTYV	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
12	AUART	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	*
13	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
14	STAFO	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	*
15	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency	*
16	AVM_HRKNFT	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
17	VERMITTLER	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen
18	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
19	POS_NR	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
20	BRAN_PAM	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
21	KAMPAGNE	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
22	INHK_TECH1	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	*
23	INHK_TLEV1	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
24	INHK_TECH2	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
25	INHK_KFM	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
26	KONKAUS	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
27	BLGMENGE	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
28	DISPMENGE	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
29	BERMENGE	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
30	POSTMENGE	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
31	SI_TYP	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
32	SI_GEWICHT	JSBW_SIGEW	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight for BW
33	MEINHGEWBL	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	*
34	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
35	ANZSEITEN	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
36	XTECH_MIN1	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
37	XTECH_EE	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
38	BNAME	JSBW_B_V	TEXT32	CHAR	32	0	IS-M: Name of Ordering Party JSBW
39	KLEV1	JSBW_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
40	EIN_NR	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	*
41	XSTORNIERT	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
42	STORNOGRND	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
43	STATUSK	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
44	E_BELEINH	E_BE_BASIS	BELEINH	CHAR	10	0	IS-M: Publication Basic Booking Unit	*
45	INHK_EINT	INHK_EINT	INHALTSKOM	CHAR	8	0	IS-M: Schedule line content component	*
46	INHK_PLAZ	INHK_PLAZ	INHALTSKOM	CHAR	8	0	IS-M: Positioning content component	*
47	INHK_PLEV1	JSBW_LE1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
48	INHK_SOVER	JSBW_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
49	E_HEFT	E_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Publication Copy Number
50	S_HEFT	S_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Planned Copy Number
51	AZART_PLAZ	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
52	PLAZIERUNG	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	*
53	XERSCH	XERSCH	XFELD	CHAR	1	0	IS-M: Schedule Line Published Indicator
54	E_TERMIN	E_TERMIN	DATUM	DATS	8	0	IS-M: Publication Date
55	E_TERM_KOM	E_TERM_KOM	DATUM	DATS	8	0	IS-M: Publication Date for Leading BU in Combined BU
56	S_TERMIN	S_TERMIN	DATUM	DATS	8	0	IS-M: Planned Publication Date
57	HEFT_NR	HEFT_NR	PAM_PERIOD	CHAR	14	0	IS-M: Copy Number with Year
58	E_VAVARTYP	E_VAVARTYP	VAVARTYP	CHAR	2	0	IS-M: Issue Variant Type for Schedule Line	*
59	ERSCHDAT	ERSCHDAT	DATUM	DATS	8	0	Publication Date
60	WS_SENDUNG	WS_SENDUNG	WS_SENDUNG	CHAR	4	0	IS-M: Commercial Broadcast	*
61	VRTMENGE_V	VRTMGV_PAM	STMENGE	DEC	9	0	IS-M/AM: Planned Quantity for Distribution Full Booking
62	VRTMENGE	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
63	MOTIV	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	*
64	MOTIVSTAT	MOTIVSTAT	PAM_STATUS	CHAR	2	0	IS-M: Ad spec status
65	AZART_SOND	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
66	AZART_FORM	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	*
67	AZART_AREA	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	*
68	AZART_FARB	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	*
69	HOEHE_I	HOEHE_I	GROESSE	QUAN	7	3	IS-M: Actual height of the ad spec
70	HOEHE_I_EH	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
71	BREITE_I	BREITE_I	GROESSE	QUAN	7	3	IS-M: Actual Ad Spec Width
72	BREITE_IEH	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
73	HOEHE_S	HOEHE_S	GROESSE	QUAN	7	3	IS-M: Planned Height of the Ad Spec
74	HOEHE_S_EH	JSBW_EINHH	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
75	BREITE_S	BREITE_S	GROESSE	QUAN	7	3	IS-M: Planned Ad Spec Width
76	BREITE_SEH	JSBW_B_SEH	ISPEINHEIT	UNIT	3	0	IS-M: Unit of Measure for Width JSBW	*
77	ZUS_BERECH	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	*
78	ZUS_MENGE	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
79	TMOT_KENNZ	TMOT_KENNZ	TMOTIV_KE	CHAR	6	0	IS-M/AM: Sub ad spec/linked ad specs indicator	*
80	BREITETMOT	BREITETMOT	GROESSE	QUAN	7	3	IS-M: Totalled Widths for Linked Sub Ad Specs
81	BREITETMEH	BREITETMEH	ISPEINHEIT	UNIT	3	0	IS-M: Unit of Measure.for the Totalled Sub Ad Specs Width	*
82	HOEHETMOT	HOEHETMOT	GROESSE	QUAN	7	3	IS-M: Totalled Heights for Linked Sub Ad Specs
83	HOEHETMEH	HOEHETMEH	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Sub Ad Spec Height Totals	*
84	PRODH	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
85	SEITE_FSP	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	*
86	AZFARB_IST	AZFARB_IST	AZART_FARB	CHAR	4	0	IS-M: Actual Color Scheme Ad Type	*
87	UPOS_NR	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number
88	BOOK_OL	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	*
89	SELDAT_VON	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
90	SELDAT_BIS	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
91	WS_TIMESLC	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
92	WS_BLOCK	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
93	WS_STELLE	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
94	WERBK_TYP	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
95	WERBK_KNZ	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator