SAP ABAP Table TA21PH (Customer-Specific Hotel Catalog)

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

Table Category	TRANSP	Transparent table
Transparent table	TA21PH	Table Relationship Diagram
Short Description	Customer-Specific Hotel Catalog

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	*
2	HOTEL_ID	☑	HOTEL_ID	FTPD_HOTEL_INDEX	CHAR	8	0	Hotel Catalog Item (enterprise-specific)
3	PROVIDER	☐	PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider Code	TA21P
4	LOCID	☐	IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	IATA location	TA21L
5	PROPERTY	☐	HOTEL_PROPERTY	FTPD_HOTEL_PROP	CHAR	6	0	Hotel Code (Key for an Individual Hotel)
6	ASC_LOCID	☐	ASC_IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	Assigned IATA locations of hotel if available	TA21L
7	NAME	☐	HOTEL_NAME	TEXT40	CHAR	40	0	Name of Hotel
8	STRASSE	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
9	STRASSE2	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
10	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	PLZ	☐	POST_CODE	POST_CODE	CHAR	10	0	Postal Code	*
12	ORT	☐	HOTEL_LOCATION	TEXT30	CHAR	30	0	Hotel location
13	ORTSTEIL	☐	HOTEL_SUBLOCATION	TEXT30	CHAR	30	0	District of hotel
14	TELEFON	☐	TELNR_BAS	TELNR_BAS	CHAR	14	0	Telephone Number
15	FAX	☐	HOTEL_FAXNR	TELNR_BAS	CHAR	14	0	Hotel: Fax Number
16	AVAILABLE	☐	HOTEL_AVAILABILITY	FTPD_HOTEL_AVAILABILITY	CHAR	1	0	Hotel: Access via GDS or Asterix
17	RESERVE	☐	HOTEL_RESERVE_VIA	FTPD_BOOK_VIA	CHAR	1	0	Hotel: Reservation method
18	PRIORITY	☐	HOTEL_PRIORITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of hotel in travel profile	TA20PPP
19	SPECHID	☐	HOTEL_SSPECHID	FTPD_SSPEC_ID	CHAR	8	0	General Class Rule for Hotel	TA20PS
20	AREA_LOC	☐	HOTEL_AREA_LOC	FTPD_HOTEL_AREA	CHAR	1	0	Hotel Area
21	TRANS_LOC	☐	HOTEL_TRANS_LOC	FTPD_HOTEL_TRANSPORT	CHAR	1	0	Transportation Option to Hotel
22	RFCDEST	☐	ASTERIX_RFCDEST	RFCDEST	CHAR	32	0	RFC Destination Asterix	*
23	URL	☐	INFO_URL	TEXT255	CHAR	255	0	URL (Uniform Resource Locator) of Information Source

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA21PH	ASC_LOCID	TA21L	LOCID	REF	1	CN
2	TA21PH	LAND1	T005	LAND1	REF	1	CN
3	TA21PH	LOCID	TA21L	LOCID	REF	1	CN
4	TA21PH	PRIORITY	TA20PPP	PRIORITY	REF	1	CN
5	TA21PH	PROVIDER	TA21P	PROVIDER	REF	1	CN
6	TA21PH	SPECHID	TA20PS	SPECID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in