SAP ABAP Table TA20NHC (Negotiated Hotel Rates)

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	TA20NHC	Table Relationship Diagram
Short Description	Negotiated Hotel Rates

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	LOCATIONTYPE	☑	NEGO_HOTEL_GEO_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Geographical area type
3	LOCATION	☑	NEGO_HOTEL_GEO	FTPD_GEO_ID	CHAR	3	0	Geographical area of negotiated hotel rate
4	PROVIDER	☑	NEGO_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Provider of negotiated rate	TA21P
5	PROPERTY	☑	NEGO_HOTEL_PROPERTY_CODE	FTPD_HOTEL_PROP	CHAR	6	0	Identification of individual hotel
6	RATECODE	☑	NEGO_HOTEL_RATE_CODE	FTPD_HOTEL_RATE_CODE	CHAR	3	0	Negotiated hotel rate	TA21H
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
9	CORPDISC	☐	CORPO_DISCOUNT	CHAR20	CHAR	20	0	Contract number for identification
10	CORPORATION_ID	☐	HOTEL_CORPORATE_ID	FTPD_CORPORATION_ID	CHAR	30	0	Company identification for room reservation
11	PUSE	☐	PUSE_FLAG	CHAR1_X	CHAR	1	0	Private usage permitted

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA20NHC	PROVIDER	TA21P	PROVIDER	KEY	1	CN
2	TA20NHC	RATECODE	TA21H	RATECODE	KEY	1	CN

History

Last changed by/on	SAP	20010720
SAP Release Created in