Follow us on LinkedIn for your next SAP project

SAP Table JKAP

Sales Order - Item Data

JKAP (Sales Order - Item Data) 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 JKAP to other SAP tables.

JKAP table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
VBELN
IS-M/SD: Publishing Sales Order
AVNR JKAK
CHAR
10 0
POSNR
Sales Order Item
APNR
NUMC
6 0
GUELTIGVON
Valid-From Date of Sales Order Item
JKAPVON
DATS
8 0
GUELTIGBIS
Date to which Sales Order Item is Valid
JKAPBIS
DATS
8 0
POART
Internal Item Type for Sales Order
POART_ISP TJAP
CHAR
2 0
AEART
Order Change Type
AEART_JSDK
CHAR
1 0
ZSKLS
Time slice classification for sales order
JZSKLS
CHAR
1 0
POSEX
External Item Number (Purchase Order Item)
POSEX_ISP
NUMC
6 0
KUNWE
IS-M: Business Partner Ship-to Party
GPNR_WE JGTGPNR
CHAR
10 0
KUNWEFREMD
Cust.No. with External Company (External Deliveries/Retail)
JKUNNRVERL
CHAR
15 0
LANDE
Current country being supplied
LANDE_ISP T005
CHAR
3 0
LAND1
Normal delivery country
LAND1_ISP T005
CHAR
3 0
DRERZ
Publication
DRERZ JDTDRER
CHAR
8 0
PVA
Edition
PVA JDTPVA
CHAR
8 0
BEZUGSTYP
Mix Type
BEZUGSTYP_JE_PVA JDTBEZTYP
CHAR
2 0
XRUECKABO
IS-M: Backdated subscription created
XRUECKABO
CHAR
1 0
LIEFVON
Regular start of delivery for item in sales order
LIEFVON
DATS
8 0
SPART
Division for publication
SPARTDRERZ TSPA
CHAR
2 0
MATKL
Material Group
MATKL T023
CHAR
9 0
GSBER
Business Area
GSBER TGSB
CHAR
4 0
VOREF
Complete reference indicator
VOREF
CHAR
1 0
ERLRE
Completion rule for quotation / contract
ERLRE
CHAR
1 0
TAXM1
Tax classification material
TAXMT
CHAR
1 0
TAXM2
Tax classification material
TAXMT
CHAR
1 0
TAXM3
Tax classification material
TAXMT
CHAR
1 0
TAXM4
Tax classification material
TAXMT
CHAR
1 0
TAXM5
Tax classification material
TAXMT
CHAR
1 0
TAXM6
Tax classification material
TAXMT
CHAR
1 0
TAXM7
Tax classification material
TAXMT
CHAR
1 0
TAXM8
Tax classification material
TAXMT
CHAR
1 0
TAXM9
Tax classification material
TAXMT
CHAR
1 0
VGREF
Preceding document has resulted from reference
VGREF
CHAR
1 0
STAFO
Update group for statistics update
STAFO
CHAR
6 0
STCUR
Exchange rate for statistics (Exch.rate at time of creation)
STCUR_AP
DEC
9 5
IVWKN
Circulation Audit Report Category ID
IVWKN TJI01
CHAR
8 0
IVWKNFREI
Circulation Report Category ID for Non-Calculation Period
IVWKNFREI TJI01
CHAR
8 0
XLIEFSE
Delivery to social facility
XLIEFSE
CHAR
1 0
LIEFERART
Delivery Type
LIEFERART TJV01
CHAR
2 0
LIEFXUHR
Time of latest delivery
LIEFXUHR
TIMS
6 0
DRUCKEREI
Plant
JWERK T001W
CHAR
4 0
VSAUSSTART
Shipping outsorting type
VSAUSSTART TJV09
CHAR
2 0
UNTBRGRD
Reason for Suspension
UNTBRGRD TJK85
CHAR
3 0
BEZUGGRD
Purchase Reason
BEZUGGRD TJK87
CHAR
3 0
KORRGRD
IS-M: Reason for correction
KORRGRD TJK81
CHAR
3 0
GUTSCHEIN
Coupon Number
GUTSCHEIN
NUMC
8 0
XGUTSCHEIN
Indicator: Vouchers allowed
XGUTSCHEIN
CHAR
1 0
XDISPO
Indicator: relevant to planning
XDISPO
CHAR
1 0
XUNVLIEFER
IS-M: Viability Data Incomplete for Item
XUNVLIEFER
CHAR
1 0
XUNVLAUTO
IS-M: Via.data incomp.for item (due to automatic change)
XUNVLAUTO
CHAR
1 0
RECHBEGINN
Billing From
RECHBEGINN
DATS
8 0
RECHENDE
Billing To
RECHENDE
DATS
8 0
XLIEFBAR
Determine delivery viability
XLIEFBAR
CHAR
1 0
XIVW
Indicator: Relevant for audit report
XIVW
CHAR
1 0
XFAKTURA
Indicator: Relevant for billing
XFAKTURA
CHAR
1 0
PRSFD
Carry out pricing
PRSFD
CHAR
1 0
SBFREI
Administrator responsible for free copies
SBFREI
CHAR
12 0
WDVDAT
Resubmission date
WDVDAT
DATS
8 0
KUENDGRD
Reason for end of delivery
KUENDGRD TJK83
CHAR
3 0
XLOGO
Print Logo
XLOGO
CHAR
1 0
FAKSP
Billing Block
FAKTSPERRE TVFS
CHAR
2 0
XFAKTSPERR
IS-M: Billing block set
XFAKTSPERR
CHAR
1 0
XREMRECHT
IS-M: Right of Return
XREMRECHT
CHAR
1 0
XBAGABR
Indicator: BAG billing procedure
XBAGABR
CHAR
1 0
XURPOS
Original item in publishing sales order
XURPOS
CHAR
1 0
POSNR_UR
Original Item in Publishing Sales Order
APNR_UR JKAP
NUMC
6 0
POSNR_VG
Preceding Item in Publishing Sales Order
APNR_VG JKAP
NUMC
6 0
VBELN_VL
Reference Document
AVNR_VL JKAK
CHAR
10 0
POSNR_VL
Reference Document Item
APNR_VL JKAP
NUMC
6 0
PVAKNTGRP
Account Assignment Grouping for Edition
PVAKNTGRP TVKM
CHAR
2 0
PVAKONGRP
Condition Grouping for Edition
PVAKONGRP TJD47
CHAR
2 0
PVABONGRP
Edition bonus grouping
PVABONGRP TJD49
CHAR
2 0
XTECHVORB
Indicator: Technical problem
XTECHVORB
CHAR
1 0
REMART
Return Type
REMART
CHAR
1 0
REMWEISE
Return Method
REMWEISE
CHAR
1 0
REMQUOTE
Expected return rate in percent
REMQUOTE
DEC
5 2
XMAXREMMG
Expected return quantity is maximum return quantity
XMAXREMMG
CHAR
1 0
ETENR_LAST
Last Schedule Line Number Assigned
ETENR_LAST JKEP
NUMC
4 0
ETEEX_LAST
Last Schedule Line Number Assigned
ETEEX_LAST
NUMC
6 0
KOKRS
Controlling Area
KOKRS TKA01
CHAR
4 0
KOSTL_L
Debit Cost Center
KOSTL_L CSKS
CHAR
10 0
XPATE
IS-M: Sponsored subscription
XPATE
CHAR
1 0
BEZIRK
Carrier Route
BEZIRK JVTBEZIRK
CHAR
10 0
XLIEFGP
IS-M: Delivery to business partner
XLIEFGP
CHAR
1 0
XLIEFBEZ
IS-M: Delivery to a carrier route (reserve)
XLIEFBEZ
CHAR
1 0
XNEGOPTION
IS-M: Item with Automatic Transformation to Chargeable
XNEGOPTION
CHAR
1 0
BEZPERSE
IS-M: Service Type for Social Facility
BEZPERSE TJD09
CHAR
5 0
VSOZMENGE
IS-M: Maximum schedule line quantity for social facility
VSOZMENGE
QUAN
10 0
LFBARDAT
Delivery viability set for sales order item valid from
LFBARDAT
DATS
8 0
SHKZG
IS-M: Debit indicator for schedule line
SHKZG_ISP
CHAR
1 0
VKBURZUS
Sales office responsible
VKBURZUS TVBUR
CHAR
4 0
ERFUSER
Created By
ERFUSER
CHAR
12 0
ERFDATE
Created On
ERFDATE
DATS
8 0
ERFTIME
Time Created
ERFTIME
TIMS
6 0
AENUSER
Last Changed By
AENUSER
CHAR
12 0
AENDATE
Date of Last Change
AENDATE
DATS
8 0
AENTIME
Time of Last Change
AENTIME
TIMS
6 0
XSTORNO
Indicator: Reversed
XJSTORNO
CHAR
1 0
STORNOGRD
Reversal Reason
STORNOGRD TJK91
CHAR
3 0
REFBELEG
IS-M/SD: Reference Document in Legacy System
REMELD_ISP
CHAR
20 0
XSCRIPT
SAPscript comment recorded
XSCRIPT
CHAR
1 0
WBZSATZART
IS-M: WBZ, Record Type
JWBZSTZART TJKW1
CHAR
3 0
WBZVORGART
IS-M: WBZ, Operation Type
JWBZVORART TJKW3
CHAR
3 0
WERBKZSCHL
IS-M: WBZ, Promotion Rebate Key
JWBZWKZSCH TJKW9
CHAR
1 0
WBZABOKUNR
IS-M: Subscription Customer Number
JWBZABOKNR
CHAR
9 0
XWBZRUECKU
IS-M: WBZ, reply to WBZ company required
XJWBZRUECK
CHAR
1 0
WBZKUNNR
IS-M: WBZ, VDZ Number of WBZ Company
JWBZKUNNR
CHAR
6 0
VERTRKENNZ
IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)
JWBZVKENNZ
CHAR
5 0
WBZTERMIN
IS-M: WBZ, Date (Format: MMYYYYCCCC)
JWBZTERMIN
CHAR
9 0
WBZVERTRETER
IS-M: WBZ, representative indicator
JWBZVERTR
CHAR
7 0
XSEPARATVS
IS-M: Separate first delivery
JXSEPRATVS
CHAR
1 0
HEFTNUMVON
Copy Number of First Issue to be Delivered
HEFTNUMVON
CHAR
9 0
HEFTNUMBIS
Copy Number of Last Issue for Delivery
HEFTNUMBIS
CHAR
9 0
XNOMESS
IS-M: Indicator - Do Not Perform Output Determination
XNOMESS
CHAR
1 0
JNBRIEFTYP
Letter type for generating letters using output control
JNBRIEFTYP TJN11
CHAR
4 0
XFMODRUECK
IS-M: Backdated changes to billing method
XFMODRUECK
CHAR
1 0
XEXPDATE
Limited order change affects expiration date
XEXPDATE
CHAR
1 0
TXJCD
Tax Jurisdiction
TXJCD
CHAR
15 0
XDELIV_FIXED
IS-M/SD: No Del.Viability Optimization (Parameters Fixed)
XDELIV_FIXED
CHAR
1 0
XNEW_PUBL
IS-M/SD: Item created by change of publication
XNEW_PUBL
CHAR
1 0
DELIVSPLITGRP
IS-M/SD: Address Alternation Group
DELIVSPLITGRP TJD63
CHAR
10 0
DELIVSPLIT
IS-M/SD: Alternating Address Element
DELIVSPLIT TJD23
CHAR
8 0
POSNR_MAIN
IS-M/SD: Main Item in Sales Order
APNR_MAIN JKAP
NUMC
6 0
POSNR_SUB
IS-M/SD: Sub-Item in Sales Order
APNR_SUB JKAP
NUMC
6 0
XMAINSPLIT
Item for this Alternating Add. Element is a Main Sub-Item
XMAINSPLIT
CHAR
1 0
X_MONTAG
IS-M: Monday
X_MONTAG
CHAR
1 0
X_DIENSTAG
IS-M: Tuesday
X_DIENSTAG
CHAR
1 0
X_MITTWOCH
IS-M: Wednesday
X_MITTWOCH
CHAR
1 0
X_DONNETAG
IS-M: Thursday
X_DONNETAG
CHAR
1 0
X_FREITAG
IS-M: Friday
X_FREITAG
CHAR
1 0
X_SAMSTAG
IS-M: Saturday
X_SAMSTAG
CHAR
1 0
X_SONNTAG
IS-M: Sunday
X_SONNTAG
CHAR
1 0
CAMPAIGN
IS-M: Marketing Campaign
ISM_MARKETING_CAMPAIGN
RAW
16 0
REFUNDTYPE
IS-M/SD: Refund Type
REFUNDTYPE TJK19
CHAR
2 0
XVACPACK
Vacation Service: Postponed Delivery
XVACPACK
CHAR
1 0
BONUSTYPE
IS-M/SD: Bonus Type
JBONUSTYPE
CHAR
2 0

