SAP ABAP Table TVKN (Routes: Transportation Connection Points)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VTRC (Package) SD R/3 customizing transport processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TVKN	Table Relationship Diagram
Short Description	Routes: Transportation Connection Points

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KNOTE	☑	KNOTE	KNOTN	CHAR	10	0	Transportation Connection Points
3	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
4	GRENZ	☐	GRENZ	XFELD	CHAR	1	0	Border crossing?
5	UMSCH	☐	UMPKT	XFELD	CHAR	1	0	Load transfer point
6	FLUGH	☐	FLUGH	XFELD	CHAR	1	0	Airport
7	SEEHF	☐	SEEHF	XFELD	CHAR	1	0	Indicator: Sea harbor
8	BINHF	☐	BINHF	XFELD	CHAR	1	0	Indicator: Inland port
9	BAHNH	☐	BAHNH	XFELD	CHAR	1	0	Train station ID
10	BAHNR	☐	BAHNR	BAHNR	CHAR	10	0	TrainStnNumber
11	STBNH	☐	STBNH	XFELD	CHAR	1	0	Indicator: General cargo train station
12	EXBNH	☐	EXBNH	XFELD	CHAR	1	0	Express train station
13	PABNH	☐	PABNH	XFELD	CHAR	1	0	Train station used for freight transport
14	LABNH	☐	LABNH	XFELD	CHAR	1	0	Loading train station
15	BAHNG	☐	BAHNG	LIFNR	CHAR	10	0	Rail carrier	LFA1
16	STREKL	☐	STREKL	CHAR7	CHAR	7	0	Leg class for rail
17	ZOLLS	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	T615
18	SPFBK	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
19	AUFZTD	☐	AUFZTD	TSTRDURAG	DEC	11	0	Length of waiting time in calendar days
20	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
21	KUNABL	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point	KNVA
22	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
23	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
24	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
25	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
26	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
27	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
28	TOR	☐	LGTOR	LGTOR	CHAR	3	0	Door for Warehouse Number	T30B

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TVKN	BAHNG	LFA1	LIFNR	REF	C	CN
2	TVKN	KUNABL	KNVA	ABLAD
3	TVKN	KUNNR	KNA1	KUNNR	REF	C	CN
4	TVKN	LGNUM	T300	LGNUM
5	TVKN	LGORT	T001L	LGORT	REF	C	CN
6	TVKN	LIFNR	LFA1	LIFNR	REF	C	CN
7	TVKN	LSTEL	TVLA	LSTEL	REF	C	CN
8	TVKN	MANDT	T000	MANDT	KEY	1	CN
9	TVKN	SPFBK	TFACD	IDENT	REF	C	CN
10	TVKN	TOR	T30B	LGTOR
11	TVKN	VSTEL	TVST	VSTEL	REF	C	CN
12	TVKN	WERKS	T001W	WERKS	REF	C	CN
13	TVKN	ZOLLS	T615	ZOLLA

History

Last changed by/on	SAP	20110901
SAP Release Created in