SAP ABAP Table /DSD/VC_VPTYPE_3 (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | /DSD/VC_VPTYPE_3 |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
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 | VPTYP |
/DSD/VC_VPTYP | /DSD/VC_VPTYP | CHAR | 3 | 0 | Visit Plan Type | ||
| 3 | VPTYPT |
/DSD/VC_VPTYPT | TEXT40 | CHAR | 40 | 0 | Name of Visit Plan Type | ||
| 4 | FRECE |
/DSD/VC_FRECE | XFELD | CHAR | 1 | 0 | Determing Visiting Hours from Goods Receiving Hours | ||
| 5 | FVISIT |
/DSD/VC_FVISIT | XFELD | CHAR | 1 | 0 | Determine Visiting Hours from Contact Person | ||
| 6 | PAFKT |
PAFKT | PAFKT | CHAR | 2 | 0 | Contact person function | TPFK | |
| 7 | TRHH |
/DSD/VC_TRHH | XFELD | CHAR | 1 | 0 | Shipping Document | ||
| 8 | VLHH |
/DSD/VC_VLHH | XFELD | CHAR | 1 | 0 | Visit List Document | ||
| 9 | CUSTD |
/DSD/VC_CUSTD | XFELD | CHAR | 1 | 0 | Flag: Customer-Specific Deliveries | ||
| 10 | CALTYP |
/DSD/VC_CALENDARTYPE | /DSD/VC_CALTYP | CHAR | 3 | 0 | Calendar Type | /DSD/VC_CALTYP | |
| 11 | CALTYPT |
/DSD/VC_CALENDARTYPET | TEXT40 | CHAR | 40 | 0 | Name of Calendar Type | ||
| 12 | DURA |
/DSD/VC_DURA | TSTRDURAN | DEC | 11 | 0 | Waiting Time | ||
| 13 | DTRVD |
/DSD/VC_DTRVD | TSTRDURAN | DEC | 11 | 0 | Direct Driving Time | ||
| 14 | TRVD |
/DSD/VC_TRVD | TSTRDURAN | DEC | 11 | 0 | Driving Time | ||
| 15 | FMANTR |
/DSD/VC_FMANTR | XFELD | CHAR | 1 | 0 | Usage in Manual Shipment | ||
| 16 | TRLOAD |
/DSD/RP_TRIALSTOLOAD | /DSD/RP_SEQUENCENR | NUMC | 5 | 0 | Maximum Number of Attempts to Load a Truck | ||
| 17 | VPRNR |
/DSD/VC_VPRANGE | CHAR2 | CHAR | 2 | 0 | Number Range Interval of Visit Schedules | NRIV | |
| 18 | VLRNR |
/DSD/VC_VLRANGE | CHAR2 | CHAR | 2 | 0 | Number Range Interval of Visit Lists | NRIV | |
| 19 | VPRNR_EX |
/DSD/VC_VPRANGE | CHAR2 | CHAR | 2 | 0 | Number Range Interval of Visit Schedules | NRIV | |
| 20 | VLRNR_EX |
/DSD/VC_VLRANGE | CHAR2 | CHAR | 2 | 0 | Number Range Interval of Visit Lists | NRIV | |
| 21 | BSO |
/DSD/SL_BSO | /DSD/SL_BSO | CHAR | 4 | 0 | DSD Route Settlement: Settlement Office | /DSD/SL_TBSO | |
| 22 | BSO_NAME |
/DSD/SL_BSO_NAME | TEXT40 | CHAR | 40 | 0 | DSD Route Settlement: Description of Settlement Office | ||
| 23 | SLTYP |
/DSD/SL_TYP | /DSD/SL_TYP | CHAR | 2 | 0 | DSD Route Settlement: Settlement Type | /DSD/SL_TSLTYP | |
| 24 | SL_TYP_DESCR |
/DSD/SL_TYP_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | DSD: Route Settlement: Description of a Settlement Type | ||
| 25 | KALSM |
KALSMB | KALSM | CHAR | 6 | 0 | Output determination procedure | T683 | |
| 26 | KSCHL |
NA_KSCHL | KSCHL | CHAR | 4 | 0 | Output Type | T685 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /DSD/VC_VPTYPE_3 | BSO |  /DSD/SL_TBSO |
BSO |
KEY | ||
| 2 | /DSD/VC_VPTYPE_3 | CALTYP | /DSD/VC_CALTYP |
CALTYP |
|||
| 3 | /DSD/VC_VPTYPE_3 | KALSM | T683 |
KALSM |
REF | 1 | CN |
| 4 | /DSD/VC_VPTYPE_3 | KSCHL | T685 |
KSCHL |
REF | 1 | CN |
| 5 | /DSD/VC_VPTYPE_3 | MANDT | T000 |
MANDT |
|||
| 6 | /DSD/VC_VPTYPE_3 | PAFKT | TPFK |
PAFKT |
|||
| 7 | /DSD/VC_VPTYPE_3 | SLTYP | /DSD/SL_TSLTYP |
SL_TYP |
KEY | ||
| 8 | /DSD/VC_VPTYPE_3 | VLRNR | NRIV |
NRRANGENR |
|||
| 9 | /DSD/VC_VPTYPE_3 | VLRNR_EX | NRIV |
NRRANGENR |
|||
| 10 | /DSD/VC_VPTYPE_3 | VPRNR | NRIV |
NRRANGENR |
|||
| 11 | /DSD/VC_VPTYPE_3 | VPRNR_EX | NRIV |
NRRANGENR |
History
| Last changed by/on | SAP | 20100310 |
| SAP Release Created in |
