SAP ABAP Table JKAKVB (Reference Structure for XJKAK)

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	INTTAB	Structure
Structure	JKAKVB	Table Relationship Diagram
Short Description	Reference Structure for XJKAK

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in