SAP ABAP Table V_TA23ADR (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class
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	ADRKEY	☑	PTRV_ADRKEY	NUMC8	NUMC	8	0	Key of Table TA23ADR (Sequence Number)
3	CATEGORY	☐	PTRV_CATEGORY_ID	CATEGORY_ID	CHAR	10	0	Custom Categories for Predefined Addresses	TA23ADRCAT
4	ADDRESS_NAME	☐	PTRV_ADDRESS_NAME	TEXT30	CHAR	30	0	Name of Predefined Address
5	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
7	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
8	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
9	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
10	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
11	LATITUDE	☐	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude
12	LONGITUDE	☐	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
13	IATA_FLIGHT	☐	IATA_LOCATION_AIRPORT	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Airport	TA21L
14	IATA_GROUND	☐	IATA_LOCATION_HOTEL	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Hotel	TA21L
15	TRAIN_STATION	☐	TRAIN_BFNR	INT4	INT4	10	0	International Unique Train Station Number	TA22RSS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TA23ADR	CATEGORY	TA23ADRCAT	CATEGORY	KEY	1	CN
2	V_TA23ADR	COUNTRY	T005	LAND1	KEY	1	CN
3	V_TA23ADR	IATA_FLIGHT	TA21L	LOCID	KEY	1	CN
4	V_TA23ADR	IATA_GROUND	TA21L	LOCID	KEY	1	CN
5	V_TA23ADR	MANDT	T000	MANDT	KEY	1	CN
6	V_TA23ADR	REGION	T005S	BLAND	KEY	1	CN
7	V_TA23ADR	TRAIN_STATION	TA22RSS	BFNR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in