SAP Table TVKN
Routes: Transportation Connection Points
TVKN (Routes: Transportation Connection Points) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TVKN to other SAP tables.
TVKN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
KNOTE
Transportation Connection Points
|
KNOTE |
CHAR
|
10 | 0 | ||||||||
|
ADRNR
Address
|
ADRNR |
CHAR
|
10 | 0 | ||||||||
|
GRENZ
Border crossing?
|
GRENZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
UMSCH
Load transfer point
|
UMPKT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FLUGH
Airport
|
FLUGH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SEEHF
Indicator: Sea harbor
|
SEEHF |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
BINHF
Indicator: Inland port
|
BINHF |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
BAHNH
Train station ID
|
BAHNH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
BAHNR
TrainStnNumber
|
BAHNR |
CHAR
|
10 | 0 | ||||||||
|
STBNH
Indicator: General cargo train station
|
STBNH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
EXBNH
Express train station
|
EXBNH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PABNH
Train station used for freight transport
|
PABNH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LABNH
Loading train station
|
LABNH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
BAHNG
Rail carrier
|
BAHNG | LFA1 |
CHAR
|
10 | 0 | |||||||
|
STREKL
Leg class for rail
|
STREKL |
CHAR
|
7 | 0 | ||||||||
|
ZOLLS
Customs Office: Office of Exit/Entry for Foreign Trade
|
DZOLLS | T615 |
CHAR
|
6 | 0 | |||||||
|
SPFBK
Factory calendar key
|
FABKL | TFACD |
CHAR
|
2 | 0 | |||||||
|
AUFZTD
Length of waiting time in calendar days
|
AUFZTD |
DEC
|
11 | 0 | ||||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||
|
KUNABL
Unloading Point
|
ABLAD | KNVA |
CHAR
|
25 | 0 | |||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||
|
VSTEL
Shipping Point/Receiving Point
|
VSTEL | TVST |
CHAR
|
4 | 0 | |||||||
|
LSTEL
Loading Point
|
LSTEL | TVLA |
CHAR
|
2 | 0 | |||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||
|
LGORT
Storage Location
|
LGORT_D | T001L |
CHAR
|
4 | 0 | |||||||
|
LGNUM
Warehouse Number / Warehouse Complex
|
LGNUM | T300 |
CHAR
|
3 | 0 | |||||||
|
TOR
Door for Warehouse Number
|
LGTOR | T30B |
CHAR
|
3 | 0 | |||||||
TVKN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TVKN | BAHNG | TVKN | BAHNG |
LFA1
Vendor Master (General Section)
|
LIFNR |
| TVKN | BAHNG | TVKN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| TVKN | KUNABL | TVKN | MANDT |
KNVA
Customer Master Unloading Points
|
MANDT |
| TVKN | KUNABL | TVKN | KUNNR |
KNVA
Customer Master Unloading Points
|
KUNNR |
| TVKN | KUNABL | TVKN | KUNABL |
KNVA
Customer Master Unloading Points
|
ABLAD |
| TVKN | KUNNR | TVKN | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| TVKN | KUNNR | TVKN | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| TVKN | LGNUM | TVKN | LGNUM |
T300
WM Warehouse Numbers
|
LGNUM |
| TVKN | LGNUM | TVKN | MANDT |
T300
WM Warehouse Numbers
|
MANDT |
| TVKN | LGORT | TVKN | WERKS |
T001L
Storage Locations
|
WERKS |
| TVKN | LGORT | TVKN | LGORT |
T001L
Storage Locations
|
LGORT |
| TVKN | LGORT | TVKN | MANDT |
T001L
Storage Locations
|
MANDT |
| TVKN | LIFNR | TVKN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| TVKN | LIFNR | TVKN | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| TVKN | LSTEL | TVKN | MANDT |
TVLA
Org.unit: Loading points per shipping point
|
MANDT |
| TVKN | LSTEL | TVKN | VSTEL |
TVLA
Org.unit: Loading points per shipping point
|
VSTEL |
| TVKN | LSTEL | TVKN | LSTEL |
TVLA
Org.unit: Loading points per shipping point
|
LSTEL |
| TVKN | MANDT | TVKN | MANDT |
T000
Clients
|
MANDT |
| TVKN | SPFBK | TVKN | SPFBK |
TFACD
Factory calendar definition
|
IDENT |
| TVKN | TOR | TVKN | MANDT |
T30B
WM Gates
|
MANDT |
| TVKN | TOR | TVKN | LGNUM |
T30B
WM Gates
|
LGNUM |
| TVKN | TOR | TVKN | TOR |
T30B
WM Gates
|
LGTOR |
| TVKN | VSTEL | TVKN | MANDT |
TVST
Organizational Unit: Shipping Points
|
MANDT |
| TVKN | VSTEL | TVKN | VSTEL |
TVST
Organizational Unit: Shipping Points
|
VSTEL |
| TVKN | WERKS | TVKN | MANDT |
T001W
Plants/Branches
|
MANDT |
| TVKN | WERKS | TVKN | WERKS |
T001W
Plants/Branches
|
WERKS |
| TVKN | ZOLLS | TVKN | ZOLLS |
T615
Foreign Trade: Customs Offices
|
ZOLLA |
| TVKN | ZOLLS | TVKN | MANDT |
T615
Foreign Trade: Customs Offices
|
MANDT |
| TVKN | ZOLLS | V_TVKN_COM | LAND1 |
T615
Foreign Trade: Customs Offices
|
LAND1 |