SAP ABAP Table JKVZUST (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | JKVZUST | 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 | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | JKAK | |
3 | POSNR | APNR | APNR | NUMC | 6 | 0 | Sales Order Item | JKAP | |
4 | JPARVW | JPARVW | JPARVW | CHAR | 2 | 0 | IS-M: Business Partner Role | TJG39 | |
5 | PARZA | JPARZA | JPARZA | NUMC | 3 | 0 | IS-M: Partner Role Counter | ||
6 | JKPAVON | JKPAVON | DATUM | DATS | 8 | 0 | Date from Which Partner Data in Sales Order is Valid | ||
7 | GUELTIGVON | JKPAZVON | DATUM | DATS | 8 | 0 | Valid From Date of Order-Del.Via.Assgmt for Sales Ord.Item | ||
8 | GUELTIGBIS | JKPAZBIS | DATUM | DATS | 8 | 0 | Valid To Date of Order-Deliv.Via.Assgmt for Sales Ord.Item | ||
9 | LIEFBARNR | LIEFBARNR | LIEFBARNR | CHAR | 9 | 0 | Sequence number for delivery/home delivery viability set | JVTLIEFBAR | |
10 | BEZIRK | BEZIRK | BEZIRK | CHAR | 10 | 0 | Carrier Route | JVTBEZIRK | |
11 | JKPABIS | JKPABIS | DATUM | DATS | 8 | 0 | Date to Which Partner Data in Sales Order is Valid | ||
12 | ADRNR | JADRNR | JADRNR | CHAR | 10 | 0 | IS-M: Address Number | JGTSADR | |
13 | GPNR | GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | JGTGPNR | |
14 | POART | POART_ISP | POART_ISP | CHAR | 2 | 0 | Internal Item Type for Sales Order | TJAP | |
15 | DRERZ | DRERZ | DRERZ | CHAR | 8 | 0 | Publication | JDTDRER | |
16 | PVA | PVA | PVA | CHAR | 8 | 0 | Edition | JDTPVA | |
17 | SPART | SPARTDRERZ | SPART | CHAR | 2 | 0 | Division for publication | TSPA | |
18 | BEZUGSTYP | BEZUGSTYP_JE_PVA | BEZUGSTYP_JE_PVA | CHAR | 2 | 0 | Mix Type | JDTBEZTYP | |
19 | AEART | AEART_JSDK | AEART_JSDK | CHAR | 1 | 0 | Order Change Type | ||
20 | LIEFERART | LIEFERART | LIEFERART | CHAR | 2 | 0 | Delivery Type | TJV01 | |
21 | POSEX | POSEX_ISP | POSEX_ISP | NUMC | 6 | 0 | External Item Number (Purchase Order Item) | ||
22 | POSNR_UR | APNR_UR | APNR | NUMC | 6 | 0 | Original Item in Publishing Sales Order | JKAP | |
23 | POSNR_VG | APNR_VG | APNR | NUMC | 6 | 0 | Preceding Item in Publishing Sales Order | JKAP | |
24 | XLIEFGP | XLIEFGP | XFELD | CHAR | 1 | 0 | IS-M: Delivery to business partner | ||
25 | XLIEFBEZ | XLIEFBEZ | XFELD | CHAR | 1 | 0 | IS-M: Delivery to a carrier route (reserve) | ||
26 | AUART | AUART_ISP | AUART_ISP | CHAR | 4 | 0 | IS-M/SD: Sales Document Types | TJAK | |
27 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
28 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVKOV | |
29 | DELIVSPLITGRP | DELIVSPLITGRP | DELIVSPLITGRP | CHAR | 10 | 0 | IS-M/SD: Address Alternation Group | TJD63 | |
30 | DELIVSPLIT | DELIVSPLIT | DELIVSPLIT | CHAR | 8 | 0 | IS-M/SD: Alternating Address Element | TJD23 | |
31 | X_MONTAG | X_MONTAG | XFELD | CHAR | 1 | 0 | IS-M: Monday | ||
32 | X_DIENSTAG | X_DIENSTAG | XFELD | CHAR | 1 | 0 | IS-M: Tuesday | ||
33 | X_MITTWOCH | X_MITTWOCH | XFELD | CHAR | 1 | 0 | IS-M: Wednesday | ||
34 | X_DONNETAG | X_DONNETAG | XFELD | CHAR | 1 | 0 | IS-M: Thursday | ||
35 | X_FREITAG | X_FREITAG | XFELD | CHAR | 1 | 0 | IS-M: Friday | ||
36 | X_SAMSTAG | X_SAMSTAG | XFELD | CHAR | 1 | 0 | IS-M: Saturday | ||
37 | X_SONNTAG | X_SONNTAG | XFELD | CHAR | 1 | 0 | IS-M: Sunday | ||
38 | XDISPO | XDISPO | XFELD | CHAR | 1 | 0 | Indicator: relevant to planning | ||
39 | XSTORNO | XJSTORNO | XFELD | CHAR | 1 | 0 | Indicator: Reversed | ||
40 | HOME_DEL_GROUP | HOME_DEL_GROUP | HOME_DEL_GROUP | CHAR | 10 | 0 | IS-M/SD: Home Delivery Alternation Group | ||
41 | HOME_DEL_ELE | HOME_DEL_ELE | HOME_DEL_ELE | CHAR | 8 | 0 | IS-M/SD: Home Delivery Alternation Element | ||
42 | XMAIN_ELE | XMAIN_ELE | XFELD | CHAR | 1 | 0 | IS-M/SD: Main Element in Home Delivery Alternation Group | ||
43 | X_MONTAG_HD | X_MONTAG | XFELD | CHAR | 1 | 0 | IS-M: Monday | ||
44 | X_DIENSTAG_HD | X_DIENSTAG | XFELD | CHAR | 1 | 0 | IS-M: Tuesday | ||
45 | X_MITTWOCH_HD | X_MITTWOCH | XFELD | CHAR | 1 | 0 | IS-M: Wednesday | ||
46 | X_DONNETAG_HD | X_DONNETAG | XFELD | CHAR | 1 | 0 | IS-M: Thursday | ||
47 | X_FREITAG_HD | X_FREITAG | XFELD | CHAR | 1 | 0 | IS-M: Friday | ||
48 | X_SAMSTAG_HD | X_SAMSTAG | XFELD | CHAR | 1 | 0 | IS-M: Saturday | ||
49 | X_SONNTAG_HD | X_SONNTAG | XFELD | CHAR | 1 | 0 | IS-M: Sunday |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JKVZUST | ADRNR | JGTSADR | ADRNR | REF | C | CN |
2 | JKVZUST | AUART | TJAK | AUART | REF | 1 | CN |
3 | JKVZUST | BEZIRK | JVTBEZIRK | BEZIRK | REF | C | CN |
4 | JKVZUST | BEZUGSTYP | JDTBEZTYP | BEZTYP | REF | 1 | CN |
5 | JKVZUST | DELIVSPLIT | TJD23 | DELIVSPLIT | REF | C | CN |
6 | JKVZUST | DELIVSPLITGRP | TJD63 | DELIVSPLITGRP | REF | C | CN |
7 | JKVZUST | DRERZ | JDTDRER | DRERZ | REF | C | CN |
8 | JKVZUST | GPNR | JGTGPNR | GPNR | KEY | 1 | CN |
9 | JKVZUST | JPARVW | TJG39 | JPARVW | KEY | 1 | CN |
10 | JKVZUST | LIEFBARNR | JVTLIEFBAR | LIEFBARNR | REF | 1 | CN |
11 | JKVZUST | LIEFERART | TJV01 | LIEFERART | REF | C | CN |
12 | JKVZUST | MANDT | T000 | MANDT | KEY | 1 | CN |
13 | JKVZUST | POART | TJAP | POART | REF | 1 | CN |
14 | JKVZUST | POSNR | JKAP | POSNR | KEY | 1 | CN |
15 | JKVZUST | POSNR_UR | JKAP | POSNR | REF | 1 | CN |
16 | JKVZUST | POSNR_VG | JKAP | POSNR | REF | 1 | CN |
17 | JKVZUST | PVA | JDTPVA | PVA | REF | C | CN |
18 | JKVZUST | SPART | TSPA | SPART | REF | C | CN |
19 | JKVZUST | VBELN | JKAK | VBELN | KEY | 1 | CN |
20 | JKVZUST | VKORG | TVKO | VKORG | KEY | 1 | CN |
21 | JKVZUST | VTWEG | TVKOV | VTWEG | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |