SAP Table TVKN - Routes: Transportation Connection Points

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
KNOTE X KNOTE CHAR 3 10 0 TVKN Transportation Connection Points
ADRNR ADRNR CHAR 13 10 0 Address
GRENZ GRENZ CHAR 23 1 0 Border crossing?
UMSCH UMPKT CHAR 24 1 0 Load transfer point
FLUGH FLUGH CHAR 25 1 0 Airport
SEEHF SEEHF CHAR 26 1 0 Indicator: Sea harbor
BINHF BINHF CHAR 27 1 0 Indicator: Inland port
BAHNH BAHNH CHAR 28 1 0 Train station ID
BAHNR BAHNR CHAR 29 10 0 TrainStnNumber
STBNH STBNH CHAR 39 1 0 Indicator: General cargo train station
EXBNH EXBNH CHAR 40 1 0 Express train station
PABNH PABNH CHAR 41 1 0 Train station used for freight transport
LABNH LABNH CHAR 42 1 0 Loading train station
BAHNG BAHNG CHAR 43 10 0 LFA1 Rail carrier
STREKL STREKL CHAR 53 7 0 Leg class for rail
ZOLLS DZOLLS CHAR 60 6 0 T615 Customs Office: Office of Exit/Entry for Foreign Trade
SPFBK FABKL CHAR 66 2 0 TFACD Factory calendar key
AUFZTD AUFZTD DEC 68 11 0 Length of waiting time in calendar days
KUNNR KUNNR CHAR 74 10 0 KNA1 Customer Number
KUNABL ABLAD CHAR 84 25 0 Unloading Point
LIFNR LIFNR CHAR 109 10 0 LFA1 Account Number of Vendor or Creditor
VSTEL VSTEL CHAR 119 4 0 Shipping Point/Receiving Point
LSTEL LSTEL CHAR 123 2 0 TVLA Loading Point
WERKS WERKS_D CHAR 125 4 0 T001W Plant
LGORT LGORT_D CHAR 129 4 0 T001L Storage Location
LGNUM LGNUM CHAR 133 3 0 T300 Warehouse Number / Warehouse Complex
TOR LGTOR CHAR 136 3 0 T30B Door for Warehouse Number

517502Extract & Load Routes from the SAP-IT Legacy system