SAP ABAP Table JKVPROSPVT (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | JKVPROSPVT |
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 | VBELN |
AVNR_PR | AVNR_PR | CHAR | 10 | 0 | Ad Pre-Print Order | JKAKPR | |
| 3 | POSNR |
APNR_PR | APNR_PR | NUMC | 6 | 0 | Item in Ad Pre-Print Order | ||
| 4 | KNDGRUPPE |
KDGRP_PRSP | KDGRP | CHAR | 2 | 0 | Customer group for which insertions are made | T151 | |
| 5 | VERSANDDAT |
VRTLDAT | DATUM | DATS | 8 | 0 | IS-M: Date on Which an Ad Insert is Distributed | ||
| 6 | LFMENGE |
VRTMENGE | STMENGE | DEC | 9 | 0 | IS-M: Order quantity for distribution | ||
| 7 | BEZRUNDTAT |
BEZRUNDE | BEZRUNDE | CHAR | 10 | 0 | IS-M: Delivery Round | JVTRUNDE | |
| 8 | VAUSGB |
VAUSGB_PRO | VAUSGB | CHAR | 10 | 0 | Ad Pre-Print Number | JDTVAUSGB | |
| 9 | LFBNRAUF |
LIEFBARNR | LIEFBARNR | CHAR | 9 | 0 | Sequence number for delivery/home delivery viability set | ||
| 10 | LFARTTAT |
LIEFERART | LIEFERART | CHAR | 2 | 0 | Delivery Type | TJV01 | |
| 11 | BEZUGSTYP |
BEZUGSTYP_JE_PVA | BEZUGSTYP_JE_PVA | CHAR | 2 | 0 | Mix Type | ||
| 12 | VKORG |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 13 | VTWEG |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
| 14 | BEZIRKTAT |
BEZIRK | BEZIRK | CHAR | 10 | 0 | Carrier Route | JVTBEZIRK | |
| 15 | GEOEINTAT |
GEOEIN | GEOEIN | CHAR | 10 | 0 | Number of Geographical Unit | JSTGEOEINH | |
| 16 | DRUCKEREI |
JWERK | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 17 | DRERZTAT |
DRERZ | DRERZ | CHAR | 8 | 0 | Publication | ||
| 18 | ERSCHDAT |
ERSCHDAT | DATUM | DATS | 8 | 0 | Publication Date | ||
| 19 | SPART |
SPARTDRERZ | SPART | CHAR | 2 | 0 | Division for publication | TSPA |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | JKVPROSPVT | BEZIRKTAT |  JVTBEZIRK |
BEZIRK |
REF | C | CN |
| 2 | JKVPROSPVT | BEZRUNDTAT | JVTRUNDE |
RUNDE |
REF | C | CN |
| 3 | JKVPROSPVT | DRUCKEREI | T001W |
WERKS |
KEY | 1 | CN |
| 4 | JKVPROSPVT | GEOEINTAT | JSTGEOEINH |
GEOEIN |
REF | C | CN |
| 5 | JKVPROSPVT | KNDGRUPPE | T151 |
KDGRP |
REF | C | CN |
| 6 | JKVPROSPVT | LFARTTAT | TJV01 |
LIEFERART |
KEY | 1 | CN |
| 7 | JKVPROSPVT | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 8 | JKVPROSPVT | SPART | TSPA |
SPART |
REF | 1 | CN |
| 9 | JKVPROSPVT | VAUSGB | JDTVAUSGB |
VAUSGB |
REF | 1 | CN |
| 10 | JKVPROSPVT | VBELN | JKAKPR |
VBELN |
KEY | 1 | CN |
| 11 | JKVPROSPVT | VKORG | TVKO |
VKORG |
KEY | 1 | CN |
| 12 | JKVPROSPVT | VTWEG | TVTW |
VTWEG |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |
