SAP ABAP Table /DSD/VC_VLH (DSD: Visit List - Header Data)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷
LE-DSD-VC (Application Component) Visit Control
⤷
/DSD/VC (Package) Visit Control
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | /DSD/VC_VLH |
|
| Short Description | DSD: Visit List - Header Data |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| 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 | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
/DSD/VC_VLID | /DSD/VC_VLID | CHAR | 10 | 0 | Visit List | ||
| 3 | |
/DSD/VC_EXDAT | DATUM | DATS | 8 | 0 | Execution Date | ||
| 4 | |
/DSD/VCTEXT | CHAR | 30 | 0 | Name of Visit Schedule/List | |||
| 5 | |
/DSD/VC_VPID | /DSD/VC_VPID | CHAR | 10 | 0 | Visit Plan | /DSD/VC_VPH | |
| 6 | |
/DSD/VC_VPTYP | /DSD/VC_VPTYP | CHAR | 3 | 0 | Visit Plan Type | /DSD/VC_VPTYPE | |
| 7 | |
/DSD/RP_TRUCK | EQUNR | CHAR | 18 | 0 | Vehicle | EQUI | |
| 8 | |
/DSD/RP_TRAIL | EQUNR | CHAR | 18 | 0 | Trailer | EQUI | |
| 9 | |
/DSD/VC_STIME | UZEIT | TIMS | 6 | 0 | Start Time | ||
| 10 | |
/DSD/VC_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone | TTZZ | |
| 11 | |
/DSD/VC_START | KUNNR | CHAR | 10 | 0 | Starting Point of a Tour (Customer, For Example as Plant) | KNA1 | |
| 12 | |
/DSD/VC_END | KUNNR | CHAR | 10 | 0 | End Point of a Tour (Customer, For Example, as Plant) | KNA1 | |
| 13 | |
/DSD/RP_DRIVER1 | KUNNR | CHAR | 10 | 0 | Driver 1 | KNA1 | |
| 14 | |
/DSD/RP_DRIVER2 | KUNNR | CHAR | 10 | 0 | Driver 2 | KNA1 | |
| 15 | |
ROUTE | ROUTE | CHAR | 6 | 0 | Route | TVRO | |
| 16 | |
/DSD/VC_AUTHORITY | /DSD/VC_AUTH | CHAR | 10 | 0 | Visit Group | /DSD/VC_AUTH | |
| 17 | |
/DSD/VC_EXDAT1 | DATUM | DATS | 8 | 0 | Original Executation Date | ||
| 18 | |
/DSD/VC_LOCK | XFELD | CHAR | 1 | 0 | Lock due to Transport Link | ||
| 19 | |
/DSD/VC_VLINACTIV | XFELD | CHAR | 1 | 0 | Inactive Flag (Visit List) | ||
| 20 | |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 21 | |
ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
| 22 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 23 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 24 | |
AEZET | UZEIT | TIMS | 6 | 0 | Time last change was made | ||
| 25 | |
AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
| 26 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
| 27 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
| 28 | |
SPART | SPART | CHAR | 2 | 0 | Division | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | /DSD/VC_VLH | AUTH | |
|
REF | 1 | CN |
| 2 | /DSD/VC_VLH | DRIVER1 | |
|
REF | 1 | CN |
| 3 | /DSD/VC_VLH | DRIVER2 | |
|
REF | 1 | CN |
| 4 | /DSD/VC_VLH | EPOINT | |
|
REF | 1 | CN |
| 5 | /DSD/VC_VLH | MANDT | |
|
KEY | 1 | CN |
| 6 | /DSD/VC_VLH | ROUTE | |
|
REF | 1 | CN |
| 7 | /DSD/VC_VLH | SPOINT | |
|
REF | 1 | CN |
| 8 | /DSD/VC_VLH | STIMEZONE | |
|
REF | 1 | CN |
| 9 | /DSD/VC_VLH | TRAIL | |
|
REF | 1 | CN |
| 10 | /DSD/VC_VLH | TRUCK | |
|
REF | 1 | CN |
| 11 | /DSD/VC_VLH | VPID | |
|
REF | 1 | CN |
| 12 | /DSD/VC_VLH | VPTYP | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20050705 |
| SAP Release Created in | 200 |