SAP ABAP Table JSBW_AM_ORDER_3 (IS-M/AM: BW Structure for IS ZM_ORDER_agent)

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

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_ORDER_1
2	.INCLUDE	☐				0	0	IS-M/AM: BW Structure for IS 0ME_ISM_AM_ORDER_1
3	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
4	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
5	GPAG	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
6	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
7	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	*
8	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
9	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
10	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
11	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
14	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
15	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
16	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	*
17	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
18	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
19	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
20	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
21	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	*
22	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
23	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
24	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
25	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	*
26	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
27	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
28	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
29	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
30	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
31	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
32	INHK_TECH1	☐	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	*
33	INHK_TLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
34	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
35	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
36	AZART_PLAZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
37	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
38	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
39	BLGMENGE	☐	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
40	DISPMENGE	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
41	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
42	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
43	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
44	SI_GEWICHT	☐	JSBW_SIGEW	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight for BW
45	MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	*
46	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	*
47	MENGE	☐	DIEN_MENGE	MENG13	QUAN	13	3	IS-M: Service Quantity
48	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	*
49	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
50	DIEN_BE	☐	DIEN_BE	BELEINH	CHAR	10	0	IS-M: Service: Assigned Booking Unit	*
51	DIEN_IKO	☐	DIEN_IKO	INHALTSKOM	CHAR	8	0	IS-M: Service: Assigned Content Component	*
52	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
53	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
54	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
55	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
56	GPNR_RECH	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
57	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
58	BER_HEFT	☐	ISM_BER_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Service Creation Copy Number for Settlement
59	VAVARTYP	☐	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	*
60	IHKOMP	☐	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	*
61	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	*
62	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	*
63	SMM_SFSP	☐	JSBW_SMM_SFSP	DECV13_3	DEC	13	3	IS-M/AM: Size in Column mm
64	SFSP_ABR	☐	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	*
65	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
66	BREITE	☐	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
67	BREITE_EH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
68	HOEHE	☐	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
69	HOEHE_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
70	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
71	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	*
72	MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
73	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
74	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	*
75	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	*
76	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	*
77	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
78	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
79	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
80	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
81	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
82	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
83	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
84	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
85	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
86	INHK_KLEV1	☐	JSBW_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
87	SMM_ABR	☐	JSBW_SMM_ABR	DECV13_3	DEC	13	3	IS-M/AM: Size in Column mm JSBW
88	BNAME	☐	JSBW_B_V	TEXT32	CHAR	32	0	IS-M: Name of Ordering Party JSBW
89	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
90	BOOK_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	*
91	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
92	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
93	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
94	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
95	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
96	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
97	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
98	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
99	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
100	XAEPROV	☐	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
101	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
102	IKO_STAT	☐	IKO_STAT	INHALTSKOM	CHAR	8	0	IS-M: Statistical content component	*
103	BEGRP_STAT	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	*
104	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	*
105	STGVB_PAM	☐	STGVB_PAM	STGVB_PAM	CHAR	2	0	IS-M: Statistics Group for Sales Documents	*
106	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
107	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
108	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
109	CAMPAIGN_PSP	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
110	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	*
111	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	*
112	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
113	RESTHSHLT_DATUM	☐	ISM_DELTA_COVERAGE_DATE	DATUM	DATS	8	0	IS-M: Alternative Date for Total Market Coverage
114	COPY_NO_START	☐	ISM_COPY_NO_START	PAM_PERIOD	CHAR	14	0	IS-M/AM: Start of Period for Copy
115	COPY_NO_END	☐	ISM_COPY_NO_END	PAM_PERIOD	CHAR	14	0	IS-M/AM: End of Period for Copy
116	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	*
117	KUKARR_K	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	*
118	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
119	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
120	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
121	MF_BER_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
122	MF_COA_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
123	MF_COA_LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
124	INS_SERIES_RULE	☐	ISM_INSERTION_SERIES_RULE	ISM_INSERTION_SERIES_RULE	CHAR	4	0	IS-M/AM: Series Rule	*
125	INS_SERIES	☐	ISM_INSERTION_SERIES	CHAR4	CHAR	4	0	IS-M/AM: Unique Identification of a Series Found
126	INS_SERIES_NO	☐	ISM_INSERTION_SERIES_NO	NUM4	NUMC	4	0	IS-M/AM: Unique Billing Dataset Number Within a Series
127	.INCLUDE	☐				0	0	IS-MAM: BW Structure for IS 0ME_ISM_AM_ORDER_1 St
128	BW_STICHTAG	☐	BW_STICHTAG	DATUM	DATS	8	0	IS-M/AM: Key Date For BW Key Date Logic
129	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	*
130	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	*
131	PROVTYP	☐	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
132	VZUONR	☐	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)	*
133	VERM	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
134	XAUTO	☐	JAUTOZUGPR	XFELD	CHAR	1	0	IS-M: Assigned automatically Indicator
135	XFOUND	☐	PR_XFOUND	XFELD	CHAR	1	0	Suitable Sales Agent Contract Requirement Found Indicator
136	XMANU	☐	PR_XMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Assigned Manually Indicator
137	CORRCAUSE	☐	JHVZCC	JHVZCC	CHAR	2	0	IS-M/AM: Reason for Correction to Sales Agent Assignment	*
138	PR_BASIS	☐	VPROVBAS	DECV4_3	DEC	7	3	IS-M: Sales Agent Share of Calculation Base (in %)
139	PR_BETRAG	☐	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
140	PRA_XMANU	☐	JHPRAXMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Share was Changed Manually Indicator
141	PROV_SATZ	☐	PROV_SATZ	DECV4_3	DEC	7	3	IS-M: Commission Rate (Percent)
142	PROVM_SATZ	☐	PROV_SATZM	WERTV8	CURR	15	2	IS-M: Commission Amount for mm Commission
143	PROVM_WAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
144	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
145	XPROV_EE	☐	XPROV_EE	XFELD	CHAR	1	0	IS-M: Settlement Performed (Sales Agent Payment) Indicator
146	XUVVZ	☐	XUVVZ_GVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment is Incomplete
147	XZUOINACT	☐	XZUOINACT	XFELD	CHAR	1	0	IS-M: Indicator Sales Agent Assignment is Inactive
148	XDELETED	☐	PR_XDEL	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Deleted Manually Indicator
149	VERMKURZ	☐	JVERMKURZ	JVERMKURZ	CHAR	4	0	IS-M: Media Sales Agent Identification Code for Fast Input

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in