SAP ABAP Table JKVAKTEP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVAKTEP	Table Relationship Diagram
Short Description	Generated Table for View

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	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	JKAP
4	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line
5	GUELTIGVON	☐	JKEPVON	DATUM	DATS	8	0	Date from Which Schedule Line in Sales Order is Valid
6	GUELTIGBIS	☐	JKEPBIS	DATUM	DATS	8	0	Date to Which Schedule Line in Sales Order is Valid
7	ETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	TJEP
8	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
9	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
10	ETVORZEI	☐	ETVORZEI	VORZEI	CHAR	1	0	Plus/Minus Sign for Schedule Line Quantity in Sales Order
11	ANZET	☐	ANZET	ANZET	DEC	5	0	Number of Publication Dates
12	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
13	SPARTDRERZ	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	TSPA
14	AEART	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
15	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
16	KUNWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	JGTGPNR
17	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
18	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
19	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
20	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
21	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
22	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
23	FAKSP	☐	FAKTSPERRE	FAKSP	CHAR	2	0	Billing Block	TVFS
24	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
25	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
26	VKBUR	☐	JVKBUR	VKBUR	CHAR	4	0	IS-M/SD: Receiving Sales Office	TVKBZ
27	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
28	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
29	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
30	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
31	JKAPVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
32	JKAPBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
33	POSNR_VG	☐	APNR_VG	APNR	NUMC	6	0	Preceding Item in Publishing Sales Order	JKAP
34	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
35	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
36	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
37	VKBURZUS	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	TVBUR
38	REMSP	☐	REMSP	XFELD	CHAR	1	0	IS-M: Billing Block for Return Notification
39	XFKBASAUFT	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
40	XFKBASLIEF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
41	XSTORNO	☐	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
42	STORNOGRD	☐	STORNOGRD	STORNOGRD	CHAR	3	0	Reversal Reason	TJK91
43	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	TJK83
44	XFKVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
45	XLIEFBEZ	☐	XLIEFBEZ	XFELD	CHAR	1	0	IS-M: Delivery to a carrier route (reserve)
46	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
47	RECHENDE	☐	RECHENDE	DATUM	DATS	8	0	Billing To
48	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	TJK87
49	IVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
50	IVWLAND	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	T005
51	NETWR	☐	NETWR_ISP	WERTV8	CURR	15	2	IS-M: Net price in document currency
52	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
53	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
54	HEFTNUMVON	☐	HEFTNUMVON	HEFTNUMMER	CHAR	9	0	Copy Number of First Issue to be Delivered
55	HEFTNUMBIS	☐	HEFTNUMBIS	HEFTNUMMER	CHAR	9	0	Copy Number of Last Issue for Delivery
56	PRSBINDDAT	☐	PRSBINDDAT	DATUM	DATS	8	0	To-date for price fixing
57	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
58	XRENEWAL	☐	XRENEWAL	XFELD	CHAR	1	0	IS-M/SD: Order extended by renewal offer
59	VBTYP	☐	VBTYP_ISP	VBTYP_ISP	CHAR	1	0	Sales document category, IS-M
60	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	JKAP
61	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	JKAP
62	XURPOS	☐	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order
63	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
64	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
65	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
66	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
67	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
68	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
69	X_SONNTAG	☐	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKVAKTEP	AUART	TJAK	AUART	REF	1	CN
2	JKVAKTEP	BEZPER	TJD09	BEZPER	REF	1	CN
3	JKVAKTEP	BEZUGGRD	TJK87	BEZUGGRD	REF	C	CN
4	JKVAKTEP	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
5	JKVAKTEP	DRERZ	JDTDRER	DRERZ	REF	C	CN
6	JKVAKTEP	ETART	TJEP	ETART	REF	1	CN
7	JKVAKTEP	ETMEINS	T006	MSEHI	REF	C	CN
8	JKVAKTEP	FAKSP	TVFS	FAKSP	REF	C	CN
9	JKVAKTEP	GPAG	JGTGPNR	GPNR	KEY	1	CN
10	JKVAKTEP	IVWKN	TJI01	IVWKN	REF	C	CN
11	JKVAKTEP	IVWLAND	T005	LAND1	REF	C	CN
12	JKVAKTEP	KUENDGRD	TJK83	KUENDGRD	REF	C	CN
13	JKVAKTEP	KUNWE	JGTGPNR	GPNR	REF	C	CN
14	JKVAKTEP	LIEFERART	TJV01	LIEFERART	REF	C	CN
15	JKVAKTEP	MANDT	T000	MANDT	KEY	1	CN
16	JKVAKTEP	POART	TJAP	POART	REF	1	CN
17	JKVAKTEP	POSNR	JKAP	POSNR	KEY	1	CN
18	JKVAKTEP	POSNR_MAIN	JKAP	POSNR	REF	C	CN
19	JKVAKTEP	POSNR_SUB	JKAP	POSNR	REF	C	CN
20	JKVAKTEP	POSNR_UR	JKAP	POSNR	REF	1	CN
21	JKVAKTEP	POSNR_VG	JKAP	POSNR	REF	1	CN
22	JKVAKTEP	PVA	JDTPVA	PVA	REF	C	CN
23	JKVAKTEP	SPART	TVTA	SPART	KEY	1	CN
24	JKVAKTEP	SPARTDRERZ	TSPA	SPART	REF	C	CN
25	JKVAKTEP	STORNOGRD	TJK91	STORNOGRD	REF	C	CN
26	JKVAKTEP	VBELN	JKAK	VBELN	KEY	1	CN
27	JKVAKTEP	VKBUR	TVKBZ	VKBUR	REF	C	CN
28	JKVAKTEP	VKBURZUS	TVBUR	VKBUR	REF	C	CN
29	JKVAKTEP	VKGRP	TVBVK	VKGRP	REF	C	CN
30	JKVAKTEP	VKORG	TVKO	VKORG	KEY	1	CN
31	JKVAKTEP	VTWEG	TVKOV	VTWEG	KEY	1	CN
32	JKVAKTEP	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in