SAP ABAP Table JKVPROSP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVPROSP	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	VAUSGB	☑	VAUSGB	VAUSGB	CHAR	10	0	Issue
3	VBELN	☑	AVNR_PR	AVNR_PR	CHAR	10	0	Ad Pre-Print Order
4	POSNR	☑	APNR_PR	APNR_PR	NUMC	6	0	Item in Ad Pre-Print Order
5	WERKS	☑	JWERK	WERKS	CHAR	4	0	Plant	T001W
6	DRERZ	☑	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
7	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
8	ERSCHDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
9	XBEILAGE	☐	XBEILAGE	XFELD	CHAR	1	0	IS-M: Ad pre-print sales document type - insertion
10	XVERTEILNG	☐	XVERTEILNG	XFELD	CHAR	1	0	IS-M: Ad pre-print sales document type - distribution
11	XGEBUCHT	☐	XGEBUCHT	XFELD	CHAR	1	0	IS-M: Fixed posting of ad pre-print order
12	XRESRVIERT	☐	XRESRVIERT	XFELD	CHAR	1	0	IS-M: Ad pre-print order reserved
13	DRERZTRAEG	☐	DRERZTRAEG	DRERZ	CHAR	8	0	Carrying Publication	JDTDRER
14	PVATRAEG	☐	PVATRAEG	PVA	CHAR	8	0	Carrying Edition	JDTPVA
15	ERSCHDATTR	☐	ERSCHDATTR	DATUM	DATS	8	0	Publication Date (Carrier)
16	DISPODAT	☐	DISPODAT	DATUM	DATS	8	0	IS-M: Planning Date for Issue
17	LIEFARTTR	☐	LIEFARTTR	LIEFERART	CHAR	2	0	Delivery type for carrying issue	TJV01
18	KDGRP	☐	KDGRP_PRSP	KDGRP	CHAR	2	0	Customer group for which insertions are made	T151
19	BEZIRK_BLG	☐	BEZIRK_BLG	BEZIRK	CHAR	10	0	IS-M: Insert Zone	JVTBEZIRK
20	BEZIRK_ZST	☐	BEZIRKT	BEZIRK	CHAR	10	0	Carrier Route	JVTBEZIRK
21	BEZIRK_VRT	☐	BEZIRK_VRT	BEZIRK	CHAR	10	0	IS-M: Ad Pre-Print Zone	JVTBEZIRK
22	BEZRUNDE	☐	BEZRUNDE	BEZRUNDE	CHAR	10	0	IS-M: Delivery Round	JVTRUNDE
23	GEOEIN	☐	GEOEIN	GEOEIN	CHAR	10	0	Number of Geographical Unit	JSTGEOEINH
24	VRTLDAT	☐	VRTLDAT	DATUM	DATS	8	0	IS-M: Date on Which an Ad Insert is Distributed
25	BLGMENGE	☐	BLGMENGE	STMENGE	DEC	9	0	IS-M: Order Quantity for Insertion
26	VRTMENGE	☐	VRTMENGE	STMENGE	DEC	9	0	IS-M: Order quantity for distribution
27	ZUSTMENGE	☐	JZUSTMENGE	STMENGE	DEC	9	0	IS-M: Order Quantity for Ad Pre-Print Delivery (TMC)
28	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
29	XUNVLIEFER	☐	XUNVLIEFER	XFELD	CHAR	1	0	IS-M: Viability Data Incomplete for Item
30	BEZEI10	☐	KBEZDRERZ	TEXT10	CHAR	10	0	Short Text for Publication
31	BEZEI40	☐	BEZEI50	TEXT50	CHAR	50	0	Long Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKVPROSP	BEZIRK_BLG	JVTBEZIRK	BEZIRK	REF	C	CN
2	JKVPROSP	BEZIRK_VRT	JVTBEZIRK	BEZIRK	REF	C	CN
3	JKVPROSP	BEZIRK_ZST	JVTBEZIRK	BEZIRK	REF	C	CN
4	JKVPROSP	BEZRUNDE	JVTRUNDE	RUNDE	REF	C	CN
5	JKVPROSP	DRERZ	JDTDRER	DRERZ	KEY	1	CN
6	JKVPROSP	DRERZTRAEG	JDTDRER	DRERZ	REF	C	CN
7	JKVPROSP	GEOEIN	JSTGEOEINH	GEOEIN	REF	C	CN
8	JKVPROSP	KDGRP	T151	KDGRP	REF	C	CN
9	JKVPROSP	LIEFARTTR	TJV01	LIEFERART	REF	C	CN
10	JKVPROSP	MANDT	T000	MANDT	KEY	1	CN
11	JKVPROSP	PVA	JDTPVA	PVA	REF	1	CN
12	JKVPROSP	PVATRAEG	JDTPVA	PVA	REF	C	CN
13	JKVPROSP	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in