SAP ABAP View V_TA23ADR1 (DB View: Predefined Addresses in Travel Management (TA23ADR))
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
View Type D Database View 
Database View V_TA23ADR1  
Short Description DB View: Predefined Addresses in Travel Management (TA23ADR)    
Root table TA23ADR   Predefined Addresses in Travel Management 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TA23ADR TA23ADR
2 TA23ADR1  
3 TA23ADRCAT  
4 TA23ADRCAT1  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 TA23ADR MANDT JL EQ 0 0
2 TA23ADR1 MANDT JR EQ AND 0 0
3 TA23ADR ADRKEY JL EQ 0 0
4 TA23ADR1 ADRKEY JR EQ AND 0 0
5 TA23ADRCAT MANDT JL EQ 0 0
6 TA23ADR MANDT JR EQ AND 0 0
7 TA23ADRCAT CATEGORY JL EQ 0 0
8 TA23ADR CATEGORY JR EQ AND 0 0
9 TA23ADRCAT MANDT JL EQ 0 0
10 TA23ADRCAT1 MANDT JR EQ AND 0 0
11 TA23ADRCAT CATEGORY JL EQ 0 0
12 TA23ADRCAT1 CATEGORY JR EQ AND 0 0
13 TA23ADRCAT1 SPRAS JL EQ 0 0
14 TA23ADR1 SPRAS JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT TA23ADR MANDT   MANDT Client
2 SPRAS TA23ADR1 SPRAS   SPRAS Language Key
3 ADRKEY TA23ADR ADRKEY   PTRV_ADRKEY Key of Table TA23ADR (Sequence Number)
4 CATEGORY TA23ADR CATEGORY   PTRV_CATEGORY_ID Custom Categories for Predefined Addresses
5 CATEGORY_NAME TA23ADRCAT1 CATEGORY_NAME   PTRV_CATEGORY_NAME Name of Address Category
6 COUNTRY TA23ADR COUNTRY   LAND1 Country Key
7 REGION TA23ADR REGION   REGIO Region (State, Province, County)
8 CITY TA23ADR CITY   AD_CITY1 City
9 POST_CODE TA23ADR POST_CODE   AD_PSTCD1 City postal code
10 STREET TA23ADR STREET   AD_STREET Street
11 HOUSE_NUM TA23ADR HOUSE_NUM   AD_HSNM1 House Number
12 LATITUDE TA23ADR LATITUDE   GEOLAT Geo location latitude
13 LONGITUDE TA23ADR LONGITUDE   GEOLON Geo location longitude
14 IATA_FLIGHT TA23ADR IATA_FLIGHT   IATA_LOCATION_AIRPORT IATA Location for Airport
15 IATA_GROUND TA23ADR IATA_GROUND   IATA_LOCATION_HOTEL IATA Location for Hotel
16 TRAIN_STATION TA23ADR TRAIN_STATION   TRAIN_BFNR International Unique Train Station Number
17 ADDRESS_NAME TA23ADR1 ADDRESS_NAME   PTRV_ADDRESS_NAME Name of Predefined Address
                 
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 600