SAP ABAP Table V_TVKN_ADR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TVKN_ADR	Table Relationship Diagram
Short Description	Generated Table for View

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	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	NAME1	☑	NAME1_BAS	NAME	CHAR	35	0	Name 1
11	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	REGIO	☑	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
13	PSTLZ	☑	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
14	ORT01	☑	ORT01_GP	TEXT35	CHAR	35	0	City
15	LZONE	☑	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
16	SORTL	☑	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
17	CRDAT	☑	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
18	CRNAM	☑	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TVKN_ADR	LAND1	T005	LAND1	REF	1	CN
2	V_TVKN_ADR	LZONE	TZONE	ZONE1	REF	1	CN
3	V_TVKN_ADR	MANDT	T000	MANDT	KEY	1	CN
4	V_TVKN_ADR	REGIO	T005S	BLAND	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in