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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| UMSCH | Load transfer point | UMPKT | CHAR | 1 | 0 |
Possible values
|
||||||
| FLUGH | Airport | FLUGH | CHAR | 1 | 0 |
Possible values
|
||||||
| SEEHF | Indicator: Sea harbor | SEEHF | CHAR | 1 | 0 |
Possible values
|
||||||
| BINHF | Indicator: Inland port | BINHF | CHAR | 1 | 0 |
Possible values
|
||||||
| BAHNH | Train station ID | BAHNH | CHAR | 1 | 0 |
Possible values
|
||||||
| BAHNR | TrainStnNumber | BAHNR | CHAR | 10 | 0 | |||||||
| STBNH | Indicator: General cargo train station | STBNH | CHAR | 1 | 0 |
Possible values
|
||||||
| EXBNH | Express train station | EXBNH | CHAR | 1 | 0 |
Possible values
|
||||||
| PABNH | Train station used for freight transport | PABNH | CHAR | 1 | 0 |
Possible values
|
||||||
| LABNH | Loading train station | LABNH | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| TVKN | BAHNG | TVKN | BAHNG | LFA1 | Vendor Master (General Section) | LIFNR |
| TVKN | KUNABL | TVKN | KUNNR | KNVA | Customer Master Unloading Points | KUNNR |
| TVKN | KUNABL | TVKN | KUNABL | KNVA | Customer Master Unloading Points | ABLAD |
| TVKN | KUNABL | TVKN | MANDT | KNVA | Customer Master Unloading Points | MANDT |
| 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 | MANDT | T300 | WM Warehouse Numbers | MANDT |
| TVKN | LGNUM | TVKN | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| TVKN | LGORT | TVKN | MANDT | T001L | Storage Locations | MANDT |
| TVKN | LGORT | TVKN | WERKS | T001L | Storage Locations | WERKS |
| TVKN | LGORT | TVKN | LGORT | T001L | Storage Locations | LGORT |
| TVKN | LIFNR | TVKN | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| TVKN | LIFNR | TVKN | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| 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 | TOR | T30B | WM Gates | LGTOR |
| TVKN | TOR | TVKN | MANDT | T30B | WM Gates | MANDT |
| TVKN | TOR | TVKN | LGNUM | T30B | WM Gates | LGNUM |
| TVKN | VSTEL | TVKN | MANDT | TVST | Organizational Unit: Shipping Points | MANDT |
| TVKN | VSTEL | TVKN | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |
| TVKN | WERKS | TVKN | WERKS | T001W | Plants/Branches | WERKS |
| TVKN | WERKS | TVKN | MANDT | T001W | Plants/Branches | MANDT |
| TVKN | ZOLLS | TVKN | MANDT | T615 | Foreign Trade: Customs Offices | MANDT |
| TVKN | ZOLLS | V_TVKN_COM | LAND1 | T615 | Foreign Trade: Customs Offices | LAND1 |
| TVKN | ZOLLS | TVKN | ZOLLS | T615 | Foreign Trade: Customs Offices | ZOLLA |
