SAP ABAP View JKVCOMM (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	JKVCOMM
Short Description	IS-M/SD: Promotion View for Sales Order
Root table	JKCOMM	Sales Order: Commission for Introduction Record

Table

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

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	JKCOMM	MANDT	JR	EQ			AND	0	0
3	JKPROM	VBELN	JL	EQ				0	0
4	JKCOMM	VBELN	JR	EQ			AND	0	0
5	JKPROM	POSNR	JL	EQ				0	0
6	JKCOMM	POSNR	JR	EQ			AND	0	0
7	JKPROM	PROMNR	JL	EQ				0	0
8	JKCOMM	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	JR	EQ			AND	0	0
15	JKKD	MANDT	JL	EQ				0	0
16	JKAP	MANDT	JR	EQ			AND	0	0
17	JKKD	VBELN	JL	EQ				0	0
18	JKAP	VBELN	JR	EQ			AND	0	0
19	JKKD	POSNR	JL	EQ				0	0
20	JKAP	POSNR	JR	EQ			AND	0	0
21	JKEP	MANDT	JL	EQ				0	0
22	JKAP	MANDT	JR	EQ			AND	0	0
23	JKEP	VBELN	JL	EQ				0	0
24	JKAP	VBELN	JR	EQ			AND	0	0
25	JKEP	POSNR	JL	EQ				0	0
26	JKAP	POSNR	JR	EQ			AND	0	0
27	JKAK	MANDT	JL	EQ				0	0
28	JKAP	MANDT	JR	EQ			AND	0	0
29	JKAK	VBELN	JL	EQ				0	0
30	JKAP	VBELN	JR	EQ			AND	0	0
31	TVTA	MANDT	JL	EQ				0	0
32	JKAK	MANDT	JR	EQ			AND	0	0
33	TVTA	VKORG	JL	EQ				0	0
34	JKAK	VKORG	JR	EQ			AND	0	0
35	TVTA	VTWEG	JL	EQ				0	0
36	JKAK	VTWEG	JR	EQ			AND	0	0
37	TVTA	SPART	JL	EQ				0	0
38	JKAK	SPART	JR	EQ			AND	0	0
39	JLTEKORG	MANDT	JL	EQ				0	0
40	TVTA	MANDT	JR	EQ			AND	0	0
41	JLTEKORG	VKORG	JL	EQ				0	0
42	TVTA	VKORG	JR	EQ			AND	0	0
43	JLTEKORG	VTWEG	JL	EQ				0	0
44	TVTA	VTWEG	JR	EQ			AND	0	0
45	JLTEKORG	SPART	JL	EQ				0	0
46	TVTA	SPART	JR	EQ			AND	0	0
47	JKAK	VBTYP		NE	'B'		AND	0	0
48	JKEP	XUREINT		EQ	'X'		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	JKCOMM	MANDT		☐	MANDT	☐	Client
2	VBELN	JKCOMM	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	POSNR	JKCOMM	POSNR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
4	PROMNR	JKCOMM	PROMNR		☐	JPROMNR	☐	Sales order introduction
5	GPNR	JKCOMM	GPNR		☐	GPPROV	☐	IS-M: Commission Recipient
6	VERSERVGES	JKCOMM	VERSERVGES		☐	VSGPROV	☐	Service company for commission payee
7	XEINMALPRV	JKCOMM	XEINMALPRV		☐	XEINMALPRV	☐	Indicator: One-time commission
8	XRENDITE	JKCOMM	XRENDITE		☐	XRENDITE	☐	Renewal commission
9	XWKZ	JKCOMM	XWKZ		☐	XWKZ	☐	Indicator: Promotion rebate
10	HAFTDAUER	JKCOMM	HAFTDAUER		☐	HAFTDAUER	☐	Liability Period for Commission Clawback in Months
11	HAFTDEINH	JKCOMM	HAFTDEINH		☐	HAFTDEINH	☐	Time Unit for Liability Period
12	PROVPERCNT	JKCOMM	PROVPERCNT		☐	PROVPERCNT	☐	IS-M/SD: Percentage rate of commission
13	PRVSP	JKCOMM	PRVSP		☐	PROVSPERRE	☐	Commission settlement block
14	PROVRART	JKCOMM	PROVRART		☐	PROVRART	☐	Commission clawback type
15	PROVFDAT	JKCOMM	PROVFDAT		☐	PROVFDAT	☐	Commission due date
16	WERBEART	JKPROM	WERBEART		☐	WERBEART	☐	Sales Source
17	WERBEAKT	JKPROM	WERBEAKT		☐	WERBEAKT	☐	Sales Promotion
18	JKPROMVON	JKPROM	GUELTIGVON		☐	WERBVONDT	☐	Start of Validity of Campaign Framework
19	XAQUISITION	JKPROM	XAQUISITION		☐	XAQUISITION	☐	IS-M/SD: Indicator - first introduction record
20	WERBTRAEG	JKPROM	WERBTRAEG		☐	WERBTRAEG	☐	Advertising Medium
21	MINDBEZUG	JKPROM	MINDBEZUG		☐	MINDBEZUG	☐	Minimum Length of Subscription
22	MINDBEZEIN	JKPROM	MINDBEZEIN		☐	MINDBEZEIN	☐	Time Unit for Minimum Length of Subscription
23	POSNR_BASE	JKPROM	POSNR_BASE		☐	APNR	☐	Sales Order Item
24	CYCLENR_BASE	JKPROM	CYCLENR_BASE		☐	CYCLENR	☐	IS-M/SD: Billing Cycle Number
25	EVENT	JKPROM	EVENT		☐	JK_EVENT	☐	IS-M/SD: Event in order processing
26	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
27	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
28	LAND1	JKAP	LAND1		☐	LAND1_ISP	☐	Normal delivery country
29	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
30	PVA	JKAP	PVA		☐	PVA	☐	Edition
31	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
32	GSBER	JKAP	GSBER		☐	GSBER	☐	Business Area
33	RECHBEGINN	JKAP	RECHBEGINN		☐	RECHBEGINN	☐	Billing From
34	RECHENDE	JKAP	RECHENDE		☐	RECHENDE	☐	Billing To
35	XPATE	JKAP	XPATE		☐	XPATE	☐	IS-M: Sponsored subscription
36	XNEGOPTION	JKAP	XNEGOPTION		☐	XNEGOPTION	☐	IS-M: Item with Automatic Transformation to Chargeable
37	WERBKZSCHL	JKAP	WERBKZSCHL		☐	JWBZWKZSCH	☐	IS-M: WBZ, Promotion Rebate Key
38	KONDA	JKKD	KONDA		☐	KONDA	☐	Price Group (Customer)
39	FKPER	JKKD	FKPER		☐	FKPER	☐	Billing Frequency
40	ETENR	JKEP	ETENR		☐	JAENR	☐	Sales Order Schedule Line
41	GUELTIGVON	JKEP	GUELTIGVON		☐	JKEPVON	☐	Date from Which Schedule Line in Sales Order is Valid
42	GUELTIGBIS	JKEP	GUELTIGBIS		☐	JKEPBIS	☐	Date to Which Schedule Line in Sales Order is Valid
43	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
44	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
45	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
46	BZPERF	JKEP	BZPERF		☐	BEZPERFAKT	☐	IS-M: Service Type for Billing
47	GPAG	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
48	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
49	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
50	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
51	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
52	SPART	JKAK	SPART		☐	SPART_AK	☐	Division for order header
53	VKBUR	JKAK	VKBUR		☐	JVKBUR	☐	IS-M/SD: Receiving Sales Office
54	BSTDK	JKAK	BSTDK		☐	BSTDK	☐	Customer purchase order date
55	XIMMATRIK	JKAK	XIMMATRIK		☐	XIMMATRIK	☐	Indicator: Proof of matriculation provided
56	EKORG	JLTEKORG	EKORG		☐	EKORG	☐	Purchasing organization
57	DLART	JLTEKORG	DLART		☐	JDLART	☐	IS-M: Service type

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