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
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
NULL No change
+ additive change
= change
ZSKLS Time slice classification for sales order JZSKLS CHAR 1 0
N Time slice - normal
U Time slice - unlimited planned change
B Time slice - limited planned change
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
X Yes
NULL No
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
X Yes
NULL No
ERLRE Completion rule for quotation / contract ERLRE CHAR 1 0
NULL Not relevant for completion
A Item is completed with the first reference
B Item is completed after full quantity has been referenced
C Item is completed after the target qty is fully referenced
D Item is referenced via contract release
E Item is completed after full target value is referenced
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
XDISPO Indicator: relevant to planning XDISPO CHAR 1 0
X Yes
NULL No
XUNVLIEFER IS-M: Viability Data Incomplete for Item XUNVLIEFER CHAR 1 0
X Yes
NULL No
XUNVLAUTO IS-M: Via.data incomp.for item (due to automatic change) XUNVLAUTO CHAR 1 0
X Yes
NULL No
RECHBEGINN Billing From RECHBEGINN DATS 8 0
RECHENDE Billing To RECHENDE DATS 8 0
XLIEFBAR Determine delivery viability XLIEFBAR CHAR 1 0
X Yes
NULL No
XIVW Indicator: Relevant for audit report XIVW CHAR 1 0
X Yes
NULL No
XFAKTURA Indicator: Relevant for billing XFAKTURA CHAR 1 0
X Yes
NULL No
PRSFD Carry out pricing PRSFD CHAR 1 0
NULL No pricing
X Pricing standard
A Pricing for empties
B Pricing for free goods (100% discount)
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
X Yes
NULL No
FAKSP Billing Block FAKTSPERRE TVFS CHAR 2 0
XFAKTSPERR IS-M: Billing block set XFAKTSPERR CHAR 1 0
X Yes
NULL No
XREMRECHT IS-M: Right of Return XREMRECHT CHAR 1 0
X Yes
NULL No
XBAGABR Indicator: BAG billing procedure XBAGABR CHAR 1 0
X Yes
NULL No
XURPOS Original item in publishing sales order XURPOS CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
REMART Return Type REMART CHAR 1 0
1 Single Issue Return
2 Summarized Return
3 Summarized Return with Advance Return
REMWEISE Return Method REMWEISE CHAR 1 0
1 Certificated Return
2 Full-Copy Return
REMQUOTE Expected return rate in percent REMQUOTE DEC 5 2
XMAXREMMG Expected return quantity is maximum return quantity XMAXREMMG CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
BEZIRK Carrier Route BEZIRK JVTBEZIRK CHAR 10 0
XLIEFGP IS-M: Delivery to business partner XLIEFGP CHAR 1 0
X Yes
NULL No
XLIEFBEZ IS-M: Delivery to a carrier route (reserve) XLIEFBEZ CHAR 1 0
X Yes
NULL No
XNEGOPTION IS-M: Item with Automatic Transformation to Chargeable XNEGOPTION CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
XEXPDATE Limited order change affects expiration date XEXPDATE CHAR 1 0
X Yes
NULL No
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
XDELIV_FIXED IS-M/SD: No Del.Viability Optimization (Parameters Fixed) XDELIV_FIXED CHAR 1 0
X Yes
NULL No
XNEW_PUBL IS-M/SD: Item created by change of publication XNEW_PUBL CHAR 1 0
X Yes
NULL No
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 Yes
NULL No
X_MONTAG IS-M: Monday X_MONTAG CHAR 1 0
X Yes
NULL No
X_DIENSTAG IS-M: Tuesday X_DIENSTAG CHAR 1 0
X Yes
NULL No
X_MITTWOCH IS-M: Wednesday X_MITTWOCH CHAR 1 0
X Yes
NULL No
X_DONNETAG IS-M: Thursday X_DONNETAG CHAR 1 0
X Yes
NULL No
X_FREITAG IS-M: Friday X_FREITAG CHAR 1 0
X Yes
NULL No
X_SAMSTAG IS-M: Saturday X_SAMSTAG CHAR 1 0
X Yes
NULL No
X_SONNTAG IS-M: Sunday X_SONNTAG CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
BONUSTYPE IS-M/SD: Bonus Type JBONUSTYPE CHAR 2 0
01 Bonus Day
02 Up-Give

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 MANDT TJD09 IS-M/SD: Service Type MANDT
JKAP BEZPERSE JKAP BEZPERSE TJD09 IS-M/SD: Service Type BEZPER
JKAP BEZUGGRD JKAP MANDT TJK87 Sales Documents: Purchase Reasons MANDT
JKAP BEZUGGRD JKAP BEZUGGRD TJK87 Sales Documents: Purchase Reasons BEZUGGRD
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 BEZUGSTYP JKAP PVA JDTBEZTYP IS-M: Mix Types (per Edition) PVATRA
JKAP BEZUGSTYP JKAP BEZUGSTYP JDTBEZTYP IS-M: Mix Types (per Edition) BEZTYP
JKAP DELIVSPLIT JKAP DELIVSPLIT TJD23 IS-M/SD: Alternating Address Elements DELIVSPLIT
JKAP DELIVSPLIT JKAP MANDT TJD23 IS-M/SD: Alternating Address Elements MANDT
JKAP DELIVSPLITGRP JKAP DELIVSPLITGRP TJD63 IS-M/SD: Address Alternation Groups DELIVSPLITGRP
JKAP DELIVSPLITGRP JKAP MANDT TJD63 IS-M/SD: Address Alternation Groups MANDT
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 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 ETENR_LAST JKAP MANDT JKEP Sales Order: Schedule Line Data MANDT
JKAP FAKSP JKAP FAKSP TVFS Billing: Reasons for Blocking FAKSP
JKAP FAKSP JKAP MANDT TVFS Billing: Reasons for Blocking MANDT
JKAP GSBER JKAP MANDT TGSB Business Areas MANDT
JKAP GSBER JKAP GSBER TGSB Business Areas GSBER
JKAP IVWKN JKAP MANDT TJI01 Audit Report Categories MANDT
JKAP IVWKN JKAP IVWKN TJI01 Audit Report Categories IVWKN
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 MANDT TJK81 Correction Reason MANDT
JKAP KORRGRD JKAP KORRGRD TJK81 Correction Reason KORRGRD
JKAP KOSTL_L * CSKS Cost Center Master Data DATBI
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 KUENDGRD JKAP KUENDGRD TJK83 Sales Documents: Reasons for Cancellation of Delivery KUENDGRD
JKAP KUENDGRD JKAP MANDT TJK83 Sales Documents: Reasons for Cancellation of Delivery MANDT
JKAP KUNWE JKAP KUNWE JGTGPNR IS-M: Central Business Partner Table GPNR
JKAP KUNWE JKAP MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JKAP LAND1 JKAP MANDT T005 Countries MANDT
JKAP LAND1 JKAP LAND1 T005 Countries LAND1
JKAP LANDE JKAP LANDE T005 Countries LAND1
JKAP LANDE JKAP MANDT T005 Countries MANDT
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 MANDT T023 Material Groups MANDT
JKAP MATKL JKAP MATKL T023 Material Groups MATKL
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 POSNR_SUB 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_UR JKAP MANDT JKAP Sales Order - Item Data MANDT
JKAP POSNR_UR JKAP VBELN JKAP Sales Order - Item Data VBELN
JKAP POSNR_UR JKAP POSNR_UR JKAP Sales Order - Item Data POSNR
JKAP POSNR_VG JKAP POSNR_VG JKAP Sales Order - Item Data POSNR
JKAP POSNR_VG JKAP MANDT JKAP Sales Order - Item Data MANDT
JKAP POSNR_VG JKAP VBELN JKAP Sales Order - Item Data VBELN
JKAP POSNR_VL JKAP MANDT JKAP Sales Order - Item Data MANDT
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 PVA JKAP MANDT JDTPVA IS-M/SD: Editions MANDT
JKAP PVA JKAP DRERZ JDTPVA IS-M/SD: Editions DRERZ
JKAP PVA JKAP PVA JDTPVA IS-M/SD: Editions PVA
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 STORNOGRD TJK91 Sales Documents: Reversal Reasons STORNOGRD
JKAP STORNOGRD JKAP MANDT TJK91 Sales Documents: Reversal Reasons MANDT
JKAP UNTBRGRD JKAP MANDT TJK85 Sales Documents: Suspension Reason MANDT
JKAP UNTBRGRD JKAP UNTBRGRD TJK85 Sales Documents: Suspension Reason UNTBRGRD
JKAP VBELN JKAP MANDT JKAK Sales Order Header Data MANDT
JKAP VBELN JKAP VBELN JKAK Sales Order Header Data VBELN
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 MANDT TJV09 IS-M/SD: Shipping Outsorting Types MANDT
JKAP VSAUSSTART JKAP VSAUSSTART TJV09 IS-M/SD: Shipping Outsorting Types VSAUSSTART
JKAP WBZSATZART SYST MANDT TJKW1 IS-M/SD: WBZ, Record Types MANDT
JKAP WBZSATZART JKAP WBZSATZART TJKW1 IS-M/SD: WBZ, Record Types SATZART
JKAP WBZVORGART JKAP WBZVORGART TJKW3 IS-M/SD: WBZ, Transaction Types VORGANGART
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 WERBKZSCHL SYST MANDT TJKW9 IS-M/SD: WBZ, Promotion Rebate MANDT
JKAP WERBKZSCHL JKAP WERBKZSCHL TJKW9 IS-M/SD: WBZ, Promotion Rebate WERBKZSCHL