SAP ABAP View JKVPROSP (IS-M/SD: Ad Pre-Print Order Items)

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	JKVPROSP
Short Description	IS-M/SD: Ad Pre-Print Order Items
Root table	JDTVAUSGB	IS-M/SD: Issues

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JDTVAUSGB	JDTVAUSGB
2	JKAKPR
3	JKAPPR
4	JDTDRER

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JDTVAUSGB	MANDT	JL	EQ				0	0
2	JKAKPR	MANDT	JR	EQ			AND	0	0
3	JDTVAUSGB	VAUSGB	JL	EQ				0	0
4	JKAKPR	VAUSGB_PRO	JR	EQ			AND	0	0
5	JKAKPR	MANDT	JL	EQ				0	0
6	JKAPPR	MANDT	JR	EQ			AND	0	0
7	JKAKPR	VBELN	JL	EQ				0	0
8	JKAPPR	VBELN	JR	EQ			AND	0	0
9	JDTDRER	MANDT	JL	EQ				0	0
10	JDTVAUSGB	MANDT	JR	EQ			AND	0	0
11	JDTDRER	DRERZ	JL	EQ				0	0
12	JDTVAUSGB	DRERZ	JR	EQ			AND	0	0
13	JDTDRER	DRUERZART		EQ	'2'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JDTVAUSGB	MANDT		☐	MANDT	☐	Client
2	VAUSGB	JDTVAUSGB	VAUSGB		☐	VAUSGB	☐	Issue
3	VBELN	JKAKPR	VBELN		☐	AVNR_PR	☐	Ad Pre-Print Order
4	POSNR	JKAPPR	POSNR		☐	APNR_PR	☐	Item in Ad Pre-Print Order
5	WERKS	JKAKPR	WERKS		☐	JWERK	☐	Plant
6	DRERZ	JDTVAUSGB	DRERZ		☐	DRERZ	☐	Publication
7	PVA	JDTVAUSGB	PVA		☐	PVA	☐	Edition
8	ERSCHDAT	JDTVAUSGB	ERSCHDAT		☐	ERSCHDAT	☐	Publication Date
9	XBEILAGE	JKAKPR	XBEILAGE		☐	XBEILAGE	☐	IS-M: Ad pre-print sales document type - insertion
10	XVERTEILNG	JKAKPR	XVERTEILNG		☐	XVERTEILNG	☐	IS-M: Ad pre-print sales document type - distribution
11	XGEBUCHT	JKAKPR	XGEBUCHT		☐	XGEBUCHT	☐	IS-M: Fixed posting of ad pre-print order
12	XRESRVIERT	JKAKPR	XRESRVIERT		☐	XRESRVIERT	☐	IS-M: Ad pre-print order reserved
13	DRERZTRAEG	JKAPPR	DRERZTRAEG		☐	DRERZTRAEG	☐	Carrying Publication
14	PVATRAEG	JKAPPR	PVATRAEG		☐	PVATRAEG	☐	Carrying Edition
15	ERSCHDATTR	JKAPPR	ERSCHDATTR		☐	ERSCHDATTR	☐	Publication Date (Carrier)
16	DISPODAT	JKAPPR	DISPODAT		☐	DISPODAT	☐	IS-M: Planning Date for Issue
17	LIEFARTTR	JKAPPR	LIEFARTTR		☐	LIEFARTTR	☐	Delivery type for carrying issue
18	KDGRP	JKAPPR	KDGRP		☐	KDGRP_PRSP	☐	Customer group for which insertions are made
19	BEZIRK_BLG	JKAPPR	BEZIRK_BLG		☐	BEZIRK_BLG	☐	IS-M: Insert Zone
20	BEZIRK_ZST	JKAPPR	BEZIRK_ZST		☐	BEZIRKT	☐	Carrier Route
21	BEZIRK_VRT	JKAPPR	BEZIRK_VRT		☐	BEZIRK_VRT	☐	IS-M: Ad Pre-Print Zone
22	BEZRUNDE	JKAPPR	BEZRUNDE		☐	BEZRUNDE	☐	IS-M: Delivery Round
23	GEOEIN	JKAPPR	GEOEIN		☐	GEOEIN	☐	Number of Geographical Unit
24	VRTLDAT	JKAPPR	VRTLDAT		☐	VRTLDAT	☐	IS-M: Date on Which an Ad Insert is Distributed
25	BLGMENGE	JKAPPR	BLGMENGE		☐	BLGMENGE	☐	IS-M: Order Quantity for Insertion
26	VRTMENGE	JKAPPR	VRTMENGE		☐	VRTMENGE	☐	IS-M: Order quantity for distribution
27	ZUSTMENGE	JKAPPR	ZUSTMENGE		☐	JZUSTMENGE	☐	IS-M: Order Quantity for Ad Pre-Print Delivery (TMC)
28	XRESTHSHLT	JKAPPR	XRESTHSHLT		☐	XRESTHSHLT	☐	IS-M: Total Market Coverage
29	XUNVLIEFER	JKAPPR	XUNVLIEFER		☐	XUNVLIEFER	☐	IS-M: Viability Data Incomplete for Item
30	BEZEI10	JDTDRER	BEZEI10		☐	KBEZDRERZ	☐	Short Text for Publication
31	BEZEI40	JDTDRER	BEZEI40		☐	BEZEI50	☐	Long Text

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