SAP ABAP View V_TA20NHS (Negotiated Hotel Rates with Catalog Hotels)

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

View Type	C	Maintenance View
Maintenance View	V_TA20NHS
Short Description	Negotiated Hotel Rates with Catalog Hotels
Root table	TA20NHS	Negotiated Hotel Rates (Nego Rates) with Catalog Hotel

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TA20NHS	TA20NHS
2	TA21PH	TA20NHS	HOTEL_ID	E
3	TCURC	TA20NHS	CURRENCY	E
4	TCURT	TCURC	WAERS	I
5	T005	TA21PH	LAND1	E
6	T005T	T005	LAND1	I
7	TA21L	TA21PH	LOCID	E
8	TA21L1	TA21L	LOCID	I
9	TA21H	TA20NHS	RATECODE	E
10	TA21H1	TA21H	RATECODE	I
11	TA21P	TA21PH	PROVIDER	E

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TA20NHS	MANDT		☐	MANDT	☐	Client
2	HOTEL_ID	TA20NHS	HOTEL_ID		☐	HOTEL_ID	☐	Hotel Catalog Item (enterprise-specific)
3	BEDTYPE	TA20NHS	BEDTYPE		☐	NEGO_HOTEL_BEDTYPE	☐	Bed type of negotiated rate
4	BEDS	TA20NHS	BEDS		☐	NEGO_HOTEL_NUMBER_OF_BEDS	☐	Negotiated rate: Number of beds
5	ROOMTYPE	TA20NHS	ROOMTYPE		☐	NEGO_HOTEL_ROOMTYPE	☐	Room type of negotiated rate
6	RATECODE	TA20NHS	RATECODE		☐	NEGO_HOTEL_RATE_CODE	☐	Negotiated hotel rate
7	ENDDA	TA20NHS	ENDDA		☐	ENDDA	☐	End Date
8	BEGDA	TA20NHS	BEGDA		☐	BEGDA	☐	Start Date
9	CORPDISC	TA20NHS	CORPDISC		☐	CORPO_DISCOUNT	☐	Contract number for identification
10	PUSE	TA20NHS	PUSE		☐	PUSE_FLAG	☐	Private usage permitted
11	PRICE	TA20NHS	PRICE		☐	NEGO_FARE	☐	Price of negotiated rate
12	CURRENCY	TA20NHS	CURRENCY		☐	NEGO_FARE_CURRENCY	☐	Currency of negotiated rate
13	TOTAL_RATE_IND	TA20NHS	TOTAL_RATE_IND		☐	HOTEL_TOTAL_RATE_IND	☐	Total price
14	GUARANTEE_NEEDED	TA20NHS	GUARANTEE_NEEDED		☐	HOTEL_GUARANTEE_NEEDED	☐	Reservation Guarantee Required
15	GUARANTEE	TA20NHS	GUARANTEE		☐	HOTEL_GUARANTEE	☐	Guarantee for room reservation at booking
16	DEPOSIT	TA20NHS	DEPOSIT		☐	HOTEL_DEPOSIT_NEEDED	☐	Deposit Required for Reservation
17	HOLD_IND	TA20NHS	HOLD_IND		☐	HOTEL_HOLD_IND	☐	Guarantee for Room Availability
18	CORPORATE_ID_IND	TA20NHS	CORPORATE_ID_IND		☐	HOTEL_CORPORATE_ID_IND	☐	Company Identification Required
19	MIN_STAY_IND	TA20NHS	MIN_STAY_IND		☐	HOTEL_MIN_STAY_IND	☐	Minimum Stay Required
20	MEALS	TA20NHS	MEALS		☐	HOTEL_MEALS	☐	Hotel Meals
21	KTEXT	TCURT	KTEXT	R	☐	KTEXT_CURT	☐	Short text
22	PROVIDER	TA21PH	PROVIDER	R	☐	PROVIDER_CODE	☐	Provider Code
23	LOCID	TA21PH	LOCID	R	☐	IATA_LOCATION	☐	IATA location
24	NAME	TA21PH	NAME	R	☐	HOTEL_NAME	☐	Name of Hotel
25	STRASSE	TA21PH	STRASSE	R	☐	HOTEL_STREET	☐	Street and house number of hotel
26	STRASSE2	TA21PH	STRASSE2	R	☐	HOTEL_STREET	☐	Street and house number of hotel
27	PLZ	TA21PH	PLZ	R	☐	POST_CODE	☐	Postal Code
28	ORT	TA21PH	ORT	R	☐	HOTEL_LOCATION	☐	Hotel location
29	ORTSTEIL	TA21PH	ORTSTEIL	R	☐	HOTEL_SUBLOCATION	☐	District of hotel
30	LAND1	TA21PH	LAND1	H	☐	LAND1	☐	Country Key
31	LANDX	T005T	LANDX	R	☐	LANDX	☐	Country Name
32	LOCNAME	TA21L1	NAME	R	☐	IATA_LOCATION_NAME	☐	IATA Location Name
33	RATE_NAME	TA21H1	NAME	R	☐	HOTEL_RATE_CODE_NAME	☐	Hotel rate description
34	PROVIDER_NAME	TA21P	NAME	R	☐	PROVIDER_NAME	☐	Provider Name

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in