TA20PHC

Assignment Table of Hotel Catalog Items for Travel Profiles | #other | Component: Travel Planning
Column Name Description
MANDT Client
PROFILE FK Travel Profile
KZTKT FK Trip Activity Type
LOCID FK IATA location
HOTEL_ID FK Hotel Catalog Item (enterprise-specific)
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Check against trip activity type - Travel Planning
  • Trip Activity Type
  • Client
  • TA20PHC.KZTKT == TA20R.ACTICITY
  • TA20PHC.MANDT == TA20R.MANDT
Check Against IATA Location
  • IATA location
  • Client
  • TA20PHC.LOCID == TA21L.LOCID
  • TA20PHC.MANDT == TA21L.MANDT
Check against priority
Check against profile
  • Travel Profile
  • Client
  • TA20PHC.PROFILE == TA20P.PROFILE
  • TA20PHC.MANDT == TA20P.MANDT
Check against service specification 'Hotel'
  • ?
  • General Class Rule for Hotel
  • Client
  • TA20PHC.[column in domain "CATEGORY"] == TA20PS.CATEGORY
  • TA20PHC.SPECHID == TA20PS.SPECID
  • TA20PHC.MANDT == TA20PS.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check against hotel catalog position
  • TA20PHC.MANDT == TA21PH.MANDT
  • TA20PHC.HOTEL_ID == TA21PH.HOTEL_ID