SAP ABAP Table JKAPN (Sales Order: Standard Item)

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	JKAPN	Table Relationship Diagram
Short Description	Sales Order: Standard Item

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

History

Last changed by/on	SAP	20110901
SAP Release Created in