SAP ABAP View JKVPAZ (IS-M/SD: View of Evaluations of 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	JKVPAZ
Short Description	IS-M/SD: View of Evaluations of 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	JKKD
4	JKPA
5	JKPAZ
6	JGTGPNR
7	JDTDRER
8	JDTPVA

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	JKKD	MANDT	JR	EQ			AND	0	0
7	JKAP	VBELN	JL	EQ				0	0
8	JKKD	VBELN	JR	EQ			AND	0	0
9	JKAP	POSNR	JL	EQ				0	0
10	JKKD	POSNR	JR	EQ			AND	0	0
11	JKAP	MANDT	JL	EQ				0	0
12	JKPA	MANDT	JR	EQ			AND	0	0
13	JKAP	VBELN	JL	EQ				0	0
14	JKPA	VBELN	JR	EQ			AND	0	0
15	JKAP	POSNR	JL	EQ				0	0
16	JKPA	POSNR	JR	EQ			AND	0	0
17	JKPA	MANDT	JL	EQ				0	0
18	JKPAZ	MANDT	JR	EQ			AND	0	0
19	JKPA	VBELN	JL	EQ				0	0
20	JKPAZ	VBELN	JR	EQ			AND	0	0
21	JKPA	POSNR	JL	EQ				0	0
22	JKPAZ	POSNR	JR	EQ			AND	0	0
23	JKPA	JPARVW	JL	EQ				0	0
24	JKPAZ	JPARVW	JR	EQ			AND	0	0
25	JKPA	PARZA	JL	EQ				0	0
26	JKPAZ	PARZA	JR	EQ			AND	0	0
27	JKPA	GUELTIGVON	JL	EQ				0	0
28	JKPAZ	JKPAVON	JR	EQ			AND	0	0
29	JGTGPNR	MANDT	JL	EQ				0	0
30	JKAP	MANDT	JR	EQ			AND	0	0
31	JGTGPNR	GPNR	JL	EQ				0	0
32	JKAP	KUNWE	JR	EQ			AND	0	0
33	JDTDRER	MANDT	JL	EQ				0	0
34	JKAP	MANDT	JR	EQ			AND	0	0
35	JDTDRER	DRERZ	JL	EQ				0	0
36	JKAP	DRERZ	JR	EQ			AND	0	0
37	JDTPVA	MANDT	JL	EQ				0	0
38	JKAP	MANDT	JR	EQ			AND	0	0
39	JDTPVA	DRERZ	JL	EQ				0	0
40	JKAP	DRERZ	JR	EQ			AND	0	0
41	JDTPVA	PVA	JL	EQ				0	0
42	JKAP	PVA	JR	EQ			AND	0	0
43	JKAK	VBTYP		EQ	'C'		AND	0	0
44	JKPA	JPARVW		EQ	'WE'		AND	0	0
45	JKPA	PARZA		EQ	'000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKPA	MANDT		☐	MANDT	☐	Client
2	VBELN	JKAP	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	POSNR	JKAP	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	GEOEIN	JKPAZ	GEOEIN		☐	GEOEIN	☐	Number of Geographical Unit
10	BEZIRK	JKPAZ	BEZIRK		☐	BEZIRK	☐	Carrier Route
11	LIEFBARNR	JKPAZ	LIEFBARNR		☐	LIEFBARNR	☐	Sequence number for delivery/home delivery viability set
12	JKPABIS	JKPA	GUELTIGBIS		☐	JKPABIS	☐	Date to Which Partner Data in Sales Order is Valid
13	BEABLST	JKPA	BEABLST		☐	BEABLST	☐	IS-M: Unloading Point
14	GPNR	JKPA	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
15	ADRNR	JKPA	ADRNR		☐	JADRNR	☐	IS-M: Address Number
16	XDISPO	JKAP	XDISPO		☐	XDISPO	☐	Indicator: relevant to planning
17	IVWKN	JKAP	IVWKN		☐	IVWKN	☐	Circulation Audit Report Category ID
18	XIVW	JKAP	XIVW		☐	XIVW	☐	Indicator: Relevant for audit report
19	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
20	PVA	JKAP	PVA		☐	PVA	☐	Edition
21	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
22	AEART	JKAP	AEART		☐	AEART_JSDK	☐	Order Change Type
23	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
24	VSAUSSTART	JKAP	VSAUSSTART		☐	VSAUSSTART	☐	Shipping outsorting type
25	XLIEFGP	JKAP	XLIEFGP		☐	XLIEFGP	☐	IS-M: Delivery to business partner
26	KDGRP	JKKD	KDGRP		☐	KDGRP	☐	Customer group
27	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
28	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
29	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
30	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
31	VKBURZUS	JKAP	VKBURZUS		☐	VKBURZUS	☐	Sales office responsible
32	SPART	JKAP	SPART		☐	SPARTDRERZ	☐	Division for publication
33	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
34	BRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
35	DRUERZART	JDTDRER	DRUERZART		☐	DRUERZART	☐	Publication Type
36	BERGRP1	JDTPVA	BERGRP1		☐	PVABERGRP1	☐	Report group 1 - edition
37	BERGRP2	JDTPVA	BERGRP2		☐	PVABERGRP2	☐	Report group 2 - edition
38	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
39	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
40	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
41	ZSKLS	JKAP	ZSKLS		☐	JZSKLS	☐	Time slice classification for sales order
42	BEZUGGRD	JKAP	BEZUGGRD		☐	BEZUGGRD	☐	Purchase Reason
43	KUENDGRD	JKAP	KUENDGRD		☐	KUENDGRD	☐	Reason for end of delivery
44	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
45	APOSGUEVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
46	APOSGUEBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
47	VKGRP	JKAK	VKGRP		☐	VKGRP	☐	Sales group
48	VKBUR	JKAK	VKBUR		☐	JVKBUR	☐	IS-M/SD: Receiving Sales Office
49	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
50	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order

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	20130529
SAP Release Created in