SAP ABAP Table JKAP (Sales Order - Item 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	JKAP	Table Relationship Diagram
Short Description	Sales Order - Item 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	JKAK
3	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item
4	GUELTIGVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
5	GUELTIGBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
6	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
7	AEART	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
8	ZSKLS	☐	JZSKLS	JZSKLS	CHAR	1	0	Time slice classification for sales order
9	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
10	KUNWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	JGTGPNR
11	KUNWEFREMD	☐	JKUNNRVERL	JKUNNRVERL	CHAR	15	0	Cust.No. with External Company (External Deliveries/Retail)
12	LANDE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	T005
13	LAND1	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	T005
14	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
15	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
16	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
17	XRUECKABO	☐	XRUECKABO	XFELD	CHAR	1	0	IS-M: Backdated subscription created
18	LIEFVON	☐	LIEFVON	DATUM	DATS	8	0	Regular start of delivery for item in sales order
19	SPART	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	TSPA
20	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
21	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
22	VOREF	☐	VOREF	XFELD	CHAR	1	0	Complete reference indicator
23	ERLRE	☐	ERLRE	ERLRE	CHAR	1	0	Completion rule for quotation / contract
24	TAXM1	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
25	TAXM2	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
26	TAXM3	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
27	TAXM4	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
28	TAXM5	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
29	TAXM6	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
30	TAXM7	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
31	TAXM8	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
32	TAXM9	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
33	VGREF	☐	VGREF	XFELD	CHAR	1	0	Preceding document has resulted from reference
34	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
35	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
36	IVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
37	IVWKNFREI	☐	IVWKNFREI	IVWKN	CHAR	8	0	Circulation Report Category ID for Non-Calculation Period	TJI01
38	XLIEFSE	☐	XLIEFSE	XFELD	CHAR	1	0	Delivery to social facility
39	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
40	LIEFXUHR	☐	LIEFXUHR	UZEIT	TIMS	6	0	Time of latest delivery
41	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	T001W
42	VSAUSSTART	☐	VSAUSSTART	VSAUSSTART	CHAR	2	0	Shipping outsorting type	TJV09
43	UNTBRGRD	☐	UNTBRGRD	UNTBRGRD	CHAR	3	0	Reason for Suspension	TJK85
44	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	TJK87
45	KORRGRD	☐	KORRGRD	KORRGRD	CHAR	3	0	IS-M: Reason for correction	TJK81
46	GUTSCHEIN	☐	GUTSCHEIN	GUTSCHEIN	NUMC	8	0	Coupon Number
47	XGUTSCHEIN	☐	XGUTSCHEIN	XFELD	CHAR	1	0	Indicator: Vouchers allowed
48	XDISPO	☐	XDISPO	XFELD	CHAR	1	0	Indicator: relevant to planning
49	XUNVLIEFER	☐	XUNVLIEFER	XFELD	CHAR	1	0	IS-M: Viability Data Incomplete for Item
50	XUNVLAUTO	☐	XUNVLAUTO	XFELD	CHAR	1	0	IS-M: Via.data incomp.for item (due to automatic change)
51	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
52	RECHENDE	☐	RECHENDE	DATUM	DATS	8	0	Billing To
53	XLIEFBAR	☐	XLIEFBAR	XFELD	CHAR	1	0	Determine delivery viability
54	XIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
55	XFAKTURA	☐	XFAKTURA	XFELD	CHAR	1	0	Indicator: Relevant for billing
56	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
57	SBFREI	☐	SBFREI	USNAM	CHAR	12	0	Administrator responsible for free copies
58	WDVDAT	☐	WDVDAT	DATUM	DATS	8	0	Resubmission date
59	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	TJK83
60	XLOGO	☐	XLOGO	XFELD	CHAR	1	0	Print Logo
61	FAKSP	☐	FAKTSPERRE	FAKSP	CHAR	2	0	Billing Block	TVFS
62	XFAKTSPERR	☐	XFAKTSPERR	XFELD	CHAR	1	0	IS-M: Billing block set
63	XREMRECHT	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
64	XBAGABR	☐	XBAGABR	XFELD	CHAR	1	0	Indicator: BAG billing procedure
65	XURPOS	☐	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order
66	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
67	POSNR_VG	☐	APNR_VG	APNR	NUMC	6	0	Preceding Item in Publishing Sales Order	JKAP
68	VBELN_VL	☐	AVNR_VL	AVNR	CHAR	10	0	Reference Document	JKAK
69	POSNR_VL	☐	APNR_VL	APNR	NUMC	6	0	Reference Document Item	JKAP
70	PVAKNTGRP	☐	PVAKNTGRP	KTGRM	CHAR	2	0	Account Assignment Grouping for Edition	TVKM
71	PVAKONGRP	☐	PVAKONGRP	JKONDM	CHAR	2	0	Condition Grouping for Edition	TJD47
72	PVABONGRP	☐	PVABONGRP	JBONUS	CHAR	2	0	Edition bonus grouping	TJD49
73	XTECHVORB	☐	XTECHVORB	XFELD	CHAR	1	0	Indicator: Technical problem
74	REMART	☐	REMART	REMART	CHAR	1	0	Return Type
75	REMWEISE	☐	REMWEISE	REMWEISE	CHAR	1	0	Return Method
76	REMQUOTE	☐	REMQUOTE	ISPNUM32	DEC	5	2	Expected return rate in percent
77	XMAXREMMG	☐	XMAXREMMG	XFELD	CHAR	1	0	Expected return quantity is maximum return quantity
78	ETENR_LAST	☐	ETENR_LAST	AENR	NUMC	4	0	Last Schedule Line Number Assigned	JKEP
79	ETEEX_LAST	☐	ETEEX_LAST	ETEEX	NUMC	6	0	Last Schedule Line Number Assigned
80	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
81	KOSTL_L	☐	KOSTL_L	KOSTL	CHAR	10	0	Debit Cost Center	CSKS
82	XPATE	☐	XPATE	XFELD	CHAR	1	0	IS-M: Sponsored subscription
83	BEZIRK	☐	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	JVTBEZIRK
84	XLIEFGP	☐	XLIEFGP	XFELD	CHAR	1	0	IS-M: Delivery to business partner
85	XLIEFBEZ	☐	XLIEFBEZ	XFELD	CHAR	1	0	IS-M: Delivery to a carrier route (reserve)
86	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
87	BEZPERSE	☐	BEZPERSE	BEZPER	CHAR	5	0	IS-M: Service Type for Social Facility	TJD09
88	VSOZMENGE	☐	VSOZMENGE	MENGGPOS	QUAN	10	0	IS-M: Maximum schedule line quantity for social facility
89	LFBARDAT	☐	LFBARDAT	DATUM	DATS	8	0	Delivery viability set for sales order item valid from
90	SHKZG	☐	SHKZG_ISP	XFELD	CHAR	1	0	IS-M: Debit indicator for schedule line
91	VKBURZUS	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	TVBUR
92	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
93	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
94	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
95	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
96	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
97	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
98	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
99	XSTORNO	☐	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
100	STORNOGRD	☐	STORNOGRD	STORNOGRD	CHAR	3	0	Reversal Reason	TJK91
101	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
102	XSCRIPT	☐	XSCRIPT	XFELD	CHAR	1	0	SAPscript comment recorded
103	.INCLUDE	☐				0	0	IS-PSD: WBZ Fields Relevant in Order Item
104	WBZSATZART	☐	JWBZSTZART	JWBZSTZART	CHAR	3	0	IS-M: WBZ, Record Type	TJKW1
105	WBZVORGART	☐	JWBZVORART	JWBZVORART	CHAR	3	0	IS-M: WBZ, Operation Type	TJKW3
106	WERBKZSCHL	☐	JWBZWKZSCH	JWBZWKZSCH	CHAR	1	0	IS-M: WBZ, Promotion Rebate Key	TJKW9
107	WBZABOKUNR	☐	JWBZABOKNR	JWBZABOKNR	CHAR	9	0	IS-M: Subscription Customer Number
108	XWBZRUECKU	☐	XJWBZRUECK	XFELD	CHAR	1	0	IS-M: WBZ, reply to WBZ company required
109	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
110	VERTRKENNZ	☐	JWBZVKENNZ	JWBZVKENNZ	CHAR	5	0	IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)	*
111	WBZTERMIN	☐	JWBZTERMIN	CHAR9	CHAR	9	0	IS-M: WBZ, Date (Format: MMYYYYCCCC)
112	WBZVERTRETER	☐	JWBZVERTR	CHAR07	CHAR	7	0	IS-M: WBZ, representative indicator
113	XSEPARATVS	☐	JXSEPRATVS	XFELD	CHAR	1	0	IS-M: Separate first delivery
114	HEFTNUMVON	☐	HEFTNUMVON	HEFTNUMMER	CHAR	9	0	Copy Number of First Issue to be Delivered
115	HEFTNUMBIS	☐	HEFTNUMBIS	HEFTNUMMER	CHAR	9	0	Copy Number of Last Issue for Delivery
116	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
117	JNBRIEFTYP	☐	JNBRIEFTYP	JNBRIEFTYP	CHAR	4	0	Letter type for generating letters using output control	TJN11
118	XFMODRUECK	☐	XFMODRUECK	XFELD	CHAR	1	0	IS-M: Backdated changes to billing method
119	XEXPDATE	☐	XEXPDATE	XFELD	CHAR	1	0	Limited order change affects expiration date
120	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
121	XDELIV_FIXED	☐	XDELIV_FIXED	XFELD	CHAR	1	0	IS-M/SD: No Del.Viability Optimization (Parameters Fixed)
122	XNEW_PUBL	☐	XNEW_PUBL	XFELD	CHAR	1	0	IS-M/SD: Item created by change of publication
123	DELIVSPLITGRP	☐	DELIVSPLITGRP	DELIVSPLITGRP	CHAR	10	0	IS-M/SD: Address Alternation Group	TJD63
124	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	TJD23
125	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	JKAP
126	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	JKAP
127	XMAINSPLIT	☐	XMAINSPLIT	XFELD	CHAR	1	0	Item for this Alternating Add. Element is a Main Sub-Item
128	.INCLUDE	☐				0	0	IS-M/SD: Field String for Weekdays
129	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
130	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
131	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
132	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
133	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
134	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
135	X_SONNTAG	☐	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday
136	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
137	REFUNDTYPE	☐	REFUNDTYPE	REFUNDTYPE	CHAR	2	0	IS-M/SD: Refund Type	TJK19
138	XVACPACK	☐	XVACPACK	XFELD	CHAR	1	0	IS-M/SD: Vacation Service: Postponed Delivery
139	BONUSTYPE	☐	JBONUSTYPE	JBONUSTYPE	CHAR	2	0	IS-M/SD: Bonus Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKAP	BEZIRK	JVTBEZIRK	BEZIRK	REF	C	CN
2	JKAP	BEZPERSE	TJD09	BEZPER	REF	C	CN
3	JKAP	BEZUGGRD	TJK87	BEZUGGRD	REF	C	CN
4	JKAP	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
5	JKAP	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
6	JKAP	DELIVSPLITGRP	TJD63	DELIVSPLITGRP	REF	C	CN
7	JKAP	DRERZ	JDTDRER	DRERZ	REF	C	CN
8	JKAP	DRUCKEREI	T001W	WERKS	REF	C	CN
9	JKAP	ETENR_LAST	JKEP	ETENR	REF	C	CN
10	JKAP	FAKSP	TVFS	FAKSP	REF	C	CN
11	JKAP	GSBER	TGSB	GSBER	REF	C	CN
12	JKAP	IVWKN	TJI01	IVWKN	REF	C	CN
13	JKAP	IVWKNFREI	TJI01	IVWKN	REF	C	CN
14	JKAP	JNBRIEFTYP	TJN11	JNBRIEFTYP	REF	C	CN
15	JKAP	KOKRS	TKA01	KOKRS	REF	C	CN
16	JKAP	KORRGRD	TJK81	KORRGRD	REF	C	CN
17	JKAP	KOSTL_L	CSKS	KOSTL	REF	C	CN
18	JKAP	KUENDGRD	TJK83	KUENDGRD	REF	C	CN
19	JKAP	KUNWE	JGTGPNR	GPNR	REF	C	CN
20	JKAP	LAND1	T005	LAND1	REF	C	CN
21	JKAP	LANDE	T005	LAND1	REF	C	CN
22	JKAP	LIEFERART	TJV01	LIEFERART	REF	C	CN
23	JKAP	MANDT	T000	MANDT	KEY	1	CN
24	JKAP	MATKL	T023	MATKL	REF	C	CN
25	JKAP	POART	TJAP	POART	REF	1	CN
26	JKAP	POSNR_MAIN	JKAP	POSNR	REF	C	CN
27	JKAP	POSNR_SUB	JKAP	POSNR	REF	C	CN
28	JKAP	POSNR_UR	JKAP	POSNR	REF	1	CN
29	JKAP	POSNR_VG	JKAP	POSNR	REF	1	CN
30	JKAP	POSNR_VL	JKAP	POSNR	REF	C	CN
31	JKAP	PVA	JDTPVA	PVA	REF	C	CN
32	JKAP	PVABONGRP	TJD49	PVABONGRP	REF	C	CN
33	JKAP	PVAKNTGRP	TVKM	KTGRM	REF	C	CN
34	JKAP	PVAKONGRP	TJD47	PVAKONGRP	REF	C	CN
35	JKAP	REFUNDTYPE	TJK19	REFUNDTYPE	REF
36	JKAP	SPART	TSPA	SPART	REF	C	CN
37	JKAP	STORNOGRD	TJK91	STORNOGRD	REF	C	CN
38	JKAP	UNTBRGRD	TJK85	UNTBRGRD	REF	C	CN
39	JKAP	VBELN	JKAK	VBELN	KEY	1	CN
40	JKAP	VBELN_VL	JKAK	VBELN	REF	C	CN
41	JKAP	VKBURZUS	TVBUR	VKBUR	REF	C	CN
42	JKAP	VSAUSSTART	TJV09	VSAUSSTART	REF	C	CN
43	JKAP	WBZSATZART	TJKW1	SATZART
44	JKAP	WBZVORGART	TJKW3	VORGANGART
45	JKAP	WERBKZSCHL	TJKW9	WERBKZSCHL		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in