SAP Table JKCOMM

Sales Order: Commission for Introduction Record

JKCOMM (Sales Order: Commission for Introduction Record) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JKCOMM to other SAP tables.

Source: JKCOMM (Sales Order: Commission for Introduction Record)

JKCOMM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN IS-M/SD: Publishing Sales Order AVNR JKAK CHAR 10 0
POSNR Original Item in Publishing Sales Order APNR_UR JKAP NUMC 6 0
PROMNR Sales order introduction JPROMNR JKPROM NUMC 3 0
GPNR IS-M: Commission Recipient GPPROV JGTGPNR CHAR 10 0
VERSERVGES Service company for commission payee VSGPROV JGTVSG CHAR 10 0
XMAINAGENT IS-M/SD: Indicator for Main Sales Agent XMAINAGENT CHAR 1 0
X Yes
NULL No
XEINMALPRV Indicator: One-time commission XEINMALPRV CHAR 1 0
X Yes
NULL No
XRENDITE Renewal commission XRENDITE CHAR 1 0
X Yes
NULL No
XWKZ Indicator: Promotion rebate XWKZ CHAR 1 0
X Yes
NULL No
HAFTDAUER Liability Period for Commission Clawback in Months HAFTDAUER QUAN 2 0
HAFTDEINH Time Unit for Liability Period HAFTDEINH T006 UNIT 3 0
HAFTBEGINN IS-M/SD: Date Marking the Start of the Liability Period HAFTBEGINN DATS 8 0
PROVPERCNT IS-M/SD: Percentage rate of commission PROVPERCNT NUMC 3 0
0
PRVSP Commission settlement block PROVSPERRE TJLPS CHAR 2 0
PROVRART Commission clawback type PROVRART CHAR 1 0
0 No commission clawback
1 Full commission clawback
2 Partial commission clawback
XPROVRUECK Indicator: Commission recalculation for order item XPROVRUECK CHAR 1 0
X Yes
NULL No
PROVFDAT Commission due date PROVFDAT DATS 8 0
XPROVVSYST Commission settlement for subscription in legacy system XPROVVSYST CHAR 1 0
X Yes
NULL No
PROVDATVSYST "Commission settlement performed to" date in legacy system PROVDATVSYST DATS 8 0
BILLARCHIVED IS-M/SD: Commission settlement document archived JBILLARCHIVED CHAR 1 0
X Yes
NULL No
XRESTORE IS-M/SD: Event for restarting a terminated item XEV_RESTORE CHAR 1 0
X Yes
NULL No

JKCOMM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JKCOMM GPNR JKCOMM GPNR JGTGPNR IS-M: Central Business Partner Table GPNR
JKCOMM GPNR JKCOMM MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JKCOMM HAFTDEINH JKCOMM HAFTDEINH T006 Units of Measurement MSEHI
JKCOMM HAFTDEINH JKCOMM MANDT T006 Units of Measurement MANDT
JKCOMM MANDT JKCOMM MANDT T000 Clients MANDT
JKCOMM POSNR JKCOMM MANDT JKAP Sales Order - Item Data MANDT
JKCOMM POSNR JKCOMM VBELN JKAP Sales Order - Item Data VBELN
JKCOMM POSNR JKCOMM POSNR JKAP Sales Order - Item Data POSNR
JKCOMM PROMNR JKCOMM POSNR JKPROM Sales Order: Introduction Data POSNR
JKCOMM PROMNR JKCOMM PROMNR JKPROM Sales Order: Introduction Data PROMNR
JKCOMM PROMNR JKCOMM VBELN JKPROM Sales Order: Introduction Data VBELN
JKCOMM PROMNR JKCOMM MANDT JKPROM Sales Order: Introduction Data MANDT
JKCOMM PRVSP JKCOMM MANDT TJLPS Is-M/SD: Commission Settlement Block MANDT
JKCOMM PRVSP JKCOMM PRVSP TJLPS Is-M/SD: Commission Settlement Block PRVSP
JKCOMM VBELN JKCOMM VBELN JKAK Sales Order Header Data VBELN
JKCOMM VBELN JKCOMM MANDT JKAK Sales Order Header Data MANDT
JKCOMM VERSERVGES JKCOMM MANDT JGTVSG IS-M/SD: Service Companies MANDT
JKCOMM VERSERVGES JKCOMM VERSERVGES JGTVSG IS-M/SD: Service Companies VERSERVGES