SAP ABAP Table JSBW_ORDER_AGENT (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_ORDER_AGENT	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	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	IS-MAM: BW Structure for IS ZM_ORDER_BILLING
2	AVM_NR	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
3	GPAG	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
4	POS_ART	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	*
5	UR_BELEINH	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	*
6	PREIS_IM	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
7	PREIS_OM	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
8	WAERG	WAERK	WAERS	CUKY	5	0	SD document currency	*
9	BELEGEINH	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
10	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
11	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
12	SPART	SPART	SPART	CHAR	2	0	Division	*
13	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
14	REGULIERER	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	*
15	INSERENT	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
16	XFAKT_EE	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
17	BER_TERMIN	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
18	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
19	AUART	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	*
20	AUGRU	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
21	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
22	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
23	STAFO	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	*
24	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency	*
25	AVM_HRKNFT	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
26	VERMITTLER	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
27	POS_NR	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
28	BRAN_PAM	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
29	KAMPAGNE	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
30	INHK_TECH1	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	*
31	INHK_TLEV1	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
32	INHK_TECH2	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
33	INHK_KFM	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
34	AZART_PLAZ	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
35	KONKAUS	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
36	PRODH	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
37	BLGMENGE	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
38	DISPMENGE	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
39	BERMENGE	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
40	POSTMENGE	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
41	SI_TYP	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
42	SI_GEWICHT	JSBW_SIGEW	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight for BW
43	MEINHGEWBL	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	*
44	MATNR	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	*
45	MENGE	DIEN_MENGE	MENG13	QUAN	13	3	IS-M: Service Quantity
46	DIENTYP	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	*
47	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
48	DIEN_BE	DIEN_BE	BELEINH	CHAR	10	0	IS-M: Service: Assigned Booking Unit	*
49	DIEN_IKO	DIEN_IKO	INHALTSKOM	CHAR	8	0	IS-M: Service: Assigned Content Component	*
50	VRTMENGE	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
51	ANZSEITEN	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
52	XTECH_MIN1	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
53	XTECH_EE	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
54	GPNR_RECH	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
55	PSTYV	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
56	BER_HEFT	E_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Publication Copy Number
57	VAVARTYP	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	*
58	IHKOMP	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	*
59	SEITE_FSP	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	*
60	SEITE_FORM	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	*
61	SMM_SFSP	MENGE_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm
62	SFSP_ABR	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	*
63	WERBK_TYP	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
64	BREITE	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
65	BREITE_EH	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
66	HOEHE	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
67	HOEHE_EH	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
68	ZUS_MENGE	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
69	ZUS_BERECH	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	*
70	MGLME	MENGE_D	MENG13	QUAN	13	3	Quantity
71	LAGME	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
72	AZART_GEST	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	*
73	AZART_FORM	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	*
74	AZART_FARB	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	*
75	AZART_SOND	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
76	KZWI1	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
77	KZWI2	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
78	KZWI3	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
79	KZWI4	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
80	KZWI5	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
81	KZWI6	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
82	XSTORNIERT	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
83	STORNOGRND	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
84	KLEV1	JSBW_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
85	SMM_ABR	JSBW_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm JSBW
86	BNAME	JSBW_B_V	TEXT32	CHAR	32	0	IS-M: Name of Ordering Party JSBW
87	GRUPPABRNR	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
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	WERBK_KNZ	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
92	PREIS_AVM1	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
93	PREIS_AVM2	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
94	WS_TIMESLC	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
95	WS_BLOCK	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
96	WS_STELLE	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
97	FORMAT_ONL	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
98	XAEPROV	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
99	MWST_BETR	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
100	PROVTYP	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
101	VZUONR	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)	*
102	VERM	JSBW_VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID for Screen JSBW	*
103	XAUTO	JAUTOZUGPR	XFELD	CHAR	1	0	IS-M: Assigned automatically Indicator
104	XFOUND	PR_XFOUND	XFELD	CHAR	1	0	Suitable Sales Agent Contract Requirement Found Indicator
105	XMANU	PR_XMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Assigned Manually Indicator
106	CORRCAUSE	JHVZCC	JHVZCC	CHAR	2	0	IS-M/AM: Reason for Correction to Sales Agent Assignment	*
107	PR_BASIS	VPROVBAS	DECV4_3	DEC	7	3	IS-M: Sales Agent Share of Calculation Base (in %)
108	PR_BETRAG	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
109	PRA_XMANU	JHPRAXMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Share was Changed Manually Indicator
110	PROV_SATZ	PROV_SATZ	DECV4_3	DEC	7	3	IS-M: Commission Rate (Percent)
111	PROVM_SATZ	PROV_SATZM	WERTV8	CURR	15	2	IS-M: Commission Amount for mm Commission
112	PROVM_WAER	WAERS	WAERS	CUKY	5	0	Currency Key	*
113	STATUSK	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
114	XPROV_EE	XPROV_EE	XFELD	CHAR	1	0	IS-M: Settlement Performed (Sales Agent Payment) Indicator
115	XUVVZ	XUVVZ_GVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment is Incomplete
116	XZUOINACT	XZUOINACT	XFELD	CHAR	1	0	IS-M: Indicator Sales Agent Assignment is Inactive
117	XDELETED	PR_XDEL	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Deleted Manually Indicator