SAP ABAP Table TVKN_ALL (Transportation connection point and additional information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VTR (Package) SD R/3 transport processing

Basic Data

Table Category	INTTAB	Structure
Structure	TVKN_ALL	Table Relationship Diagram
Short Description	Transportation connection point and additional information

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in