SAP ABAP Table JKAPVB (Reference Structure for XJKAP)

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	JKAPVB	Table Relationship Diagram
Short Description	Reference Structure for XJKAP

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
141	POART_EX	☐	POART_EX	POART_EX	CHAR	2	0	Item type of external sales order
142	VORLAUFDAT	☐	VORLAUFDAT	DATUM	DATS	8	0	Date of shipping preparation as deadline for order changes
143	VBELN_BAS	☐	VBELN_BAS	AVNR	CHAR	10	0	IS-M: Document number of basic document	*
144	POSNR_BAS	☐	POSNR_BAS	APNR	NUMC	6	0	IS-M: Item number from basic document	*
145	XGELIEFERT	☐	XGELIEFERT	XFELD	CHAR	1	0	IS-M: Item already delivered
146	XFAKTRIERT	☐	XFAKTRIERT	XFELD	CHAR	1	0	IS-M: Billing already performed for item
147	XFAKT_UR	☐	XFAKT_UR	XFELD	CHAR	1	0	IS-M: Billing already performed for original item
148	FAKBIS	☐	FAKBIS	DATUM	DATS	8	0	IS-M: Billing Period To
149	XSCRIPTACT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
150	XACCEPTED	☐			CHAR	1	0
151	ACCEPTED_DATE	☐	DATUM	DATUM	DATS	8	0	Date
152	ACCEPTED_CYCLENR	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
153	XOFFERED	☐			CHAR	1	0
154	XTO_BILL	☐			CHAR	1	0
155	XDEACCEPTED	☐			CHAR	1	0
156	DEACC_CYCLENR	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
157	XWERBFAKT	☐			CHAR	1	0
158	XREAMO	☐			CHAR	1	0
159	XAMO_POST	☐			CHAR	1	0
160	XDEAMO_POST	☐			CHAR	1	0
161	XVARIABLEDAYS	☐	XVARIABLEDAYS	XFELD	CHAR	1	0	IS-M/SD: Select Weekdays in Order
162	XAMORTIZED	☐			CHAR	1	0
163	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	JKAPVB	BEZIRK	JVTBEZIRK	BEZIRK	REF	C	CN
2	JKAPVB	BEZPERSE	TJD09	BEZPER	REF	C	CN
3	JKAPVB	BEZUGGRD	TJK87	BEZUGGRD	REF	C	CN
4	JKAPVB	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
5	JKAPVB	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
6	JKAPVB	DELIVSPLITGRP	TJD63	DELIVSPLITGRP	REF	C	CN
7	JKAPVB	DRERZ	JDTDRER	DRERZ	REF	C	CN
8	JKAPVB	DRUCKEREI	T001W	WERKS	REF	C	CN
9	JKAPVB	ETENR_LAST	JKEP	ETENR	REF	C	CN
10	JKAPVB	FAKSP	TVFS	FAKSP	REF	C	CN
11	JKAPVB	GSBER	TGSB	GSBER	REF	C	CN
12	JKAPVB	IVWKN	TJI01	IVWKN	REF	C	CN
13	JKAPVB	IVWKNFREI	TJI01	IVWKN	REF	C	CN
14	JKAPVB	JNBRIEFTYP	TJN11	JNBRIEFTYP	REF	C	CN
15	JKAPVB	KOKRS	TKA01	KOKRS	REF	C	CN
16	JKAPVB	KORRGRD	TJK81	KORRGRD	REF	C	CN
17	JKAPVB	KOSTL_L	CSKS	KOSTL	REF	C	CN
18	JKAPVB	KUENDGRD	TJK83	KUENDGRD	REF	C	CN
19	JKAPVB	KUNWE	JGTGPNR	GPNR	REF	C	CN
20	JKAPVB	LAND1	T005	LAND1	REF	C	CN
21	JKAPVB	LANDE	T005	LAND1	REF	C	CN
22	JKAPVB	LIEFERART	TJV01	LIEFERART	REF	C	CN
23	JKAPVB	MANDT	T000	MANDT	KEY	1	CN
24	JKAPVB	MATKL	T023	MATKL	REF	C	CN
25	JKAPVB	POART	TJAP	POART	REF	1	CN
26	JKAPVB	POSNR_MAIN	JKAP	POSNR	REF	C	CN
27	JKAPVB	POSNR_SUB	JKAP	POSNR	REF	C	CN
28	JKAPVB	POSNR_UR	JKAP	POSNR	REF	1	CN
29	JKAPVB	POSNR_VG	JKAP	POSNR	REF	1	CN
30	JKAPVB	POSNR_VL	JKAP	POSNR	REF	C	CN
31	JKAPVB	PVA	JDTPVA	PVA	REF	C	CN
32	JKAPVB	PVABONGRP	TJD49	PVABONGRP	REF	C	CN
33	JKAPVB	PVAKNTGRP	TVKM	KTGRM	REF	C	CN
34	JKAPVB	PVAKONGRP	TJD47	PVAKONGRP	REF	C	CN
35	JKAPVB	REFUNDTYPE	TJK19	REFUNDTYPE	REF
36	JKAPVB	SPART	TSPA	SPART	REF	C	CN
37	JKAPVB	STORNOGRD	TJK91	STORNOGRD	REF	C	CN
38	JKAPVB	UNTBRGRD	TJK85	UNTBRGRD	REF	C	CN
39	JKAPVB	VBELN	JKAK	VBELN	KEY	1	CN
40	JKAPVB	VBELN_VL	JKAK	VBELN	REF	C	CN
41	JKAPVB	VKBURZUS	TVBUR	VKBUR	REF	C	CN
42	JKAPVB	VSAUSSTART	TJV09	VSAUSSTART	REF	C	CN
43	JKAPVB	WBZSATZART	TJKW1	SATZART
44	JKAPVB	WBZVORGART	TJKW3	VORGANGART
45	JKAPVB	WERBKZSCHL	TJKW9	WERBKZSCHL		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in