SAP ABAP View JKVWMAT (IS-M/SD: Promotion View (Gift) 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	JKVWMAT
Short Description	IS-M/SD: Promotion View (Gift) for Sales Order
Root table	JKGIFT	Sales Order: Promotional Gifts for Introduction Record

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKGIFT	JKGIFT
2	JKPROM
3	JKAP
4	JKEP
5	JKAK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKPROM	MANDT	JL	EQ				0	0
2	JKGIFT	MANDT	JR	EQ			AND	0	0
3	JKPROM	VBELN	JL	EQ				0	0
4	JKGIFT	VBELN	JR	EQ			AND	0	0
5	JKPROM	POSNR	JL	EQ				0	0
6	JKGIFT	POSNR	JR	EQ			AND	0	0
7	JKPROM	PROMNR	JL	EQ				0	0
8	JKGIFT	PROMNR	JR	EQ			AND	0	0
9	JKAP	MANDT	JL	EQ				0	0
10	JKPROM	MANDT	JR	EQ			AND	0	0
11	JKAP	VBELN	JL	EQ				0	0
12	JKPROM	VBELN	JR	EQ			AND	0	0
13	JKAP	POSNR	JL	EQ				0	0
14	JKPROM	POSNR_BASE	JR	EQ			AND	0	0
15	JKEP	MANDT	JL	EQ				0	0
16	JKAP	MANDT	JR	EQ			AND	0	0
17	JKEP	VBELN	JL	EQ				0	0
18	JKAP	VBELN	JR	EQ			AND	0	0
19	JKEP	POSNR	JL	EQ				0	0
20	JKAP	POSNR	JR	EQ			AND	0	0
21	JKAK	MANDT	JL	EQ				0	0
22	JKAP	MANDT	JR	EQ			AND	0	0
23	JKAK	VBELN	JL	EQ				0	0
24	JKAP	VBELN	JR	EQ			AND	0	0
25	JKAK	VBTYP		NE	'B'		AND	0	0
26	JKEP	XUREINT		EQ	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKGIFT	MANDT		☐	MANDT	☐	Client
2	VBELN	JKGIFT	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	POSNR	JKGIFT	POSNR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
4	ETENR	JKEP	ETENR		☐	JAENR	☐	Sales Order Schedule Line
5	PROMNR	JKGIFT	PROMNR		☐	JPROMNR	☐	Sales order introduction
6	MATNRWERB	JKGIFT	MATNRWERB		☐	MATNR_SAPR	☐	IS-M: Material number for gift
7	GPNR	JKGIFT	GPNR		☐	GPVERM	☐	Business Partner Sales Agent
8	XMAINAGENT	JKGIFT	XMAINAGENT		☐	XMAINAGENT	☐	IS-M/SD: Indicator for Main Sales Agent
9	ZUZAHLBETR	JKGIFT	ZUZAHLBETR		☐	JZUZAHLBET	☐	Additional payment
10	ZUZAHLWAER	JKGIFT	ZUZAHLWAER		☐	JZUZAHLWAE	☐	Currency for Additional Payment
11	VERSANDDAT	JKGIFT	VERSANDDAT		☐	JPRMVRSDAT	☐	IS-M/SD: Gift Shipping Date
12	VPFLZEITRV	JKGIFT	VPFLZEITRV		☐	VPFLZEITRV	☐	Commitment period for sales agent (subscriber)
13	VPFLZEINHV	JKGIFT	VPFLZEINHV		☐	VPFLZEINHV	☐	Time unit for commitment period
14	VPFLBEGINN	JKGIFT	VPFLBEGINN		☐	VPFLBEGINN	☐	IS-M/SD: Date on which commitment period begins
15	ERLDATWERB	JKGIFT	ERLDATWERB		☐	ERLDATWERB	☐	Date Advertising Bonus Sent
16	XSAPRSPERR	JKGIFT	XSAPRSPERR		☐	XSAPRSPERR	☐	Block indicator for gift shipping
17	AVNRWERB	JKGIFT	AVNRWERB		☐	AVNRWERB	☐	Order Number for Gift 'Free Subscription'
18	APNRWERB	JKGIFT	APNRWERB		☐	APNRWERB	☐	Order Item Number for Gift 'Free Subscription'
19	WERBEART	JKPROM	WERBEART		☐	WERBEART	☐	Sales Source
20	WERBEAKT	JKPROM	WERBEAKT		☐	WERBEAKT	☐	Sales Promotion
21	XAQUISITION	JKPROM	XAQUISITION		☐	XAQUISITION	☐	IS-M/SD: Indicator - first introduction record
22	JKPROMVON	JKPROM	GUELTIGVON		☐	WERBVONDT	☐	Start of Validity of Campaign Framework
23	MINDBEZUG	JKPROM	MINDBEZUG		☐	MINDBEZUG	☐	Minimum Length of Subscription
24	MINDBEZEIN	JKPROM	MINDBEZEIN		☐	MINDBEZEIN	☐	Time Unit for Minimum Length of Subscription
25	POSNR_BASE	JKPROM	POSNR_BASE		☐	APNR	☐	Sales Order Item
26	CYCLENR_BASE	JKPROM	CYCLENR_BASE		☐	CYCLENR	☐	IS-M/SD: Billing Cycle Number
27	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
28	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
29	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
30	PVA	JKAP	PVA		☐	PVA	☐	Edition
31	JKEPVON	JKEP	GUELTIGVON		☐	JKEPVON	☐	Date from Which Schedule Line in Sales Order is Valid
32	JKEPBIS	JKEP	GUELTIGBIS		☐	JKEPBIS	☐	Date to Which Schedule Line in Sales Order is Valid
33	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
34	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
35	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
36	GPAG	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
37	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
38	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
39	SPART	JKAK	SPART		☐	SPART_AK	☐	Division for order header
40	XFKVDICHT	JKAK	XFKVDICHT		☐	XFKVDICHT	☐	IS-M: Summarize deliveries according to billing item
41	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
42	ERFDATE	JKAP	ERFDATE		☐	ERFDATE	☐	Created On

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