SAP ABAP View JKVWMAT (IS-M/SD: Promotion View (Gift) for Sales Order)
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 | JKVWMAT | |
Short Description | IS-M/SD: Promotion View (Gift) for Sales Order | |
Root table | JKGIFT | Sales Order: Promotional Gifts for Introduction Record |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | JKGIFT | JKGIFT | ||
2 | JKPROM | |||
3 | JKAP | |||
4 | JKEP | |||
5 | JKAK |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | JKPROM | MANDT | JL | EQ | 0 | 0 | ||||
2 | JKGIFT | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | JKPROM | VBELN | JL | EQ | 0 | 0 | ||||
4 | JKGIFT | VBELN | JR | EQ | AND | 0 | 0 | |||
5 | JKPROM | POSNR | JL | EQ | 0 | 0 | ||||
6 | JKGIFT | POSNR | JR | EQ | AND | 0 | 0 | |||
7 | JKPROM | PROMNR | JL | EQ | 0 | 0 | ||||
8 | JKGIFT | PROMNR | JR | EQ | AND | 0 | 0 | |||
9 | JKAP | MANDT | JL | EQ | 0 | 0 | ||||
10 | JKPROM | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | JKAP | VBELN | JL | EQ | 0 | 0 | ||||
12 | JKPROM | VBELN | JR | EQ | AND | 0 | 0 | |||
13 | JKAP | POSNR | JL | EQ | 0 | 0 | ||||
14 | JKPROM | POSNR_BASE | JR | EQ | AND | 0 | 0 | |||
15 | JKEP | MANDT | JL | EQ | 0 | 0 | ||||
16 | JKAP | MANDT | JR | EQ | AND | 0 | 0 | |||
17 | JKEP | VBELN | JL | EQ | 0 | 0 | ||||
18 | JKAP | VBELN | JR | EQ | AND | 0 | 0 | |||
19 | JKEP | POSNR | JL | EQ | 0 | 0 | ||||
20 | JKAP | POSNR | JR | EQ | AND | 0 | 0 | |||
21 | JKAK | MANDT | JL | EQ | 0 | 0 | ||||
22 | JKAP | MANDT | JR | EQ | AND | 0 | 0 | |||
23 | JKAK | VBELN | JL | EQ | 0 | 0 | ||||
24 | JKAP | VBELN | JR | EQ | AND | 0 | 0 | |||
25 | JKAK | VBTYP | NE | 'B' | AND | 0 | 0 | |||
26 | JKEP | XUREINT | EQ | 'X' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | JKGIFT | MANDT | MANDT | Client | |||
2 | VBELN | JKGIFT | VBELN | AVNR | IS-M/SD: Publishing Sales Order | |||
3 | POSNR | JKGIFT | POSNR | APNR_UR | Original Item in Publishing Sales Order | |||
4 | ETENR | JKEP | ETENR | JAENR | Sales Order Schedule Line | |||
5 | PROMNR | JKGIFT | PROMNR | JPROMNR | Sales order introduction | |||
6 | MATNRWERB | JKGIFT | MATNRWERB | MATNR_SAPR | IS-M: Material number for gift | |||
7 | GPNR | JKGIFT | GPNR | GPVERM | Business Partner Sales Agent | |||
8 | XMAINAGENT | JKGIFT | XMAINAGENT | XMAINAGENT | IS-M/SD: Indicator for Main Sales Agent | |||
9 | ZUZAHLBETR | JKGIFT | ZUZAHLBETR | JZUZAHLBET | Additional payment | |||
10 | ZUZAHLWAER | JKGIFT | ZUZAHLWAER | JZUZAHLWAE | Currency for Additional Payment | |||
11 | VERSANDDAT | JKGIFT | VERSANDDAT | JPRMVRSDAT | IS-M/SD: Gift Shipping Date | |||
12 | VPFLZEITRV | JKGIFT | VPFLZEITRV | VPFLZEITRV | Commitment period for sales agent (subscriber) | |||
13 | VPFLZEINHV | JKGIFT | VPFLZEINHV | VPFLZEINHV | Time unit for commitment period | |||
14 | VPFLBEGINN | JKGIFT | VPFLBEGINN | VPFLBEGINN | IS-M/SD: Date on which commitment period begins | |||
15 | ERLDATWERB | JKGIFT | ERLDATWERB | ERLDATWERB | Date Advertising Bonus Sent | |||
16 | XSAPRSPERR | JKGIFT | XSAPRSPERR | XSAPRSPERR | Block indicator for gift shipping | |||
17 | AVNRWERB | JKGIFT | AVNRWERB | AVNRWERB | Order Number for Gift 'Free Subscription' | |||
18 | APNRWERB | JKGIFT | APNRWERB | APNRWERB | Order Item Number for Gift 'Free Subscription' | |||
19 | WERBEART | JKPROM | WERBEART | WERBEART | Sales Source | |||
20 | WERBEAKT | JKPROM | WERBEAKT | WERBEAKT | Sales Promotion | |||
21 | XAQUISITION | JKPROM | XAQUISITION | XAQUISITION | IS-M/SD: Indicator - first introduction record | |||
22 | JKPROMVON | JKPROM | GUELTIGVON | WERBVONDT | Start of Validity of Campaign Framework | |||
23 | MINDBEZUG | JKPROM | MINDBEZUG | MINDBEZUG | Minimum Length of Subscription | |||
24 | MINDBEZEIN | JKPROM | MINDBEZEIN | MINDBEZEIN | Time Unit for Minimum Length of Subscription | |||
25 | POSNR_BASE | JKPROM | POSNR_BASE | APNR | Sales Order Item | |||
26 | CYCLENR_BASE | JKPROM | CYCLENR_BASE | CYCLENR | IS-M/SD: Billing Cycle Number | |||
27 | POART | JKAP | POART | POART_ISP | Internal Item Type for Sales Order | |||
28 | POSEX | JKAP | POSEX | POSEX_ISP | External Item Number (Purchase Order Item) | |||
29 | DRERZ | JKAP | DRERZ | DRERZ | Publication | |||
30 | PVA | JKAP | PVA | PVA | Edition | |||
31 | JKEPVON | JKEP | GUELTIGVON | JKEPVON | Date from Which Schedule Line in Sales Order is Valid | |||
32 | JKEPBIS | JKEP | GUELTIGBIS | JKEPBIS | Date to Which Schedule Line in Sales Order is Valid | |||
33 | BEZPER | JKEP | BEZPER | BEZPER | Service Type | |||
34 | ETMENGE | JKEP | ETMENGE | ETMENGE | IS-M: Sales Order Schedule Line Quantity | |||
35 | ETMEINS | JKEP | ETMEINS | ETMEINS | IS-M: Sales Unit for Sales Order | |||
36 | GPAG | JKAK | GPAG | GPAG | Business Partner: Sold-to Party | |||
37 | VKORG | JKAK | VKORG | VKORG | Sales Organization | |||
38 | VTWEG | JKAK | VTWEG | VTWEG | Distribution Channel | |||
39 | SPART | JKAK | SPART | SPART_AK | Division for order header | |||
40 | XFKVDICHT | JKAK | XFKVDICHT | XFKVDICHT | IS-M: Summarize deliveries according to billing item | |||
41 | AUARTGRP | JKAK | AUARTGRP | JAUARTGRP | IS-M/SD: Sales document type grouping | |||
42 | ERFDATE | JKAP | ERFDATE | ERFDATE | Created On | |||
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 | 20110901 |
SAP Release Created in |