SAP ABAP Table JKVAP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVAP	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
3	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item
4	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
5	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
8	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
9	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
10	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
11	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
12	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
13	GUELTIGVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
14	GUELTIGBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
15	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
16	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
17	AEART	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
18	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
19	TRVOG	☐	TRVOG_ISP	TRVOG_ISP	CHAR	1	0	Transaction Group for IS-M Order Processing
20	XWBZABO	☐	XWBZABO	XFELD	CHAR	1	0	IS-M: WBZ subscription
21	KUNWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	JGTGPNR
22	POSNR_VG	☐	APNR_VG	APNR	NUMC	6	0	Preceding Item in Publishing Sales Order	JKAP
23	XFAKTURA	☐	XFAKTURA	XFELD	CHAR	1	0	Indicator: Relevant for billing
24	ZSKLS	☐	JZSKLS	JZSKLS	CHAR	1	0	Time slice classification for sales order
25	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
26	VKBURZUS	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	TVBUR
27	XFKBASAUFT	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
28	XFKBASLIEF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
29	XFKVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
30	XRENEWAL	☐	XRENEWAL	XFELD	CHAR	1	0	IS-M/SD: Order extended by renewal offer
31	AMORTN	☐	AMORTN	AMORTN	CHAR	1	0	IS-M/SD: Use of Liability Account in Order
32	VBTYP	☐	VBTYP_ISP	VBTYP_ISP	CHAR	1	0	Sales document category, IS-M
33	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
34	LAND1	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	T005
35	SPARTDRERZ	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	TSPA
36	IVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
37	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	TJK87
38	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
39	RECHENDE	☐	RECHENDE	DATUM	DATS	8	0	Billing To
40	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
41	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	TJK83
42	FAKSP	☐	FAKTSPERRE	FAKSP	CHAR	2	0	Billing Block	TVFS
43	XLIEFBEZ	☐	XLIEFBEZ	XFELD	CHAR	1	0	IS-M: Delivery to a carrier route (reserve)
44	XSTORNO	☐	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
45	STORNOGRD	☐	STORNOGRD	STORNOGRD	CHAR	3	0	Reversal Reason	TJK91
46	HEFTNUMVON	☐	HEFTNUMVON	HEFTNUMMER	CHAR	9	0	Copy Number of First Issue to be Delivered
47	HEFTNUMBIS	☐	HEFTNUMBIS	HEFTNUMMER	CHAR	9	0	Copy Number of Last Issue for Delivery
48	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
49	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
50	VKBUR	☐	JVKBUR	VKBUR	CHAR	4	0	IS-M/SD: Receiving Sales Office	TVKBZ
51	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
52	REMSP	☐	REMSP	XFELD	CHAR	1	0	IS-M: Billing Block for Return Notification
53	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
54	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	JKAP
55	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	JKAP
56	DELIVSPLITGRP	☐	DELIVSPLITGRP	DELIVSPLITGRP	CHAR	10	0	IS-M/SD: Address Alternation Group	TJD63
57	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	TJD23
58	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
59	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
60	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
61	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
62	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
63	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
64	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	JKVAP	AUART	TJAK	AUART	REF	1	CN
2	JKVAP	BEZUGGRD	TJK87	BEZUGGRD	REF	C	CN
3	JKVAP	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
4	JKVAP	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
5	JKVAP	DELIVSPLITGRP	TJD63	DELIVSPLITGRP	REF	C	CN
6	JKVAP	DRERZ	JDTDRER	DRERZ	REF	C	CN
7	JKVAP	FAKSP	TVFS	FAKSP	REF	C	CN
8	JKVAP	GPAG	JGTGPNR	GPNR	KEY	1	CN
9	JKVAP	IVWKN	TJI01	IVWKN	REF	C	CN
10	JKVAP	KUENDGRD	TJK83	KUENDGRD	REF	C	CN
11	JKVAP	KUNWE	JGTGPNR	GPNR	REF	C	CN
12	JKVAP	LAND1	T005	LAND1	REF	C	CN
13	JKVAP	LIEFERART	TJV01	LIEFERART	REF	C	CN
14	JKVAP	MANDT	T000	MANDT	KEY	1	CN
15	JKVAP	POART	TJAP	POART	REF	1	CN
16	JKVAP	POSNR_MAIN	JKAP	POSNR	REF	C	CN
17	JKVAP	POSNR_SUB	JKAP	POSNR	REF	C	CN
18	JKVAP	POSNR_UR	JKAP	POSNR	REF	1	CN
19	JKVAP	POSNR_VG	JKAP	POSNR	REF	1	CN
20	JKVAP	PVA	JDTPVA	PVA	REF	C	CN
21	JKVAP	SPART	TVTA	SPART	KEY	1	CN
22	JKVAP	SPARTDRERZ	TSPA	SPART	REF	C	CN
23	JKVAP	STORNOGRD	TJK91	STORNOGRD	REF	C	CN
24	JKVAP	VKBUR	TVKBZ	VKBUR	REF	C	CN
25	JKVAP	VKBURZUS	TVBUR	VKBUR	REF	C	CN
26	JKVAP	VKGRP	TVBVK	VKGRP	REF	C	CN
27	JKVAP	VKORG	TVKO	VKORG	KEY	1	CN
28	JKVAP	VTWEG	TVKOV	VTWEG	KEY	1	CN
29	JKVAP	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in