SAP ABAP Table JKVSPENDEP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVSPENDEP	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	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
8	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
9	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
10	SPARTDRERZ	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	TSPA
11	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
12	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
13	IVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
14	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
15	POSNR_VG	☐	APNR_VG	APNR	NUMC	6	0	Preceding Item in Publishing Sales Order	JKAP
16	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
17	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
18	JKAPVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
19	JKAPBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
20	DELIVSPLITGRP	☐	DELIVSPLITGRP	DELIVSPLITGRP	CHAR	10	0	IS-M/SD: Address Alternation Group	TJD63
21	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	TJD23
22	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	JKAP
23	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	JKAP
24	XMAINSPLIT	☐	XMAINSPLIT	XFELD	CHAR	1	0	Item for this Alternating Add. Element is a Main Sub-Item
25	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
26	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
27	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
28	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
29	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
30	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
31	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	JKVSPENDEP	BEZPER	TJD09	BEZPER	REF	1	CN
2	JKVSPENDEP	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
3	JKVSPENDEP	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
4	JKVSPENDEP	DELIVSPLITGRP	TJD63	DELIVSPLITGRP	REF	C	CN
5	JKVSPENDEP	DRERZ	JDTDRER	DRERZ	REF	C	CN
6	JKVSPENDEP	ETMEINS	T006	MSEHI	REF	C	CN
7	JKVSPENDEP	IVWKN	TJI01	IVWKN	REF	C	CN
8	JKVSPENDEP	MANDT	T000	MANDT	KEY	1	CN
9	JKVSPENDEP	POSNR	JKAP	POSNR	KEY	1	CN
10	JKVSPENDEP	POSNR_MAIN	JKAP	POSNR	REF	C	CN
11	JKVSPENDEP	POSNR_SUB	JKAP	POSNR	REF	C	CN
12	JKVSPENDEP	POSNR_VG	JKAP	POSNR	REF	1	CN
13	JKVSPENDEP	PVA	JDTPVA	PVA	REF	C	CN
14	JKVSPENDEP	SPARTDRERZ	TSPA	SPART	REF	C	CN
15	JKVSPENDEP	VBELN	JKAK	VBELN	KEY	1	CN
16	JKVSPENDEP	VKORG	TVKO	VKORG	KEY	1	CN
17	JKVSPENDEP	VTWEG	TVKOV	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in