SAP ABAP Table JSBW_SD_ORDER_PROM_COMPL (IS-M/SD: BW Structure - Advertising)

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_SD_ORDER_PROM_COMPL	Table Relationship Diagram
Short Description	IS-M/SD: BW Structure - Advertising

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	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
2	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for Subscriptn Order Advertising Bonus
3	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
4	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
5	POSNR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	*
6	PROMNR	☐	JPROMNR	JPROMNR	NUMC	3	0	Sales order introduction	*
7	MATNRWERB	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	*
8	GPNR	☐	GPVERM	GPNR	CHAR	10	0	Business Partner Sales Agent	*
9	XMAINAGENT	☐	XMAINAGENT	XFELD	CHAR	1	0	IS-M/SD: Indicator for Main Sales Agent
10	ZUZAHLBETR	☐	JZUZAHLBET	ISPWV112	CURR	13	2	Additional payment
11	ZUZAHLWAER	☐	JZUZAHLWAE	WAERS	CUKY	5	0	Currency for Additional Payment	*
12	VERSANDDAT	☐	JPRMVRSDAT	DATUM	DATS	8	0	IS-M/SD: Gift Shipping Date
13	VPFLZEITRV	☐	VPFLZEITRV	ISPMNG2	QUAN	2	0	Commitment period for sales agent (subscriber)
14	VPFLZEINHV	☐	VPFLZEINHV	MEINS	UNIT	3	0	Time unit for commitment period	*
15	VPFLBEGINN	☐	VPFLBEGINN	DATUM	DATS	8	0	IS-M/SD: Date on which commitment period begins
16	ERLDATWERB	☐	ERLDATWERB	DATUM	DATS	8	0	Date Advertising Bonus Sent
17	XSAPRSPERR	☐	XSAPRSPERR	XFELD	CHAR	1	0	Block indicator for gift shipping
18	AVNRWERB	☐	AVNRWERB	AVNR	CHAR	10	0	Order Number for Gift 'Free Subscription'	*
19	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for Promotion Data on Subs. Order
20	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	*
21	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	*
22	GUELTIGVON	☐	WERBVONDT	DATUM	DATS	8	0	Start of Validity of Campaign Framework
23	XAQUISITION	☐	XAQUISITION	XFELD	CHAR	1	0	IS-M/SD: Indicator - first introduction record
24	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	*
25	MINDBEZUG	☐	MINDBEZUG	ISPMNG2	QUAN	2	0	Minimum Length of Subscription
26	MINDBEZEIN	☐	MINDBEZEIN	MEINS	UNIT	3	0	Time Unit for Minimum Length of Subscription	*
27	LIEFUNTMAX	☐	LIEFUNTMAX	ISPMNG2	QUAN	2	0	Maximum Delivery Suspension
28	LIEFUMXEIN	☐	LIEFUMXEIN	MEINS	UNIT	3	0	Time unit for maximum delivery suspension	*
29	GPRECH	☐	GPRECH	GPNR	CHAR	10	0	IS-M: Researcher	*
30	VSGRCHEUR	☐	VSGRCHEUR	GPNR	CHAR	10	0	Researcher's Service Company	*
31	XRECHERZ	☐	XRECHERZ	XFELD	CHAR	1	0	IS-M: Research generated
32	KONTAKTNR	☐	KONTAKTNR	ERSATZNR	CHAR	10	0	IS-M: Business Partner Sales Activity	*
33	POSNR_BASE	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
34	CYCLENR_BASE	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
35	EVENT	☐	JK_EVENT	JK_EVENT	CHAR	4	0	IS-M/SD: Event in order processing	*
36	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
37	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
38	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
39	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
40	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
41	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
42	.INCLUDE	☐				0	0	BW: Commission for Introduction Record
43	VERSERVGES	☐	VSGPROV	GPNR	CHAR	10	0	Service company for commission payee	*

History

Last changed by/on	SAP	20050224
SAP Release Created in	471