SAP table TVKN (Routes: Transportation Connection Points)
SAP table TVKN has 2 primary key fields being MANDT,KNOTE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KNOTE | Transportation Connection Points | CHAR | 10 | 0 | KNOTE | ||
| ADRNR | Address | CHAR | 10 | 0 | * | ADRNR | |
| GRENZ | Border crossing? | CHAR | 1 | 0 | GRENZ | ||
| UMSCH | Load transfer point | CHAR | 1 | 0 | UMPKT | ||
| FLUGH | Airport | CHAR | 1 | 0 | FLUGH | ||
| SEEHF | Indicator: Sea harbor | CHAR | 1 | 0 | SEEHF | ||
| BINHF | Indicator: Inland port | CHAR | 1 | 0 | BINHF | ||
| BAHNH | Train station ID | CHAR | 1 | 0 | BAHNH | ||
| BAHNR | TrainStnNumber | CHAR | 10 | 0 | BAHNR | ||
| STBNH | Indicator: General cargo train station | CHAR | 1 | 0 | STBNH | ||
| EXBNH | Express train station | CHAR | 1 | 0 | EXBNH | ||
| PABNH | Train station used for freight transport | CHAR | 1 | 0 | PABNH | ||
| LABNH | Loading train station | CHAR | 1 | 0 | LABNH | ||
| BAHNG | Rail carrier | CHAR | 10 | 0 | LFA1 | BAHNG | |
| STREKL | Leg class for rail | CHAR | 7 | 0 | STREKL | ||
| ZOLLS | Customs Office: Office of Exit/Entry for Foreign Trade | CHAR | 6 | 0 | T615 | DZOLLS | |
| SPFBK | Factory calendar key | CHAR | 2 | 0 | TFACD | FABKL | |
| AUFZTD | Length of waiting time in calendar days | DEC | 11 | 0 | AUFZTD | ||
| KUNNR | Customer Number | CHAR | 10 | 0 | KNA1 | KUNNR | |
| KUNABL | Unloading Point | CHAR | 25 | 0 | KNVA | ABLAD | |
| LIFNR | Account Number of Supplier | CHAR | 10 | 0 | LFA1 | LIFNR | |
| VSTEL | Shipping Point / Receiving Point | CHAR | 4 | 0 | TVST | VSTEL | |
| LSTEL | Loading Point | CHAR | 2 | 0 | TVLA | LSTEL | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| LGORT | Storage location | CHAR | 4 | 0 | T001L | LGORT_D | |
| LGNUM | Warehouse Number / Warehouse Complex | CHAR | 3 | 0 | T300 | LGNUM | |
| TOR | Door for Warehouse Number | CHAR | 3 | 0 | T30B | LGTOR |
TVKN foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TVKN | BAHNG | LFA1 | Supplier Master (General Section) | MANDT |
| 0 TVKN | BAHNG | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 TVKN | KUNABL | KNVA | Customer Master Unloading Points | MANDT |
| 1 TVKN | KUNABL | KNVA | Customer Master Unloading Points | KUNNR |
| 0 TVKN | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 0 TVKN | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 1 TVKN | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| 1 TVKN | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| 0 TVKN | LGORT | T001L | Storage Locations | MANDT |
| 0 TVKN | LGORT | T001L | Storage Locations | WERKS |
| 1 TVKN | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 1 TVKN | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 0 TVKN | MANDT | T000 | Clients | MANDT |
| 1 TVKN | TOR | T30B | WM Gates | MANDT |
| 1 TVKN | TOR | T30B | WM Gates | LGNUM |
| 1 TVKN | TOR | T30B | WM Gates | LGTOR |
| 0 TVKN | VSTEL | TVST | Organizational Unit: Shipping Points | MANDT |
| 0 TVKN | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |
| 1 TVKN | WERKS | T001W | Plants/Branches | WERKS |
| 0 TVKN | ZOLLS | T615 | Foreign Trade: Customs Offices | LAND1 |
| 0 TVKN | ZOLLS | T615 | Foreign Trade: Customs Offices | ZOLLA |