SAP ABAP View V_TA20PHC (Assignment of Hotel Catalog Items to Travel Profiles)
Hierarchy
SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   FI-TV-PL (Application Component) Travel Planning
     PTRP (Package) Travel Planning
Basic Data
View Type C Maintenance View 
Maintenance View V_TA20PHC  
Short Description Assignment of Hotel Catalog Items to Travel Profiles    
Root table TA20PHC   Assignment Table of Hotel Catalog Items for Travel Profiles 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TA20PHC TA20PHC
2 TA20P TA20PHC PROFILE E
3 TA20PPP TA20PHC PRIORITY E
4 TA20PS TA20PHC SPECHID E
5 TA20R TA20PHC KZTKT E
6 TA21L TA20PHC LOCID E
7 TA21PH TA20PHC HOTEL_ID E
8 TA20P1 TA20P PROFILE I
9 TA20PPP1 TA20PPP PRIORITY I
10 TA20PS1 TA20PS SPECID I
11 TA20R1 TA20R ACTICITY I
12 TA21L1 TA21L LOCID I
13 T005 TA21PH LAND1 E
14 T005T T005 LAND1 I
15 TA21P TA21PH PROVIDER E
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT TA20PHC MANDT   MANDT Client
2 PROFILE TA20PHC PROFILE S PROF_ID Travel Profile
3 KZTKT TA20PHC KZTKT   PLAN_ACTIVITY Trip Activity Type
4 LOCID TA20PHC LOCID   IATA_LOCATION IATA location
5 HOTEL_ID TA20PHC HOTEL_ID   HOTEL_ID Hotel Catalog Item (enterprise-specific)
6 ENDDA TA20PHC ENDDA   ENDDA End Date
7 BEGDA TA20PHC BEGDA   BEGDA Start Date
8 SPECHID TA20PHC SPECHID   HOTEL_SSPECHID General Class Rule for Hotel
9 PRIORITY TA20PHC PRIORITY   PROFIL_PRIROITY Priority of trip rule
10 HOTELNAME TA21PH NAME R HOTEL_NAME Name of Hotel
11 PROFILENAME TA20P1 NAME R PROF_NAME Name of travel profile
12 PRIORITYNAME TA20PPP1 NAME R PRIO_NAME Description of priority
13 SPECIDNAME TA20PS1 NAME R SSPEC_NAME Description of a class rule
14 STRASSE TA21PH STRASSE R HOTEL_STREET Street and house number of hotel
15 STRASSE2 TA21PH STRASSE2 R HOTEL_STREET Street and house number of hotel
16 LAND1 TA21PH LAND1 R LAND1 Country Key
17 PLZ TA21PH PLZ R POST_CODE Postal Code
18 ORT TA21PH ORT R HOTEL_LOCATION Hotel location
19 ORTSTEIL TA21PH ORTSTEIL R HOTEL_SUBLOCATION District of hotel
20 LOCATION_NAME TA21L1 NAME R IATA_LOCATION_NAME IATA Location Name
21 LANDX T005T LANDX R LANDX Country Name
22 PROVIDER TA21PH PROVIDER R PROVIDER_CODE Provider Code
23 NAME TA21P NAME R PROVIDER_NAME Provider Name
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20140121 
SAP Release Created in