SAP ABAP Table JKAK (Sales Order Header Data)

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	TRANSP	Transparent table
Transparent table	JKAK	Table Relationship Diagram
Short Description	Sales Order Header Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order
3	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
4	JPARVWGPAG	☐	JPARVWGPAG	JPARVWGPAG	CHAR	1	0	IS-M: Partner usage of sold-to party
5	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
6	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
7	VBTYP	☐	VBTYP_ISP	VBTYP_ISP	CHAR	1	0	Sales document category, IS-M
8	TRVOG	☐	TRVOG_ISP	TRVOG_ISP	CHAR	1	0	Transaction Group for IS-M Order Processing
9	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
10	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
11	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
12	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
13	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
14	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
15	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
16	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
17	VKBUR	☐	JVKBUR	VKBUR	CHAR	4	0	IS-M/SD: Receiving Sales Office	TVKBZ
18	EXEMPLART	☐	EXEMPLART	EXEMPLART	CHAR	1	0	IS-M: Copy Type
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
21	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
22	FAKSP	☐	FAKTSPERRE	FAKSP	CHAR	2	0	Billing Block	TVFS
23	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
24	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
25	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
26	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
27	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
28	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
29	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
30	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
31	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
32	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
33	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
34	XIMMATRIK	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
35	IMMATDAT	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
36	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
37	XREMRECHT	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
38	REMSP	☐	REMSP	XFELD	CHAR	1	0	IS-M: Billing Block for Return Notification
39	KORRGRD	☐	KORRGRD	KORRGRD	CHAR	3	0	IS-M: Reason for correction	TJK81
40	REMVON	☐	REMVON_ISP	DATUM	DATS	8	0	IS-M: Return date from
41	REMBIS	☐	REMBIS_ISP	DATUM	DATS	8	0	IS-M: Return date valid to
42	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
43	REMDATUM	☐	REMDAT_ISP	DATUM	DATS	8	0	IS-M: Date of return notification
44	REMSCHEIN	☐	RSCHEIN_IS	NUM6	NUMC	6	0	IS-M: Return slip number
45	IVWDATUM	☐	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns
46	POSNR_LAST	☐	POSNR_LAST	APNR	NUMC	6	0	Last Assigned Item Number	JKAP
47	POSEX_LAST	☐	POSEX_LAST	POSEX_ISP	NUMC	6	0	Last purchase order item number assigned
48	KPOSN_LAST	☐	KPOSN_LAST	NUM6	NUMC	6	0	IS-M: Last condition item number assigned
49	XFKBASAUFT	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
50	XFKBASLIEF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
51	XJKSOFAKT	☐	XJKSOFAKT	XFELD	CHAR	1	0	IS-M/SD: Immed.billing for credit memo request (subsc.only)
52	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
53	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
54	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
55	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
56	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
57	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
58	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
59	XWBZABO	☐	XWBZABO	XFELD	CHAR	1	0	IS-M: WBZ subscription
60	XFKVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
61	XSTATARC	☐	XJSTATARC	XFELD	CHAR	1	0	IS-M: Order archived in full (only placed in archive)
62	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
63	KALSM_AMO	☐	KALSM_AMO	KALSM	CHAR	6	0	IS-M/SD: Pricing Procedure for Amortization	T683
64	XRENEWAL	☐	XRENEWAL	XFELD	CHAR	1	0	IS-M/SD: Order extended by renewal offer
65	AMORTN	☐	AMORTN	AMORTN	CHAR	1	0	IS-M/SD: Use of Liability Account in Order
66	REKLERGB	☐	ISM_REKLERGB	ISM_REKLERGB	CHAR	2	0	IS-M: Complaint Result	TJK17
67	REKLTYP	☐	ISM_REKLTYP	ISM_REKLTYP	NUMC	1	0	IS-M: Complaint Category
68	REKLDATUM	☐	ISM_COMPLDATE	DATUM	DATS	8	0	IS-M/SD: Complaint Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKAK	AUART	TJAK	AUART	REF	1	CN
2	JKAK	BSARK	T176	BSARK	REF	C	CN
3	JKAK	FAKSP	TVFS	FAKSP	REF	C	CN
4	JKAK	GPAG	JGTGPNR	GPNR	KEY	1	CN
5	JKAK	GSBER	TGSB	GSBER	REF	C	CN
6	JKAK	GSKST	TGSB	GSBER	REF	C	CN
7	JKAK	KALSM	T683	KALSM	REF	C	CN
8	JKAK	KALSM_AMO	T683	KALSM	REF	C	CN
9	JKAK	KORRGRD	TJK81	KORRGRD	REF	C	CN
10	JKAK	KURST	TCURV	KURST	REF	C	CN
11	JKAK	MANDT	T000	MANDT	KEY	1	CN
12	JKAK	POSNR_LAST	JKAP	POSNR	REF	1	CN
13	JKAK	REKLERGB	TJK17	REKLERGB	KEY	1	CN
14	JKAK	SPART	TVTA	SPART	KEY	1	CN
15	JKAK	STAFO	TMCB	STAFO	REF	C	CN
16	JKAK	STWAE	TCURC	WAERS	REF	C	CN
17	JKAK	VKBUR	TVKBZ	VKBUR	REF	C	CN
18	JKAK	VKGRP	TVBVK	VKGRP	REF	C	CN
19	JKAK	VKORG	TVKO	VKORG	KEY	1	CN
20	JKAK	VTWEG	TVKOV	VTWEG	KEY	1	CN
21	JKAK	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in