SAP ABAP Table /DSD/DE_FUPREC_L_S (Tour Data Entry: Selection List)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷
LE-DSD-RA-DE (Application Component) Tour Data Entry
⤷
/DSD/DE (Package) Tour Data Entry
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials⤷
LE-DSD-RA-DE (Application Component) Tour Data Entry⤷
/DSD/DE (Package) Tour Data Entry
Basic Data
| Table Category | INTTAB | Structure |
| Structure | /DSD/DE_FUPREC_L_S |
Table Relationship Diagram 
|
| Short Description | Tour Data Entry: Selection List |
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 |  MARK |
/DSD/HH_CHECKBOX | /DSD/HH_CHECKBOX | CHAR | 1 | 0 | Checkbox | ||
| 2 | DOC_TYP |
/DSD/HH_DOC_TYP | /DSD/HH_DOC_TYP | CHAR | 2 | 0 | DSD - RA: Tour Document Type | ||
| 3 | DOC_ID |
/DSD/HH_DOC_ID | VBELN | CHAR | 10 | 0 | DSD - RA: Tour Document Number of the Tour Document Type | * | |
| 4 | ROUTE |
ROUTR | ROUTE | CHAR | 6 | 0 | Shipment route | TVRO | |
| 5 | ROUTBEZ |
ROUTBEZ | TEXT40 | CHAR | 40 | 0 | Description of route | ||
| 6 | DRIVER1 |
/DSD/RP_DRIVER1 | KUNNR | CHAR | 10 | 0 | Driver 1 | KNA1 | |
| 7 | DRIV1NAME |
/DSD/RP_DRIVER1_NAME | NAME | CHAR | 35 | 0 | Name of Driver 1 | ||
| 8 | DRIVER2 |
/DSD/RP_DRIVER2 | KUNNR | CHAR | 10 | 0 | Driver 2 | KNA1 | |
| 9 | DRIV2NAME |
/DSD/RP_DRIVER2_NAME | NAME | CHAR | 35 | 0 | Name of Driver 2 | ||
| 10 | VEHICLE |
/DSD/RP_TRUCK | EQUNR | CHAR | 18 | 0 | Vehicle | EQUI | |
| 11 | VEHICLE_NAME |
/DSD/RP_TRUCK_NAME | TEXT40 | CHAR | 40 | 0 | Description of Tractor | ||
| 12 | TRAILER |
/DSD/RP_TRAIL | EQUNR | CHAR | 18 | 0 | Trailer | EQUI | |
| 13 | TRAILER_NAME |
/DSD/RP_TRAIL_NAME | TEXT40 | CHAR | 40 | 0 | Description of Trailer | ||
| 14 | EXDAT |
/DSD/VC_EXDAT | DATUM | DATS | 8 | 0 | Execution Date | ||
| 15 | VPID |
/DSD/VC_VPID | /DSD/VC_VPID | CHAR | 10 | 0 | Visit Plan | /DSD/VC_VPH | |
| 16 | VCTEXT |
/DSD/VCTEXT | CHAR | 30 | 0 | Name of Visit Schedule/List | |||
| 17 | VPTYP |
/DSD/VC_VPTYP | /DSD/VC_VPTYP | CHAR | 3 | 0 | Visit Plan Type | /DSD/VC_VPTYPE | |
| 18 | AUTH |
/DSD/VC_AUTHORITY | /DSD/VC_AUTH | CHAR | 10 | 0 | Visit Group | /DSD/VC_AUTH | |
| 19 | SHTYP |
SHTYP | SHTYP | CHAR | 4 | 0 | Shipment type | TVTK | |
| 20 | TPLST |
TPLST | TPLST | CHAR | 4 | 0 | Transportation planning point | TTDS | |
| 21 | STTRG |
STTRG | STTRG | CHAR | 1 | 0 | Overall transportation status | ||
| 22 | .INCLUDE |
0 | 0 | Shadow Nodes for Tree Controls | |||||
| 23 | NODEKEY |
TV_NODEKEY | TM_CHAR12 | CHAR | 12 | 0 | Tree Control: Node Key | ||
| 24 | NODEKEY_PARENT |
TV_NODEKEY | TM_CHAR12 | CHAR | 12 | 0 | Tree Control: Node Key | ||
| 25 | ROOT_NODE_FLAG |
CHAR | 1 | 0 | |||||
| 26 | TOUR_STATUS |
/DSD/ST_STATUS_ID | /DSD/ST_STATUS_ID | NUMC | 8 | 0 | Tour status ID | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /DSD/DE_FUPREC_L_S | AUTH |  /DSD/VC_AUTH |
AUTH |
|||
| 2 | /DSD/DE_FUPREC_L_S | DRIVER1 | KNA1 |
KUNNR |
|||
| 3 | /DSD/DE_FUPREC_L_S | DRIVER2 | KNA1 |
KUNNR |
|||
| 4 | /DSD/DE_FUPREC_L_S | ROUTE | TVRO |
ROUTE |
|||
| 5 | /DSD/DE_FUPREC_L_S | SHTYP | TVTK |
SHTYP |
|||
| 6 | /DSD/DE_FUPREC_L_S | TPLST | TTDS |
TPLST |
|||
| 7 | /DSD/DE_FUPREC_L_S | TRAILER | EQUI |
EQUNR |
|||
| 8 | /DSD/DE_FUPREC_L_S | VEHICLE | EQUI |
EQUNR |
|||
| 9 | /DSD/DE_FUPREC_L_S | VPID | /DSD/VC_VPH |
VPID |
|||
| 10 | /DSD/DE_FUPREC_L_S | VPTYP | /DSD/VC_VPTYPE |
VPTYP |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in |
