SAP ABAP Table JSBW_ORDER_BILLING (IS-MAM: BW Structure for IS ZM_ORDER_BILLING)

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_BILLING	Table Relationship Diagram
Short Description	IS-MAM: BW Structure for IS ZM_ORDER_BILLING

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	UR_BELEINH	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	*
5	PREIS_IM	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
6	PREIS_OM	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
7	WAERG	WAERK	WAERS	CUKY	5	0	SD document currency	*
8	BELEGEINH	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
9	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
10	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
11	SPART	SPART	SPART	CHAR	2	0	Division	*
12	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
13	REGULIERER	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	*
14	INSERENT	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
15	XFAKT_EE	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
16	BER_TERMIN	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
17	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
18	AUART	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	*
19	AUGRU	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
20	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
21	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
22	STAFO	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	*
23	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency	*
24	AVM_HRKNFT	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
25	VERMITTLER	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
26	POS_NR	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
27	BRAN_PAM	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
28	KAMPAGNE	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
29	INHK_TECH1	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	*
30	INHK_TLEV1	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
31	INHK_TECH2	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
32	INHK_KFM	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
33	AZART_PLAZ	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
34	KONKAUS	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
35	PRODH	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
36	BLGMENGE	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
37	DISPMENGE	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
38	BERMENGE	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
39	POSTMENGE	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
40	SI_TYP	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
41	SI_GEWICHT	JSBW_SIGEW	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight for BW
42	MEINHGEWBL	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	*
43	MATNR	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	*
44	MENGE	DIEN_MENGE	MENG13	QUAN	13	3	IS-M: Service Quantity
45	DIENTYP	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	*
46	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
47	DIEN_BE	DIEN_BE	BELEINH	CHAR	10	0	IS-M: Service: Assigned Booking Unit	*
48	DIEN_IKO	DIEN_IKO	INHALTSKOM	CHAR	8	0	IS-M: Service: Assigned Content Component	*
49	VRTMENGE	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
50	ANZSEITEN	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
51	XTECH_MIN1	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
52	XTECH_EE	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
53	GPNR_RECH	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
54	PSTYV	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
55	BER_HEFT	E_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Publication Copy Number
56	VAVARTYP	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	*
57	IHKOMP	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	*
58	SEITE_FSP	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	*
59	SEITE_FORM	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	*
60	SMM_SFSP	MENGE_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm
61	SFSP_ABR	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	*
62	WERBK_TYP	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
63	BREITE	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
64	BREITE_EH	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
65	HOEHE	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
66	HOEHE_EH	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
67	ZUS_MENGE	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
68	ZUS_BERECH	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	*
69	MGLME	MENGE_D	MENG13	QUAN	13	3	Quantity
70	LAGME	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
71	AZART_GEST	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	*
72	AZART_FORM	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	*
73	AZART_FARB	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	*
74	AZART_SOND	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
75	KZWI1	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
76	KZWI2	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
77	KZWI3	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
78	KZWI4	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
79	KZWI5	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
80	KZWI6	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
81	XSTORNIERT	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
82	STORNOGRND	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
83	KLEV1	JSBW_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
84	SMM_ABR	JSBW_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm JSBW
85	BNAME	JSBW_B_V	TEXT32	CHAR	32	0	IS-M: Name of Ordering Party JSBW
86	GRUPPABRNR	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
87	BOOK_OL	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	*
88	SELDAT_VON	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
89	SELDAT_BIS	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
90	WERBK_KNZ	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
91	PREIS_AVM1	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
92	PREIS_AVM2	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
93	WS_TIMESLC	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
94	WS_BLOCK	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
95	WS_STELLE	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
96	FORMAT_ONL	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
97	XAEPROV	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
98	MWST_BETR	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount