SAP ABAP Table /DSD/VC_VL_DOWNLOAD (Contain position data for route itinerary print/download)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ LE-DSD-VC (Application Component) Visit Control
⤷ /DSD/VC (Package) Visit Control
⤷ LE-DSD-VC (Application Component) Visit Control
⤷ /DSD/VC (Package) Visit Control
Basic Data
Table Category | INTTAB | Structure |
Structure | /DSD/VC_VL_DOWNLOAD | Table Relationship Diagram |
Short Description | Contain position data for route itinerary print/download |
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 | .INCLUDE | 0 | 0 | Tree Display: Visit List Item | |||||
2 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
3 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
4 | NAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
5 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
6 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
7 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
8 | TELF1 | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
9 | TELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
10 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
11 | LAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | * | |
12 | SORTL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
13 | .INCLUDE | 0 | 0 | DSD: Visit List - Item Data | |||||
14 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
15 | VLID | /DSD/VC_VLID | /DSD/VC_VLID | CHAR | 10 | 0 | Visit List | /DSD/VC_VLH | |
16 | VLPOS | /DSD/VC_VLPOS | /DSD/VC_VLPOS | NUMC | 3 | 0 | Item Number: Visit List | * | |
17 | SEQU | /DSD/VC_SEQU | NUMC | 3 | 0 | Sequence | |||
18 | KUNNR | /DSD/VC_KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
19 | DURA | /DSD/VC_DURA | TSTRDURAN | DEC | 11 | 0 | Waiting Time | ||
20 | DTRVD | /DSD/VC_DTRVD | TSTRDURAN | DEC | 11 | 0 | Direct Driving Time | ||
21 | TRVD | /DSD/VC_TRVD | TSTRDURAN | DEC | 11 | 0 | Driving Time | ||
22 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
23 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
24 | SPARTE | SPARTE | SPART | CHAR | 2 | 0 | Division | * | |
25 | PARNR | PARNR | PARNR | NUMC | 10 | 0 | Number of contact person | ||
26 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
27 | FMORE | /DSD/VC_FMORE | XFELD | CHAR | 1 | 0 | Flag: Several Contact Persons or Unloading Points Exist | ||
28 | VANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
29 | VNAME1 | NAME1_BAS | NAME | CHAR | 35 | 0 | Name 1 | ||
30 | VNAME2 | NAME2_BAS | NAME | CHAR | 35 | 0 | Name 2 | ||
31 | VSTRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
32 | VPSTLZ | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
33 | VORT | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
34 | VREGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
35 | VLAND | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
36 | TIMFR1 | /DSD/VC_TIMFR1 | UZEIT | TIMS | 6 | 0 | Visiting Hours or Goods Receiving Hours: Mornings from... | ||
37 | TIMTO1 | /DSD/VC_TIMTO1 | UZEIT | TIMS | 6 | 0 | Visiting Hours or Goods Receiving Hours: Mornings Until... | ||
38 | TIMFR2 | /DSD/VC_TIMFR2 | UZEIT | TIMS | 6 | 0 | Visiting Hours or Goods Receiving Hours: Afternoons from... | ||
39 | TIMTO2 | /DSD/VC_TIMTO2 | UZEIT | TIMS | 6 | 0 | Visiting Hours or Goods Receiving Hours: Afternoons Until... | ||
40 | ORT02 | ORT02_GP | TEXT35 | CHAR | 35 | 0 | District | ||
41 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
42 | VORTSTEIL | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
43 | VTELEFON | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
44 | VABTEILUNG | AD_DPRTMNT | TEXT40 | CHAR | 40 | 0 | Department | ||
45 | VGEBAEUDE | AD_BLDNG_P | TEXT10 | CHAR | 10 | 0 | Building (number or code) | ||
46 | VSTOCKWERK | AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
47 | VRAUMNUMMER | AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
48 | HAS_DELIVERY | CHAR | 1 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /DSD/VC_VL_DOWNLOAD | KUNNR | KNA1 | KUNNR | REF | 1 | CN |
2 | /DSD/VC_VL_DOWNLOAD | MANDT | T000 | MANDT | KEY | 1 | CN |
3 | /DSD/VC_VL_DOWNLOAD | VLID | /DSD/VC_VLH | VLID | KEY | 1 | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 500 |