SAP ABAP Table V_TA21PH (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TA21PH	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

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	NAME	☐	HOTEL_NAME	TEXT40	CHAR	40	0	Name of Hotel
7	STRASSE	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
8	STRASSE2	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
9	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	PLZ	☐	POST_CODE	POST_CODE	CHAR	10	0	Postal Code
11	ORT	☐	HOTEL_LOCATION	TEXT30	CHAR	30	0	Hotel location
12	ORTSTEIL	☐	HOTEL_SUBLOCATION	TEXT30	CHAR	30	0	District of hotel
13	TELEFON	☐	TELNR_BAS	TELNR_BAS	CHAR	14	0	Telephone Number
14	FAX	☐	HOTEL_FAXNR	TELNR_BAS	CHAR	14	0	Hotel: Fax Number
15	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
16	LOC_NAME	☐	IATA_LOCATION_NAME	TEXT30	CHAR	30	0	IATA Location Name
17	PROV_NAME	☐	PROVIDER_NAME	TEXT30	CHAR	30	0	Provider Name
18	AREA_LOC	☐	HOTEL_AREA_LOC	FTPD_HOTEL_AREA	CHAR	1	0	Hotel Area
19	TRANS_LOC	☐	HOTEL_TRANS_LOC	FTPD_HOTEL_TRANSPORT	CHAR	1	0	Transportation Option to Hotel
20	AVAILABLE	☐	HOTEL_AVAILABILITY	FTPD_HOTEL_AVAILABILITY	CHAR	1	0	Hotel: Access via GDS or Asterix
21	RFCDEST	☐	ASTERIX_RFCDEST	RFCDEST	CHAR	32	0	RFC Destination Asterix
22	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	V_TA21PH	LAND1	T005	LAND1	REF	1	CN
2	V_TA21PH	LOCID	TA21L	LOCID	REF	1	CN
3	V_TA21PH	PROVIDER	TA21P	PROVIDER	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in