SAP ABAP View V_JSBW_PROM (IS-M/SD: BW View for Reading Promotion Data on Subs. Order)

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

View Type	D	Database View
Database View	V_JSBW_PROM
Short Description	IS-M/SD: BW View for Reading Promotion Data on Subs. Order
Root table	JKAK	Sales Order Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKAK	JKAK
2	JKAP
3	JKPROM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAP	MANDT	JL	EQ				0	0
2	JKAK	MANDT	JR	EQ			AND	0	0
3	JKAP	VBELN	JL	EQ				0	0
4	JKAK	VBELN	JR	EQ			AND	0	0
5	JKPROM	MANDT	JL	EQ				0	0
6	JKAK	MANDT	JR	EQ			AND	0	0
7	JKPROM	VBELN	JL	EQ				0	0
8	JKAP	VBELN	JR	EQ			AND	0	0
9	JKPROM	POSNR	JL	EQ				0	0
10	JKAP	POSNR	JR	EQ			AND	0	0
11	JKAK	VBTYP		EQ	'C'		AND	0	0
12	JKAK	TRVOG		EQ	'0'		AND	0	0
13	JKAK	AUARTGRP		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKAK	MANDT		☐	MANDT	☐	Client
2	VBELN	JKAK	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
4	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
5	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
6	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
7	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
8	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
9	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
10	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
11	PVA	JKAP	PVA		☐	PVA	☐	Edition
12	KUENDGRD	JKAP	KUENDGRD		☐	KUENDGRD	☐	Reason for end of delivery
13	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
14	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
15	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
16	VBELN_VL	JKAP	VBELN_VL		☐	AVNR_VL	☐	Reference Document
17	POSNR_VL	JKAP	POSNR_VL		☐	APNR_VL	☐	Reference Document Item
18	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
19	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
20	XMAINSPLIT	JKAP	XMAINSPLIT		☐	XMAINSPLIT	☐	Item for this Alternating Add. Element is a Main Sub-Item
21	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
22	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
23	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
24	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
25	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
26	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
27	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
28	CAMPAIGN	JKAP	CAMPAIGN		☐	ISM_MARKETING_CAMPAIGN	☐	IS-M: Marketing Campaign
29	PROMNR	JKPROM	PROMNR		☐	JPROMNR	☐	Sales order introduction
30	WERBEART	JKPROM	WERBEART		☐	WERBEART	☐	Sales Source
31	WERBEAKT	JKPROM	WERBEAKT		☐	WERBEAKT	☐	Sales Promotion
32	GUELTIGVON	JKPROM	GUELTIGVON		☐	WERBVONDT	☐	Start of Validity of Campaign Framework
33	XAQUISITION	JKPROM	XAQUISITION		☐	XAQUISITION	☐	IS-M/SD: Indicator - first introduction record
34	WERBTRAEG	JKPROM	WERBTRAEG		☐	WERBTRAEG	☐	Advertising Medium
35	MINDBEZUG	JKPROM	MINDBEZUG		☐	MINDBEZUG	☐	Minimum Length of Subscription
36	MINDBEZEIN	JKPROM	MINDBEZEIN		☐	MINDBEZEIN	☐	Time Unit for Minimum Length of Subscription
37	LIEFUNTMAX	JKPROM	LIEFUNTMAX		☐	LIEFUNTMAX	☐	Maximum Delivery Suspension
38	LIEFUMXEIN	JKPROM	LIEFUMXEIN		☐	LIEFUMXEIN	☐	Time unit for maximum delivery suspension
39	GPRECH	JKPROM	GPRECH		☐	GPRECH	☐	IS-M: Researcher
40	VSGRCHEUR	JKPROM	VSGRCHEUR		☐	VSGRCHEUR	☐	Researcher's Service Company
41	XRECHERZ	JKPROM	XRECHERZ		☐	XRECHERZ	☐	IS-M: Research generated
42	KONTAKTNR	JKPROM	KONTAKTNR		☐	KONTAKTNR	☐	IS-M: Business Partner Sales Activity
43	POSNR_BASE	JKPROM	POSNR_BASE		☐	APNR	☐	Sales Order Item
44	CYCLENR_BASE	JKPROM	CYCLENR_BASE		☐	CYCLENR	☐	IS-M/SD: Billing Cycle Number
45	EVENT	JKPROM	EVENT		☐	JK_EVENT	☐	IS-M/SD: Event in order processing
46	ERFUSER	JKPROM	ERFUSER		☐	ERFUSER	☐	Created By
47	ERFDATE	JKPROM	ERFDATE		☐	ERFDATE	☐	Created On
48	ERFTIME	JKPROM	ERFTIME		☐	ERFTIME	☐	Time Created
49	AENUSER	JKPROM	AENUSER		☐	AENUSER	☐	Last Changed By
50	AENDATE	JKPROM	AENDATE		☐	AENDATE	☐	Date of Last Change
51	AENTIME	JKPROM	AENTIME		☐	AENTIME	☐	Time of Last Change

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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