SAP ABAP View JKVPROSPVT (IS-M/SD: View of (Compl.) Ad Pre-Print Order Items for Dist.)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
⤷ 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 | JKVPROSPVT | |
Short Description | IS-M/SD: View of (Compl.) Ad Pre-Print Order Items for Dist. | |
Root table | JKAPPR | Ad Pre-Print Order: Item Data |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | JKAPPR | JKAPPR | ||
2 | JVTLIEFBAR | |||
3 | JKAKPR | |||
4 | JDTVAUSGB | |||
5 | JDTDRER |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | JVTLIEFBAR | MANDT | JL | EQ | 0 | 0 | ||||
2 | JKAPPR | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | JVTLIEFBAR | LIEFBARNR | JL | EQ | 0 | 0 | ||||
4 | JKAPPR | LIEFBARNR | 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 | JDTVAUSGB | MANDT | JL | EQ | 0 | 0 | ||||
10 | JKAKPR | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | JDTVAUSGB | VAUSGB | JL | EQ | 0 | 0 | ||||
12 | JKAKPR | VAUSGB_PRO | JR | EQ | AND | 0 | 0 | |||
13 | JDTDRER | MANDT | JL | EQ | 0 | 0 | ||||
14 | JDTVAUSGB | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | JDTDRER | DRERZ | JL | EQ | 0 | 0 | ||||
16 | JDTVAUSGB | DRERZ | JR | EQ | AND | 0 | 0 | |||
17 | JKAKPR | XVERTEILNG | EQ | 'X' | AND | 0 | 0 | |||
18 | JKAKPR | XGEBUCHT | EQ | 'X' | AND | 0 | 0 | |||
19 | JKAPPR | XUNVLIEFER | EQ | ' ' | AND | 0 | 0 | |||
20 | JDTDRER | DRUERZART | EQ | '2' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | JKAPPR | MANDT | MANDT | Client | |||
2 | VBELN | JKAPPR | VBELN | AVNR_PR | Ad Pre-Print Order | |||
3 | POSNR | JKAPPR | POSNR | APNR_PR | Item in Ad Pre-Print Order | |||
4 | KNDGRUPPE | JKAPPR | KDGRP | KDGRP_PRSP | Customer group for which insertions are made | |||
5 | VERSANDDAT | JKAPPR | VRTLDAT | VRTLDAT | IS-M: Date on Which an Ad Insert is Distributed | |||
6 | LFMENGE | JKAPPR | VRTMENGE | VRTMENGE | IS-M: Order quantity for distribution | |||
7 | BEZRUNDTAT | JKAPPR | BEZRUNDE | BEZRUNDE | IS-M: Delivery Round | |||
8 | VAUSGB | JKAKPR | VAUSGB_PRO | VAUSGB_PRO | Ad Pre-Print Number | |||
9 | LFBNRAUF | JVTLIEFBAR | LIEFBARNR | LIEFBARNR | Sequence number for delivery/home delivery viability set | |||
10 | LFARTTAT | JVTLIEFBAR | LIEFERART | LIEFERART | Delivery Type | |||
11 | BEZUGSTYP | JVTLIEFBAR | BEZUGSTYP | BEZUGSTYP_JE_PVA | Mix Type | |||
12 | VKORG | JVTLIEFBAR | VKORG | VKORG | Sales Organization | |||
13 | VTWEG | JVTLIEFBAR | VTWEG | VTWEG | Distribution Channel | |||
14 | BEZIRKTAT | JVTLIEFBAR | BEZIRK | BEZIRK | Carrier Route | |||
15 | GEOEINTAT | JVTLIEFBAR | GEOEIN | GEOEIN | Number of Geographical Unit | |||
16 | DRUCKEREI | JVTLIEFBAR | DRUCKEREI | JWERK | Plant | |||
17 | DRERZTAT | JDTDRER | DRERZ | DRERZ | Publication | |||
18 | ERSCHDAT | JDTVAUSGB | ERSCHDAT | ERSCHDAT | Publication Date | |||
19 | SPART | JDTDRER | SPART | SPARTDRERZ | Division for publication | |||
Maintenance Status
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 |