SAP ABAP Table TA20NH1 (Negotiated hotel rates (language-dependent))

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	TA20NH1	Table Relationship Diagram
Short Description	Negotiated hotel rates (language-dependent)

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	LANGU	☑	LANGU	SPRAS	LANG	1	0	Language Key	*
3	PROVIDER	☑	NEGO_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Provider of negotiated rate	TA21P
4	LOCATIONTYPE	☑	NEGO_HOTEL_GEO_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Geographical area type
5	LOCATION	☑	NEGO_HOTEL_GEO	FTPD_GEO_ID	CHAR	3	0	Geographical area of negotiated hotel rate
6	PROPERTY	☑	NEGO_HOTEL_PROPERTY_CODE	FTPD_HOTEL_PROP	CHAR	6	0	Identification of individual hotel
7	HOTELCLASS	☑	NEGO_HOTEL_CLASS	FTPD_HOTEL_CLASS	CHAR	1	0	Hotel category
8	BEDTYPE	☑	NEGO_HOTEL_BEDTYPE	FTPD_BEDDING_TYPE	CHAR	1	0	Bed type of negotiated rate
9	ROOMTYPE	☑	NEGO_HOTEL_ROOMTYPE	FTPD_HOTEL_ROOMTYPE	CHAR	1	0	Room type of negotiated rate
10	RATECODE	☑	HOTEL_RATE_CODE	FTPD_HOTEL_RATE_CODE	CHAR	3	0	Hotel rate	TA21H
11	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date	TA20NH
12	SHORTTXT	☐	NEGO_SHORT_TEXT	TEXT20	CHAR	20	0	Description of Rate
13	LONGTXT	☐	NEGO_LONG_TEXT	TEXT132	CHAR	132	0	Rate Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA20NH1	ENDDA	TA20NH	ENDDA	TEXT	1	N
2	TA20NH1	PROVIDER	TA21P	PROVIDER		1	CN
3	TA20NH1	RATECODE	TA21H	RATECODE		1	CN

History

Last changed by/on	SAP	20031107
SAP Release Created in