SAP ABAP View JKVSPENDEP (IS-M/SD: View of Transfer Items and Schedule Lines)

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

View Type	D	Database View
Database View	JKVSPENDEP
Short Description	IS-M/SD: View of Transfer Items and Schedule Lines
Root table	JKEP	Sales Order: Schedule Line Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKEP	JKEP
2	JKAP
3	JKAK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAP	MANDT	JL	EQ				0	0
2	JKEP	MANDT	JR	EQ			AND	0	0
3	JKAP	VBELN	JL	EQ				0	0
4	JKEP	VBELN	JR	EQ			AND	0	0
5	JKAP	POSNR	JL	EQ				0	0
6	JKEP	POSNR	JR	EQ			AND	0	0
7	JKAK	MANDT	JL	EQ				0	0
8	JKAP	MANDT	JR	EQ			AND	0	0
9	JKAK	VBELN	JL	EQ				0	0
10	JKAP	VBELN	JR	EQ			AND	0	0
11	JKAP	XLIEFSE		EQ	'X'		AND	0	0
12	JKAP	XUNVLIEFER		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKEP	MANDT		☐	MANDT	☐	Client
2	VBELN	JKEP	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	POSNR	JKEP	POSNR		☐	APNR	☐	Sales Order Item
4	ETENR	JKEP	ETENR		☐	JAENR	☐	Sales Order Schedule Line
5	GUELTIGVON	JKEP	GUELTIGVON		☐	JKEPVON	☐	Date from Which Schedule Line in Sales Order is Valid
6	GUELTIGBIS	JKEP	GUELTIGBIS		☐	JKEPBIS	☐	Date to Which Schedule Line in Sales Order is Valid
7	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
8	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
9	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
10	SPARTDRERZ	JKAP	SPART		☐	SPARTDRERZ	☐	Division for publication
11	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
12	PVA	JKAP	PVA		☐	PVA	☐	Edition
13	IVWKN	JKAP	IVWKN		☐	IVWKN	☐	Circulation Audit Report Category ID
14	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
15	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
16	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
17	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
18	JKAPVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
19	JKAPBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
20	DELIVSPLITGRP	JKAP	DELIVSPLITGRP		☐	DELIVSPLITGRP	☐	IS-M/SD: Address Alternation Group
21	DELIVSPLIT	JKAP	DELIVSPLIT		☐	DELIVSPLIT	☐	IS-M/SD: Alternating Address Element
22	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
23	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
24	XMAINSPLIT	JKAP	XMAINSPLIT		☐	XMAINSPLIT	☐	Item for this Alternating Add. Element is a Main Sub-Item
25	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
26	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
27	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
28	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
29	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
30	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
31	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in