SAP ABAP Table JKCOMMVB (Reference Structure for XJKCOMM)

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

Table Category	INTTAB	Structure
Structure	JKCOMMVB	Table Relationship Diagram
Short Description	Reference Structure for XJKCOMM

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	.INCLUDE	☐				0	0	Sales Order: Commission for Introduction Record
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
4	POSNR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
5	PROMNR	☐	JPROMNR	JPROMNR	NUMC	3	0	Sales order introduction	JKPROM
6	GPNR	☐	GPPROV	GPNR	CHAR	10	0	IS-M: Commission Recipient	JGTGPNR
7	VERSERVGES	☐	VSGPROV	GPNR	CHAR	10	0	Service company for commission payee	JGTVSG
8	XMAINAGENT	☐	XMAINAGENT	XFELD	CHAR	1	0	IS-M/SD: Indicator for Main Sales Agent
9	XEINMALPRV	☐	XEINMALPRV	XFELD	CHAR	1	0	Indicator: One-time commission
10	XRENDITE	☐	XRENDITE	XFELD	CHAR	1	0	Renewal commission
11	XWKZ	☐	XWKZ	XFELD	CHAR	1	0	Indicator: Promotion rebate
12	HAFTDAUER	☐	HAFTDAUER	ISPMNG2	QUAN	2	0	Liability Period for Commission Clawback in Months
13	HAFTDEINH	☐	HAFTDEINH	MEINS	UNIT	3	0	Time Unit for Liability Period	T006
14	HAFTBEGINN	☐	HAFTBEGINN	DATUM	DATS	8	0	IS-M/SD: Date Marking the Start of the Liability Period
15	PROVPERCNT	☐	PROVPERCNT	PROZENT100	NUMC	3	0	IS-M/SD: Percentage rate of commission
16	PRVSP	☐	PROVSPERRE	PROVSPERRE	CHAR	2	0	Commission settlement block	TJLPS
17	PROVRART	☐	PROVRART	PROVRART	CHAR	1	0	Commission clawback type
18	XPROVRUECK	☐	XPROVRUECK	XFELD	CHAR	1	0	Indicator: Commission recalculation for order item
19	PROVFDAT	☐	PROVFDAT	DATUM	DATS	8	0	Commission due date
20	XPROVVSYST	☐	XPROVVSYST	XFELD	CHAR	1	0	Commission settlement for subscription in legacy system
21	PROVDATVSYST	☐	PROVDATVSYST	DATUM	DATS	8	0	"Commission settlement performed to" date in legacy system
22	BILLARCHIVED	☐	JBILLARCHIVED	XFELD	CHAR	1	0	IS-M/SD: Commission settlement document archived
23	XRESTORE	☐	XEV_RESTORE	XFELD	CHAR	1	0	IS-M/SD: Event for restarting a terminated item
24	XPROVAB	☐	XPROVAB	XFELD	CHAR	1	0	IS-M/SD: Settlement Performed for Employee Commission Rate
25	XPRVSAB	☐	XPRVSAB	XFELD	CHAR	1	0	IS-M/SD: Settlement of Commission Rate Performed for SC
26	XPROVRUECKAB	☐	XPROVRUECKAB	XFELD	CHAR	1	0	IS-M/SD: Commission rate recalculated for employee
27	XPRVSRUECKAB	☐	XPRVSRUECKAB	XFELD	CHAR	1	0	IS-M/SD: Commission rate recalculated for SC
28	DBCODE	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKCOMMVB	GPNR	JGTGPNR	GPNR	KEY	1	CN
2	JKCOMMVB	HAFTDEINH	T006	MSEHI	REF	C	CN
3	JKCOMMVB	MANDT	T000	MANDT	KEY	1	CN
4	JKCOMMVB	POSNR	JKAP	POSNR	KEY	1	CN
5	JKCOMMVB	PROMNR	JKPROM	PROMNR	KEY	1	CN
6	JKCOMMVB	PRVSP	TJLPS	PRVSP	REF	C	CN
7	JKCOMMVB	VBELN	JKAK	VBELN	KEY	1	CN
8	JKCOMMVB	VERSERVGES	JGTVSG	VERSERVGES	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in