1. Home
  2. Resources
  3. SAP Tables
  4. JKAK - Sales Order Header Data

SAP Table JKAK

Sales Order Header Data

JKAK (Sales Order Header 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 JKAK to other SAP tables.

JKAK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN IS-M/SD: Publishing Sales Order AVNR CHAR 10 0
GPAG Business Partner: Sold-to Party GPAG JGTGPNR CHAR 10 0
JPARVWGPAG IS-M: Partner usage of sold-to party JPARVWGPAG CHAR 1 0
1 Sales customer
2 Retailer
3 Social facility
4 Internal business partner
5 External publisher
6 General business partner
ANGDT Quotation/Inquiry is valid from ANGDT_V DATS 8 0
BNDDT Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 0
VBTYP Sales document category, IS-M VBTYP_ISP CHAR 1 0
A Inquiry
B Offer
C Order
H Return
I Free Delivery
K Credit Memo Request
L Debit Memo Request
M Invoice
N Reverse Invoice
O Credit Memo
P Debit Memo
S Reverse Credit Memo
U Pro Forma Invoice
TRVOG Transaction Group for IS-M Order Processing TRVOG_ISP CHAR 1 0
0 Subscription Order
1 Retail Order
2 Coupon Order
3 Transfer Distribution Order
4 Subscription Offer
5 Retail Offer
6 Currently not in use
7 Complaint
8 Return Notification
9 Commission Correction (curr.not in use)
A External Delivery Order
B Internal Order
C Coupon Confirmation
AUART IS-M/SD: Sales Document Types AUART_ISP TJAK CHAR 4 0
AUARTGRP IS-M/SD: Sales document type grouping JAUARTGRP CHAR 1 0
1 Subscription Order
2 Single Unit Sales Order
3 Reserve Order
4 Free Copy Delivery Order
5 Return Notification
6 Credit/Debit Memo Requirements
7 Charitable Transfer
8 Ad Pre-Print Order
9 Coupon Order
B Voucher Copy Order
C Coupon Confirmation
WAERK SD Document Currency WAERK TCURC CUKY 5 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division for order header SPART_AK TVTA CHAR 2 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
VKBUR IS-M/SD: Receiving Sales Office JVKBUR TVKBZ CHAR 4 0
EXEMPLART IS-M: Copy Type EXEMPLART CHAR 1 0
0 Customer copies
1 Promotional copies
2 Reserve copies
GSBER Business Area GSBER TGSB CHAR 4 0
GSKST Business area from cost center GSKST TGSB CHAR 4 0
KNUMV Number of the document condition KNUMV CHAR 10 0
FAKSP Billing Block FAKTSPERRE TVFS CHAR 2 0
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD T683 CHAR 6 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSARK Customer purchase order type BSARK T176 CHAR 4 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSTZD Purchase order number supplement BSTZD CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
BNAME Name of orderer BNAME_V CHAR 35 0
TELF1 Telephone Number TELF1_VP CHAR 16 0
STAFO Update group for statistics update STAFO TMCB CHAR 6 0
STWAE Statistics currency STWAE TCURC CUKY 5 0
XIMMATRIK Indicator: Proof of matriculation provided XIMMATRIK CHAR 1 0
X Yes
NULL No
IMMATDAT Matriculation Certificate Valid To IMMATDAT DATS 8 0
XSEPFKKOPF Separate billing document for sales order XSEPFKKOPF CHAR 1 0
X Yes
NULL No
XREMRECHT IS-M: Right of Return XREMRECHT CHAR 1 0
X Yes
NULL No
REMSP IS-M: Billing Block for Return Notification REMSP CHAR 1 0
X Yes
NULL No
KORRGRD IS-M: Reason for correction KORRGRD TJK81 CHAR 3 0
REMVON IS-M: Return date from REMVON_ISP DATS 8 0
REMBIS IS-M: Return date valid to REMBIS_ISP DATS 8 0
REFBELEG IS-M/SD: Reference Document in Legacy System REMELD_ISP CHAR 20 0
REMDATUM IS-M: Date of return notification REMDAT_ISP DATS 8 0
REMSCHEIN IS-M: Return slip number RSCHEIN_IS NUMC 6 0
IVWDATUM Date of Audit Report for Returns IVWDATUM DATS 8 0
POSNR_LAST Last Assigned Item Number POSNR_LAST JKAP NUMC 6 0
POSEX_LAST Last purchase order item number assigned POSEX_LAST NUMC 6 0
KPOSN_LAST IS-M: Last condition item number assigned KPOSN_LAST NUMC 6 0
XFKBASAUFT IS-M: Billing based on order XFKBASAUFT CHAR 1 0
X Yes
NULL No
XFKBASLIEF IS-M: Billing based on delivery XFKBASLIEF CHAR 1 0
X Yes
NULL No
XJKSOFAKT IS-M/SD: Immed.billing for credit memo request (subsc.only) XJKSOFAKT CHAR 1 0
X Yes
NULL No
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
XWBZABO IS-M: WBZ subscription XWBZABO CHAR 1 0
X Yes
NULL No
XFKVDICHT IS-M: Summarize deliveries according to billing item XFKVDICHT CHAR 1 0
X Yes
NULL No
XSTATARC IS-M: Order archived in full (only placed in archive) XJSTATARC CHAR 1 0
X Yes
NULL No
XNOMESS IS-M: Indicator - Do Not Perform Output Determination XNOMESS CHAR 1 0
X Yes
NULL No
KALSM_AMO IS-M/SD: Pricing Procedure for Amortization KALSM_AMO T683 CHAR 6 0
XRENEWAL IS-M/SD: Order extended by renewal offer XRENEWAL CHAR 1 0
X Yes
NULL No
AMORTN IS-M/SD: Use of Liability Account in Order AMORTN CHAR 1 0
NULL No liability account
A Manage liability account in money
B Manage liability account in deliveries
C Manage liability account in money w/o ref.to performance
REKLERGB IS-M: Complaint Result ISM_REKLERGB TJK17 CHAR 2 0
REKLTYP IS-M: Complaint Category ISM_REKLTYP NUMC 1 0
1 Subsequent Delivery
2 Credit Memo
3 Complex Complaint
4 Only Comment (Texts)
5 Liability Account
REKLDATUM IS-M/SD: Complaint Date ISM_COMPLDATE DATS 8 0

JKAK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JKAK AUART JKAK MANDT TJAK IS-M/SD: Sales Document Type MANDT
JKAK AUART JKAK AUART TJAK IS-M/SD: Sales Document Type AUART
JKAK BSARK JKAK MANDT T176 Sales Documents: Customer Order Types MANDT
JKAK BSARK JKAK BSARK T176 Sales Documents: Customer Order Types BSARK
JKAK FAKSP JKAK MANDT TVFS Billing: Reasons for Blocking MANDT
JKAK FAKSP JKAK FAKSP TVFS Billing: Reasons for Blocking FAKSP
JKAK GPAG JKAK MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JKAK GPAG JKAK GPAG JGTGPNR IS-M: Central Business Partner Table GPNR
JKAK GSBER JKAK MANDT TGSB Business Areas MANDT
JKAK GSBER JKAK GSBER TGSB Business Areas GSBER
JKAK GSKST JKAK MANDT TGSB Business Areas MANDT
JKAK GSKST JKAK GSKST TGSB Business Areas GSBER
JKAK KALSM T681A KAPPL T683 Pricing procedures KAPPL
JKAK KALSM JKAK KALSM T683 Pricing procedures KALSM
JKAK KALSM JKAK MANDT T683 Pricing procedures MANDT
JKAK KALSM T681V KVEWE T683 Pricing procedures KVEWE
JKAK KALSM_AMO JKAK KALSM_AMO T683 Pricing procedures KALSM
JKAK KALSM_AMO JKAK MANDT T683 Pricing procedures MANDT
JKAK KALSM_AMO T681V KVEWE T683 Pricing procedures KVEWE
JKAK KALSM_AMO T681A KAPPL T683 Pricing procedures KAPPL
JKAK KORRGRD JKAK KORRGRD TJK81 Correction Reason KORRGRD
JKAK KORRGRD JKAK MANDT TJK81 Correction Reason MANDT
JKAK KURST JKAK MANDT TCURV Exchange rate types for currency translation MANDT
JKAK KURST JKAK KURST TCURV Exchange rate types for currency translation KURST
JKAK MANDT JKAK MANDT T000 Clients MANDT
JKAK POSNR_LAST JKAK POSNR_LAST JKAP Sales Order - Item Data POSNR
JKAK POSNR_LAST JKAK MANDT JKAP Sales Order - Item Data MANDT
JKAK POSNR_LAST JKAK VBELN JKAP Sales Order - Item Data VBELN
JKAK REKLERGB JKAK MANDT TJK17 IS-M/SD: Complaint Result MANDT
JKAK REKLERGB JKAK REKLERGB TJK17 IS-M/SD: Complaint Result REKLERGB
JKAK SPART JKAK SPART TVTA Organizational Unit: Sales Area(s) SPART
JKAK SPART JKAK MANDT TVTA Organizational Unit: Sales Area(s) MANDT
JKAK SPART JKAK VKORG TVTA Organizational Unit: Sales Area(s) VKORG
JKAK SPART JKAK VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
JKAK STAFO JKAK MANDT TMCB Update groups MANDT
JKAK STAFO JKAK STAFO TMCB Update groups STAFO
JKAK STWAE JKAK MANDT TCURC Currency Codes MANDT
JKAK STWAE JKAK STWAE TCURC Currency Codes WAERS
JKAK VKBUR JKAK SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
JKAK VKBUR JKAK VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
JKAK VKBUR JKAK MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
JKAK VKBUR JKAK VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
JKAK VKBUR JKAK VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
JKAK VKGRP JKAK VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
JKAK VKGRP JKAK MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
JKAK VKGRP JKAK VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
JKAK VKORG JKAK MANDT TVKO Organizational Unit: Sales Organizations MANDT
JKAK VKORG JKAK VKORG TVKO Organizational Unit: Sales Organizations VKORG
JKAK VTWEG JKAK VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
JKAK VTWEG JKAK VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
JKAK VTWEG JKAK MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
JKAK WAERK JKAK MANDT TCURC Currency Codes MANDT
JKAK WAERK JKAK WAERK TCURC Currency Codes WAERS