SAP ABAP View /DSD/VC_VL (Visit List Header and Items)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷
LE-DSD-VC (Application Component) Visit Control
⤷
/DSD/VC (Package) Visit Control
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials⤷
LE-DSD-VC (Application Component) Visit Control⤷
/DSD/VC (Package) Visit Control
Basic Data
| View Type | D | Database View |
| Database View | /DSD/VC_VL | |
| Short Description | Visit List Header and Items | |
| Root table | /DSD/VC_VLH | DSD: Visit List - Header Data |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /DSD/VC_VLH |
/DSD/VC_VLH | ||
| 2 | /DSD/VC_VLP |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /DSD/VC_VLH |
MANDT | JL | EQ | 0 | 0 | ||||
| 2 | /DSD/VC_VLP |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /DSD/VC_VLH |
VLID | JL | EQ | 0 | 0 | ||||
| 4 | /DSD/VC_VLP |
VLID | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
/DSD/VC_VLH |
MANDT | MANDT | Client | |||
| 2 | VLID |
/DSD/VC_VLH |
VLID | /DSD/VC_VLID | Visit List | |||
| 3 | VLPOS |
/DSD/VC_VLP |
VLPOS | /DSD/VC_VLPOS | Item Number: Visit List | |||
| 4 | VPID |
/DSD/VC_VLH |
VPID | /DSD/VC_VPID | Visit Plan | |||
| 5 | VPTYP |
/DSD/VC_VLH |
VPTYP | /DSD/VC_VPTYP | Visit Plan Type | |||
| 6 | TRUCK |
/DSD/VC_VLH |
TRUCK | /DSD/RP_TRUCK | Vehicle | |||
| 7 | TRAIL |
/DSD/VC_VLH |
TRAIL | /DSD/RP_TRAIL | Trailer | |||
| 8 | STIME |
/DSD/VC_VLH |
STIME | /DSD/VC_STIME | Start Time | |||
| 9 | STIMEZONE |
/DSD/VC_VLH |
STIMEZONE | /DSD/VC_TIMEZONE | Time Zone | |||
| 10 | SPOINT |
/DSD/VC_VLH |
SPOINT | /DSD/VC_START | Starting Point of a Tour (Customer, For Example as Plant) | |||
| 11 | EPOINT |
/DSD/VC_VLH |
EPOINT | /DSD/VC_END | End Point of a Tour (Customer, For Example, as Plant) | |||
| 12 | DRIVER1 |
/DSD/VC_VLH |
DRIVER1 | /DSD/RP_DRIVER1 | Driver 1 | |||
| 13 | DRIVER2 |
/DSD/VC_VLH |
DRIVER2 | /DSD/RP_DRIVER2 | Driver 2 | |||
| 14 | ROUTE |
/DSD/VC_VLH |
ROUTE | ROUTE | Route | |||
| 15 | AUTH |
/DSD/VC_VLH |
AUTH | /DSD/VC_AUTHORITY | Visit Group | |||
| 16 | EXDAT |
/DSD/VC_VLH |
EXDAT | /DSD/VC_EXDAT | Execution Date | |||
| 17 | EXDAT1 |
/DSD/VC_VLH |
EXDAT1 | /DSD/VC_EXDAT1 | Original Executation Date | |||
| 18 | XLOCK |
/DSD/VC_VLH |
XLOCK | /DSD/VC_LOCK | Lock due to Transport Link | |||
| 19 | INACTIV |
/DSD/VC_VLH |
INACTIV | /DSD/VC_VLINACTIV | Inactive Flag (Visit List) | |||
| 20 | ERDAT |
/DSD/VC_VLH |
ERDAT | ERDAT | Date on which the record was created | |||
| 21 | ERZET |
/DSD/VC_VLH |
ERZET | ERZET | Entry time | |||
| 22 | ERNAM |
/DSD/VC_VLH |
ERNAM | ERNAM | Name of Person who Created the Object | |||
| 23 | AEDAT |
/DSD/VC_VLH |
AEDAT | AEDAT | Last Changed On | |||
| 24 | AEZET |
/DSD/VC_VLH |
AEZET | AEZET | Time last change was made | |||
| 25 | AENAM |
/DSD/VC_VLH |
AENAM | AENAM | Name of Person Who Changed Object | |||
| 26 | SEQU |
/DSD/VC_VLP |
SEQU | /DSD/VC_SEQU | Sequence | |||
| 27 | KUNNR |
/DSD/VC_VLP |
KUNNR | /DSD/VC_KUNNR | Customer Number | |||
| 28 | DURA |
/DSD/VC_VLP |
DURA | /DSD/VC_DURA | Waiting Time | |||
| 29 | DTRVD |
/DSD/VC_VLP |
DTRVD | /DSD/VC_DTRVD | Direct Driving Time | |||
| 30 | TRVD |
/DSD/VC_VLP |
TRVD | /DSD/VC_TRVD | Driving Time | |||
| 31 | SALES_ORG |
/DSD/VC_VLH |
SALES_ORG | VKORG | Sales Organization | |||
| 32 | DIST_CHANNEL |
/DSD/VC_VLH |
DIST_CHANNEL | VTWEG | Distribution Channel | |||
| 33 | DIVISION |
/DSD/VC_VLH |
DIVISION | SPART | Division | |||
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 | 20050705 |
| SAP Release Created in | 200 |