JKAP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JKAP BEZIRK JKAP MANDT JVTBEZIRK
IS-M: Carrier Route (Generalization)
MANDT
JKAP BEZIRK JKAP BEZIRK JVTBEZIRK
IS-M: Carrier Route (Generalization)
BEZIRK
JKAP BEZPERSE JKAP BEZPERSE TJD09
IS-M/SD: Service Type
BEZPER
JKAP BEZPERSE JKAP MANDT TJD09
IS-M/SD: Service Type
MANDT
JKAP BEZUGGRD JKAP MANDT TJK87
Sales Documents: Purchase Reasons
MANDT
JKAP BEZUGGRD JKAP BEZUGGRD TJK87
Sales Documents: Purchase Reasons
BEZUGGRD
JKAP BEZUGSTYP JKAP PVA JDTBEZTYP
IS-M: Mix Types (per Edition)
PVATRA
JKAP BEZUGSTYP JKAP BEZUGSTYP JDTBEZTYP
IS-M: Mix Types (per Edition)
BEZTYP
JKAP BEZUGSTYP JKAP MANDT JDTBEZTYP
IS-M: Mix Types (per Edition)
MANDT
JKAP BEZUGSTYP JKAP DRERZ JDTBEZTYP
IS-M: Mix Types (per Edition)
DRERTR
JKAP DELIVSPLIT JKAP MANDT TJD23
IS-M/SD: Alternating Address Elements
MANDT
JKAP DELIVSPLIT JKAP DELIVSPLIT TJD23
IS-M/SD: Alternating Address Elements
DELIVSPLIT
JKAP DELIVSPLITGRP JKAP MANDT TJD63
IS-M/SD: Address Alternation Groups
MANDT
JKAP DELIVSPLITGRP JKAP DELIVSPLITGRP TJD63
IS-M/SD: Address Alternation Groups
DELIVSPLITGRP
JKAP DRERZ JKAP MANDT JDTDRER
IS-M/SD: Publications
MANDT
JKAP DRERZ JKAP DRERZ JDTDRER
IS-M/SD: Publications
DRERZ
JKAP DRUCKEREI JKAP MANDT T001W
Plants/Branches
MANDT
JKAP DRUCKEREI JKAP DRUCKEREI T001W
Plants/Branches
WERKS
JKAP ETENR_LAST JKAP MANDT JKEP
Sales Order: Schedule Line Data
MANDT
JKAP ETENR_LAST JKAP VBELN JKEP
Sales Order: Schedule Line Data
VBELN
JKAP ETENR_LAST JKAP POSNR JKEP
Sales Order: Schedule Line Data
POSNR
JKAP ETENR_LAST JKAP ETENR_LAST JKEP
Sales Order: Schedule Line Data
ETENR
JKAP FAKSP JKAP MANDT TVFS
Billing: Reasons for Blocking
MANDT
JKAP FAKSP JKAP FAKSP TVFS
Billing: Reasons for Blocking
FAKSP
JKAP GSBER JKAP MANDT TGSB
Business Areas
MANDT
JKAP GSBER JKAP GSBER TGSB
Business Areas
GSBER
JKAP IVWKN JKAP IVWKN TJI01
Audit Report Categories
IVWKN
JKAP IVWKN JKAP MANDT TJI01
Audit Report Categories
MANDT
JKAP IVWKNFREI JKAP MANDT TJI01
Audit Report Categories
MANDT
JKAP IVWKNFREI JKAP IVWKNFREI TJI01
Audit Report Categories
IVWKN
JKAP JNBRIEFTYP JKAP MANDT TJN11
IS-M/SD: Letter Type
MANDT
JKAP JNBRIEFTYP JKAP JNBRIEFTYP TJN11
IS-M/SD: Letter Type
JNBRIEFTYP
JKAP KOKRS JKAP MANDT TKA01
Controlling Areas
MANDT
JKAP KOKRS JKAP KOKRS TKA01
Controlling Areas
KOKRS
JKAP KORRGRD JKAP KORRGRD TJK81
Correction Reason
KORRGRD
JKAP KORRGRD JKAP MANDT TJK81
Correction Reason
MANDT
JKAP KOSTL_L JKAP MANDT CSKS
Cost Center Master Data
MANDT
JKAP KOSTL_L JKAP KOKRS CSKS
Cost Center Master Data
KOKRS
JKAP KOSTL_L JKAP KOSTL_L CSKS
Cost Center Master Data
KOSTL
JKAP KOSTL_L * CSKS
Cost Center Master Data
DATBI
JKAP KUENDGRD JKAP MANDT TJK83
Sales Documents: Reasons for Cancellation of Delivery
MANDT
JKAP KUENDGRD JKAP KUENDGRD TJK83
Sales Documents: Reasons for Cancellation of Delivery
KUENDGRD
JKAP KUNWE JKAP MANDT JGTGPNR
IS-M: Central Business Partner Table
MANDT
JKAP KUNWE JKAP KUNWE JGTGPNR
IS-M: Central Business Partner Table
GPNR
JKAP LAND1 JKAP MANDT T005
Countries
MANDT
JKAP LAND1 JKAP LAND1 T005
Countries
LAND1
JKAP LANDE JKAP MANDT T005
Countries
MANDT
JKAP LANDE JKAP LANDE T005
Countries
LAND1
JKAP LIEFERART JKAP MANDT TJV01
Delivery type for issue
MANDT
JKAP LIEFERART JKAP LIEFERART TJV01
Delivery type for issue
LIEFERART
JKAP MANDT JKAP MANDT T000
Clients
MANDT
JKAP MATKL JKAP MATKL T023
Material Groups
MATKL
JKAP MATKL JKAP MANDT T023
Material Groups
MANDT
JKAP POART JKAP MANDT TJAP
Sales Order: Item Types
MANDT
JKAP POART JKAP POART TJAP
Sales Order: Item Types
POART
JKAP POSNR_MAIN JKAP MANDT JKAP
Sales Order - Item Data
MANDT
JKAP POSNR_MAIN JKAP VBELN JKAP
Sales Order - Item Data
VBELN
JKAP POSNR_MAIN JKAP POSNR_MAIN JKAP
Sales Order - Item Data
POSNR
JKAP POSNR_SUB JKAP MANDT JKAP
Sales Order - Item Data
MANDT
JKAP POSNR_SUB JKAP VBELN JKAP
Sales Order - Item Data
VBELN
JKAP POSNR_SUB JKAP POSNR_SUB JKAP
Sales Order - Item Data
POSNR
JKAP POSNR_UR JKAP POSNR_UR JKAP
Sales Order - Item Data
POSNR
JKAP POSNR_UR JKAP MANDT JKAP
Sales Order - Item Data
MANDT
JKAP POSNR_UR JKAP VBELN JKAP
Sales Order - Item Data
VBELN
JKAP POSNR_VG JKAP MANDT JKAP
Sales Order - Item Data
MANDT
JKAP POSNR_VG JKAP VBELN JKAP
Sales Order - Item Data
VBELN
JKAP POSNR_VG JKAP POSNR_VG JKAP
Sales Order - Item Data
POSNR
JKAP POSNR_VL JKAP VBELN_VL JKAP
Sales Order - Item Data
VBELN
JKAP POSNR_VL JKAP POSNR_VL JKAP
Sales Order - Item Data
POSNR
JKAP POSNR_VL JKAP MANDT JKAP
Sales Order - Item Data
MANDT
JKAP PVA JKAP DRERZ JDTPVA
IS-M/SD: Editions
DRERZ
JKAP PVA JKAP PVA JDTPVA
IS-M/SD: Editions
PVA
JKAP PVA JKAP MANDT JDTPVA
IS-M/SD: Editions
MANDT
JKAP PVABONGRP JKAP MANDT TJD49
IS-M/SD: Edition Bonus Grouping
MANDT
JKAP PVABONGRP JKAP PVABONGRP TJD49
IS-M/SD: Edition Bonus Grouping
PVABONGRP
JKAP PVAKNTGRP JKAP MANDT TVKM
Materials: Account Assignment Groups
MANDT
JKAP PVAKNTGRP JKAP PVAKNTGRP TVKM
Materials: Account Assignment Groups
KTGRM
JKAP PVAKONGRP JKAP MANDT TJD47
IS-M/SD: Edition Condition Grouping
MANDT
JKAP PVAKONGRP JKAP PVAKONGRP TJD47
IS-M/SD: Edition Condition Grouping
PVAKONGRP
JKAP REFUNDTYPE JKAP MANDT TJK19
IS-M/SD: Refund Type
MANDT
JKAP REFUNDTYPE JKAP REFUNDTYPE TJK19
IS-M/SD: Refund Type
REFUNDTYPE
JKAP SPART JKAP MANDT TSPA
Organizational Unit: Sales Divisions
MANDT
JKAP SPART JKAP SPART TSPA
Organizational Unit: Sales Divisions
SPART
JKAP STORNOGRD JKAP MANDT TJK91
Sales Documents: Reversal Reasons
MANDT
JKAP STORNOGRD JKAP STORNOGRD TJK91
Sales Documents: Reversal Reasons
STORNOGRD
JKAP UNTBRGRD JKAP MANDT TJK85
Sales Documents: Suspension Reason
MANDT
JKAP UNTBRGRD JKAP UNTBRGRD TJK85
Sales Documents: Suspension Reason
UNTBRGRD
JKAP VBELN JKAP VBELN JKAK
Sales Order Header Data
VBELN
JKAP VBELN JKAP MANDT JKAK
Sales Order Header Data
MANDT
JKAP VBELN_VL JKAP MANDT JKAK
Sales Order Header Data
MANDT
JKAP VBELN_VL JKAP VBELN_VL JKAK
Sales Order Header Data
VBELN
JKAP VKBURZUS JKAP MANDT TVBUR
Organizational Unit: Sales Offices
MANDT
JKAP VKBURZUS JKAP VKBURZUS TVBUR
Organizational Unit: Sales Offices
VKBUR
JKAP VSAUSSTART JKAP VSAUSSTART TJV09
IS-M/SD: Shipping Outsorting Types
VSAUSSTART
JKAP VSAUSSTART JKAP MANDT TJV09
IS-M/SD: Shipping Outsorting Types
MANDT
JKAP WBZSATZART JKAP WBZSATZART TJKW1
IS-M/SD: WBZ, Record Types
SATZART
JKAP WBZSATZART SYST MANDT TJKW1
IS-M/SD: WBZ, Record Types
MANDT
JKAP WBZVORGART SYST MANDT TJKW3
IS-M/SD: WBZ, Transaction Types
MANDT
JKAP WBZVORGART JKAP WBZSATZART TJKW3
IS-M/SD: WBZ, Transaction Types
SATZART
JKAP WBZVORGART JKAP WBZVORGART TJKW3
IS-M/SD: WBZ, Transaction Types
VORGANGART
JKAP WERBKZSCHL SYST MANDT TJKW9
IS-M/SD: WBZ, Promotion Rebate
MANDT
JKAP WERBKZSCHL JKAP WERBKZSCHL TJKW9
IS-M/SD: WBZ, Promotion Rebate
WERBKZSCHL