SAP ABAP View JKVZUST (IS-M/SD: Planning View for Sales Order Item)

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	JKVZUST
Short Description	IS-M/SD: Planning View for Sales Order Item
Root table	JKAK	Sales Order Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKAK	JKAK
2	JKAP
3	JKPA
4	JKPAZ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAK	MANDT	JL	EQ				0	0
2	JKAP	MANDT	JR	EQ			AND	0	0
3	JKAK	VBELN	JL	EQ				0	0
4	JKAP	VBELN	JR	EQ			AND	0	0
5	JKAP	MANDT	JL	EQ				0	0
6	JKPA	MANDT	JR	EQ			AND	0	0
7	JKAP	VBELN	JL	EQ				0	0
8	JKPA	VBELN	JR	EQ			AND	0	0
9	JKAP	POSNR	JL	EQ				0	0
10	JKPA	POSNR	JR	EQ			AND	0	0
11	JKPA	MANDT	JL	EQ				0	0
12	JKPAZ	MANDT	JR	EQ			AND	0	0
13	JKPA	VBELN	JL	EQ				0	0
14	JKPAZ	VBELN	JR	EQ			AND	0	0
15	JKPA	POSNR	JL	EQ				0	0
16	JKPAZ	POSNR	JR	EQ			AND	0	0
17	JKPA	JPARVW	JL	EQ				0	0
18	JKPAZ	JPARVW	JR	EQ			AND	0	0
19	JKPA	PARZA	JL	EQ				0	0
20	JKPAZ	PARZA	JR	EQ			AND	0	0
21	JKPA	GUELTIGVON	JL	EQ				0	0
22	JKPAZ	JKPAVON	JR	EQ			AND	0	0
23	JKPA	JPARVW		EQ	'WE'		AND	0	0
24	JKPA	PARZA		EQ	'000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKPAZ	MANDT		☐	MANDT	☐	Client
2	VBELN	JKPAZ	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	POSNR	JKPAZ	POSNR		☐	APNR	☐	Sales Order Item
4	JPARVW	JKPA	JPARVW		☐	JPARVW	☐	IS-M: Business Partner Role
5	PARZA	JKPA	PARZA		☐	JPARZA	☐	IS-M: Partner Role Counter
6	JKPAVON	JKPA	GUELTIGVON		☐	JKPAVON	☐	Date from Which Partner Data in Sales Order is Valid
7	GUELTIGVON	JKPAZ	GUELTIGVON		☐	JKPAZVON	☐	Valid From Date of Order-Del.Via.Assgmt for Sales Ord.Item
8	GUELTIGBIS	JKPAZ	GUELTIGBIS		☐	JKPAZBIS	☐	Valid To Date of Order-Deliv.Via.Assgmt for Sales Ord.Item
9	LIEFBARNR	JKPAZ	LIEFBARNR		☐	LIEFBARNR	☐	Sequence number for delivery/home delivery viability set
10	BEZIRK	JKPAZ	BEZIRK		☐	BEZIRK	☐	Carrier Route
11	JKPABIS	JKPA	GUELTIGBIS		☐	JKPABIS	☐	Date to Which Partner Data in Sales Order is Valid
12	ADRNR	JKPA	ADRNR		☐	JADRNR	☐	IS-M: Address Number
13	GPNR	JKPA	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
14	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
15	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
16	PVA	JKAP	PVA		☐	PVA	☐	Edition
17	SPART	JKAP	SPART		☐	SPARTDRERZ	☐	Division for publication
18	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
19	AEART	JKAP	AEART		☐	AEART_JSDK	☐	Order Change Type
20	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
21	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
22	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
23	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
24	XLIEFGP	JKAP	XLIEFGP		☐	XLIEFGP	☐	IS-M: Delivery to business partner
25	XLIEFBEZ	JKAP	XLIEFBEZ		☐	XLIEFBEZ	☐	IS-M: Delivery to a carrier route (reserve)
26	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
27	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
28	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
29	DELIVSPLITGRP	JKAP	DELIVSPLITGRP		☐	DELIVSPLITGRP	☐	IS-M/SD: Address Alternation Group
30	DELIVSPLIT	JKAP	DELIVSPLIT		☐	DELIVSPLIT	☐	IS-M/SD: Alternating Address Element
31	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
32	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
33	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
34	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
35	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
36	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
37	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
38	XDISPO	JKAP	XDISPO		☐	XDISPO	☐	Indicator: relevant to planning
39	XSTORNO	JKAP	XSTORNO		☐	XJSTORNO	☐	Indicator: Reversed
40	HOME_DEL_GROUP	JKPAZ	HOME_DEL_GROUP		☐	HOME_DEL_GROUP	☐	IS-M/SD: Home Delivery Alternation Group
41	HOME_DEL_ELE	JKPAZ	HOME_DEL_ELE		☐	HOME_DEL_ELE	☐	IS-M/SD: Home Delivery Alternation Element
42	XMAIN_ELE	JKPAZ	XMAIN_ELE		☐	XMAIN_ELE	☐	IS-M/SD: Main Element in Home Delivery Alternation Group
43	X_MONTAG_HD	JKPAZ	X_MONTAG_HD		☐	X_MONTAG	☐	IS-M: Monday
44	X_DIENSTAG_HD	JKPAZ	X_DIENSTAG_HD		☐	X_DIENSTAG	☐	IS-M: Tuesday
45	X_MITTWOCH_HD	JKPAZ	X_MITTWOCH_HD		☐	X_MITTWOCH	☐	IS-M: Wednesday
46	X_DONNETAG_HD	JKPAZ	X_DONNETAG_HD		☐	X_DONNETAG	☐	IS-M: Thursday
47	X_FREITAG_HD	JKPAZ	X_FREITAG_HD		☐	X_FREITAG	☐	IS-M: Friday
48	X_SAMSTAG_HD	JKPAZ	X_SAMSTAG_HD		☐	X_SAMSTAG	☐	IS-M: Saturday
49	X_SONNTAG_HD	JKPAZ	X_SONNTAG_HD		☐	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