SAP ABAP Table V_TA20PHC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TA20PHC	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	PROFILE	☑	PROF_ID	FTPD_PROF_ID	CHAR	8	0	Travel Profile	TA20P
3	KZTKT	☑	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	TA20R
4	LOCID	☑	IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	IATA location	TA21L
5	HOTEL_ID	☑	HOTEL_ID	FTPD_HOTEL_INDEX	CHAR	8	0	Hotel Catalog Item (enterprise-specific)	TA21PH
6	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	SPECHID	☐	HOTEL_SSPECHID	FTPD_SSPEC_ID	CHAR	8	0	General Class Rule for Hotel	TA20PS
9	PRIORITY	☐	PROFIL_PRIROITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of trip rule	TA20PPP
10	HOTELNAME	☐	HOTEL_NAME	TEXT40	CHAR	40	0	Name of Hotel
11	PROFILENAME	☐	PROF_NAME	FTPD_NAME	CHAR	40	0	Name of travel profile
12	PRIORITYNAME	☐	PRIO_NAME	TEXT30	CHAR	30	0	Description of priority
13	SPECIDNAME	☐	SSPEC_NAME	TEXT30	CHAR	30	0	Description of a class rule
14	STRASSE	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
15	STRASSE2	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
16	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
17	PLZ	☐	POST_CODE	POST_CODE	CHAR	10	0	Postal Code
18	ORT	☐	HOTEL_LOCATION	TEXT30	CHAR	30	0	Hotel location
19	ORTSTEIL	☐	HOTEL_SUBLOCATION	TEXT30	CHAR	30	0	District of hotel
20	LOCATION_NAME	☐	IATA_LOCATION_NAME	TEXT30	CHAR	30	0	IATA Location Name
21	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
22	PROVIDER	☐	PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider Code	TA21P
23	NAME	☐	PROVIDER_NAME	TEXT30	CHAR	30	0	Provider Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TA20PHC	HOTEL_ID	TA21PH	HOTEL_ID	KEY	1	CN
2	V_TA20PHC	KZTKT	TA20R	ACTICITY	KEY	1	CN
3	V_TA20PHC	LAND1	T005	LAND1	REF	1	CN
4	V_TA20PHC	LOCID	TA21L	LOCID	KEY	1	CN
5	V_TA20PHC	PRIORITY	TA20PPP	PRIORITY	REF	1	CN
6	V_TA20PHC	PROFILE	TA20P	PROFILE	KEY	1	CN
7	V_TA20PHC	PROVIDER	TA21P	PROVIDER	REF	1	CN
8	V_TA20PHC	SPECHID	TA20PS	SPECID	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in