SAP ABAP View V_TVKN_ADR (Transportation Connection Point Addresses)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ VTRI (Package) Interfaces to external transport systems

Basic Data

View Type	D	Database View
Database View	V_TVKN_ADR
Short Description	Transportation Connection Point Addresses
Root table	TVKN	Routes: Transportation Connection Points

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TVKN	TVKN
2	SADR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TVKN	MANDT	JL	EQ				0	0
2	SADR	MANDT	JR	EQ			AND	0	0
3	TVKN	ADRNR	JL	EQ				0	0
4	SADR	ADRNR	JR	EQ			AND	0	0
5	SADR	NATIO		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TVKN	MANDT		☐	MANDT	☐	Client
2	KNOTE	TVKN	KNOTE		☐	KNOTE	☐	Transportation Connection Points
3	ADRNR	TVKN	ADRNR		☐	ADRNR	☐	Address
4	GRENZ	TVKN	GRENZ		☐	GRENZ	☐	Border crossing?
5	UMSCH	TVKN	UMSCH		☐	UMPKT	☐	Load transfer point
6	FLUGH	TVKN	FLUGH		☐	FLUGH	☐	Airport
7	SEEHF	TVKN	SEEHF		☐	SEEHF	☐	Indicator: Sea harbor
8	BINHF	TVKN	BINHF		☐	BINHF	☐	Indicator: Inland port
9	BAHNH	TVKN	BAHNH		☐	BAHNH	☐	Train station ID
10	NAME1	SADR	NAME1		☐	NAME1_BAS	☐	Name 1
11	LAND1	SADR	LAND1		☐	LAND1	☐	Country Key
12	REGIO	SADR	REGIO		☐	REGIO	☐	Region (State, Province, County)
13	PSTLZ	SADR	PSTLZ		☐	PSTLZ_BAS	☐	Postal code
14	ORT01	SADR	ORT01		☐	ORT01_GP	☐	City
15	LZONE	SADR	LZONE		☐	LZONE	☐	Transportation zone to or from which the goods are delivered
16	SORTL	SADR	SORTL		☐	SORTL_BAS	☐	Sort field
17	CRDAT	SADR	CRDAT		☐	CR_DAT	☐	Addresses: Creation date
18	CRNAM	SADR	CRNAM		☐	CR_NAM	☐	Addresses: Created by

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in