SAP ABAP Table TA23ADR (Predefined Addresses in Travel Management)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV (Application Component) Travel Management
     ⤷ PTRM_WEB_INTERFACE (Package) RFC Modules for Web User Interface: General Travel Mgt

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TA23ADR	Table Relationship Diagram
Short Description	Predefined Addresses in Travel Management

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	ADRKEY	☑	PTRV_ADRKEY	NUMC8	NUMC	8	0	Key of Table TA23ADR (Sequence Number)
3	.INCLUDE	☐				0	0	Predefined Addresses / Customizing
4	CATEGORY	☐	PTRV_CATEGORY_ID	CATEGORY_ID	CHAR	10	0	Custom Categories for Predefined Addresses	TA23ADRCAT
5	.INCLUDE	☐				0	0	Travel Web Interface: Addresses
6	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
7	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
8	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
9	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
10	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
11	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
12	.INCLUDE	☐				0	0	Travel Web Interface: Geocoding
13	LATITUDE	☐	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude
14	LONGITUDE	☐	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
15	IATA_FLIGHT	☐	IATA_LOCATION_AIRPORT	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Airport	TA21L
16	IATA_GROUND	☐	IATA_LOCATION_HOTEL	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Hotel	TA21L
17	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	TA23ADR	CATEGORY	TA23ADRCAT	CATEGORY	KEY	1	CN
2	TA23ADR	COUNTRY	T005	LAND1	KEY	1	CN
3	TA23ADR	IATA_FLIGHT	TA21L	LOCID	KEY	1	CN
4	TA23ADR	IATA_GROUND	TA21L	LOCID	KEY	1	CN
5	TA23ADR	MANDT	T000	MANDT	KEY	1	CN
6	TA23ADR	REGION	T005S	BLAND	KEY	1	CN
7	TA23ADR	TRAIN_STATION	TA22RSS	BFNR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600