SAP ABAP View JKVWERB (IS-M/SD: Promotion View for Sales Order)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

View Type	D	Database View
Database View	JKVWERB
Short Description	IS-M/SD: Promotion View for Sales Order
Root table	JKAK	Sales Order Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKAK	JKAK
2	JKAP
3	JKEP
4	JKPA
5	JKKD
6	JKWERB
7	TVTA
8	JLTEKORG

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAK	MANDT	JL	EQ				0	0
2	JKAP	MANDT	JR	EQ			AND	0	0
3	JKAK	VBELN	JL	EQ				0	0
4	JKAP	VBELN	JR	EQ			AND	0	0
5	JKAP	MANDT	JL	EQ				0	0
6	JKEP	MANDT	JR	EQ			AND	0	0
7	JKAP	VBELN	JL	EQ				0	0
8	JKEP	VBELN	JR	EQ			AND	0	0
9	JKAP	POSNR	JL	EQ				0	0
10	JKEP	POSNR	JR	EQ			AND	0	0
11	JKAP	MANDT	JL	EQ				0	0
12	JKPA	MANDT	JR	EQ			AND	0	0
13	JKAP	VBELN	JL	EQ				0	0
14	JKPA	VBELN	JR	EQ			AND	0	0
15	JKAP	POSNR	JL	EQ				0	0
16	JKPA	POSNR	JR	EQ			AND	0	0
17	JKAP	MANDT	JL	EQ				0	0
18	JKKD	MANDT	JR	EQ			AND	0	0
19	JKAP	VBELN	JL	EQ				0	0
20	JKKD	VBELN	JR	EQ			AND	0	0
21	JKAP	POSNR	JL	EQ				0	0
22	JKKD	POSNR	JR	EQ			AND	0	0
23	JKAP	MANDT	JL	EQ				0	0
24	JKWERB	MANDT	JR	EQ			AND	0	0
25	JKAP	VBELN	JL	EQ				0	0
26	JKWERB	VBELN	JR	EQ			AND	0	0
27	JKAP	POSNR	JL	EQ				0	0
28	JKWERB	POSNR	JR	EQ			AND	0	0
29	TVTA	MANDT	JL	EQ				0	0
30	JKAK	MANDT	JR	EQ			AND	0	0
31	TVTA	VKORG	JL	EQ				0	0
32	JKAK	VKORG	JR	EQ			AND	0	0
33	TVTA	VTWEG	JL	EQ				0	0
34	JKAK	VTWEG	JR	EQ			AND	0	0
35	TVTA	SPART	JL	EQ				0	0
36	JKAK	SPART	JR	EQ			AND	0	0
37	TVTA	MANDT	JL	EQ				0	0
38	JLTEKORG	MANDT	JR	EQ			AND	0	0
39	TVTA	VKORG	JL	EQ				0	0
40	JLTEKORG	VKORG	JR	EQ			AND	0	0
41	TVTA	VTWEG	JL	EQ				0	0
42	JLTEKORG	VTWEG	JR	EQ			AND	0	0
43	TVTA	SPART	JL	EQ				0	0
44	JLTEKORG	SPART	JR	EQ			AND	0	0
45	JKAK	VBTYP		NE	'B'		AND	0	0
46	JKAP	XURPOS		EQ	'X'		AND	0	0
47	JKEP	XUREINT		EQ	'X'		AND	0	0
48	JKPA	JPARVW		EQ	'VM'		AND	0	0
49	JLTEKORG	DLART		EQ	'0002'			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	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
4	ETENR	JKEP	ETENR		☐	JAENR	☐	Sales Order Schedule Line
5	JPARVW	JKPA	JPARVW		☐	JPARVW	☐	IS-M: Business Partner Role
6	PARZA	JKPA	PARZA		☐	JPARZA	☐	IS-M: Partner Role Counter
7	JKPAVON	JKPA	GUELTIGVON		☐	JKPAVON	☐	Date from Which Partner Data in Sales Order is Valid
8	DLART	JLTEKORG	DLART		☐	JDLART	☐	IS-M: Service type
9	GPAG	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
10	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
11	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
12	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
13	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
14	SPART	JKAK	SPART		☐	SPART_AK	☐	Division for order header
15	VKBUR	JKAK	VKBUR		☐	JVKBUR	☐	IS-M/SD: Receiving Sales Office
16	BSTDK	JKAK	BSTDK		☐	BSTDK	☐	Customer purchase order date
17	XIMMATRIK	JKAK	XIMMATRIK		☐	XIMMATRIK	☐	Indicator: Proof of matriculation provided
18	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
19	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
20	PVA	JKAP	PVA		☐	PVA	☐	Edition
21	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
22	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
23	LAND1	JKAP	LAND1		☐	LAND1_ISP	☐	Normal delivery country
24	XPATE	JKAP	XPATE		☐	XPATE	☐	IS-M: Sponsored subscription
25	GSBER	JKAP	GSBER		☐	GSBER	☐	Business Area
26	RECHBEGINN	JKAP	RECHBEGINN		☐	RECHBEGINN	☐	Billing From
27	RECHENDE	JKAP	RECHENDE		☐	RECHENDE	☐	Billing To
28	XNEGOPTION	JKAP	XNEGOPTION		☐	XNEGOPTION	☐	IS-M: Item with Automatic Transformation to Chargeable
29	GUELTIGVON	JKEP	GUELTIGVON		☐	JKEPVON	☐	Date from Which Schedule Line in Sales Order is Valid
30	GUELTIGBIS	JKEP	GUELTIGBIS		☐	JKEPBIS	☐	Date to Which Schedule Line in Sales Order is Valid
31	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
32	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
33	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
34	ETVORZEI	JKEP	ETVORZEI		☐	ETVORZEI	☐	Plus/Minus Sign for Schedule Line Quantity in Sales Order
35	BZPERF	JKEP	BZPERF		☐	BEZPERFAKT	☐	IS-M: Service Type for Billing
36	GPNR	JKPA	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
37	VERSERVGES	JKPA	VERSERVGES		☐	VERSERVGES	☐	IS-M: Service Company
38	KONDA	JKKD	KONDA		☐	KONDA	☐	Price Group (Customer)
39	FKPER	JKKD	FKPER		☐	FKPER	☐	Billing Frequency
40	WERBEART	JKWERB	WERBEART		☐	WERBEART	☐	Sales Source
41	PROVFDAT	JKWERB	PROVFDAT		☐	PROVFDAT	☐	Commission due date
42	VPFLZEINHV	JKWERB	VPFLZEINHV		☐	VPFLZEINHV	☐	Time unit for commitment period
43	VPFLZEITRV	JKWERB	VPFLZEITRV		☐	VPFLZEITRV	☐	Commitment period for sales agent (subscriber)
44	KONTAKTNR	JKWERB	KONTAKTNR		☐	KONTAKTNR	☐	IS-M: Business Partner Sales Activity
45	XRECHERZ	JKWERB	XRECHERZ		☐	XRECHERZ	☐	IS-M: Research generated
46	VSGRCHEUR	JKWERB	VSGRCHEUR		☐	VSGRCHEUR	☐	Researcher's Service Company
47	GPRECH	JKWERB	GPRECH		☐	GPRECH	☐	IS-M: Researcher
48	APNRWERB	JKWERB	APNRWERB		☐	APNRWERB	☐	Order Item Number for Gift 'Free Subscription'
49	AVNRWERB	JKWERB	AVNRWERB		☐	AVNRWERB	☐	Order Number for Gift 'Free Subscription'
50	WERBTRAEG	JKWERB	WERBTRAEG		☐	WERBTRAEG	☐	Advertising Medium
51	ZUZAHLWAER	JKWERB	ZUZAHLWAER		☐	JZUZAHLWAE	☐	Currency for Additional Payment
52	ZUZAHLBETR	JKWERB	ZUZAHLBETR		☐	JZUZAHLBET	☐	Additional payment
53	ERLDATWERB	JKWERB	ERLDATWERB		☐	ERLDATWERB	☐	Date Advertising Bonus Sent
54	MATNRWERB	JKWERB	MATNRWERB		☐	MATNR_SAPR	☐	IS-M: Material number for gift
55	XRENDITE	JKWERB	XRENDITE		☐	XRENDITE	☐	Renewal commission
56	XWKZ	JKWERB	XWKZ		☐	XWKZ	☐	Indicator: Promotion rebate
57	XEINMALPRV	JKWERB	XEINMALPRV		☐	XEINMALPRV	☐	Indicator: One-time commission
58	HAFTDEINH	JKWERB	HAFTDEINH		☐	HAFTDEINH	☐	Time Unit for Liability Period
59	HAFTDAUER	JKWERB	HAFTDAUER		☐	HAFTDAUER	☐	Liability Period for Commission Clawback in Months
60	PROVRART	JKWERB	PROVRART		☐	PROVRART	☐	Commission clawback type
61	PRVSP	JKWERB	PRVSP		☐	PROVSPERRE	☐	Commission settlement block
62	XVTPRO	JKWERB	XVTPRO		☐	XVTPRO	☐	Relevant for commission
63	LIEFUMXEIN	JKWERB	LIEFUMXEIN		☐	LIEFUMXEIN	☐	Time unit for maximum delivery suspension
64	LIEFUNTMAX	JKWERB	LIEFUNTMAX		☐	LIEFUNTMAX	☐	Maximum Delivery Suspension
65	MINDBEZEIN	JKWERB	MINDBEZEIN		☐	MINDBEZEIN	☐	Time Unit for Minimum Length of Subscription
66	MINDBEZUG	JKWERB	MINDBEZUG		☐	MINDBEZUG	☐	Minimum Length of Subscription
67	WERBEAKT	JKWERB	WERBEAKT		☐	WERBEAKT	☐	Sales Promotion
68	EKORG	JLTEKORG	EKORG		☐	EKORG	☐	Purchasing organization
69	JKWERBVON	JKWERB	GUELTIGVON		☐	WERBVONDT	☐	Start of Validity of Campaign Framework
70	XSAPRSPERR	JKWERB	XSAPRSPERR		☐	XSAPRSPERR	☐	Block indicator for gift shipping
71	WERBKZSCHL	JKAP	WERBKZSCHL		☐	JWBZWKZSCH	☐	IS-M: WBZ, Promotion Rebate Key
72	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order

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	20130529
SAP Release Created in