SAP ABAP Table V_TA20NHS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TA20NHS	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)	TA21PH
3	BEDTYPE	☑	NEGO_HOTEL_BEDTYPE	FTPD_BEDDING_TYPE	CHAR	1	0	Bed type of negotiated rate
4	BEDS	☑	NEGO_HOTEL_NUMBER_OF_BEDS	CHAR1	CHAR	1	0	Negotiated rate: Number of beds
5	ROOMTYPE	☑	NEGO_HOTEL_ROOMTYPE	FTPD_HOTEL_ROOMTYPE	CHAR	1	0	Room type of negotiated rate
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	PUSE	☐	PUSE_FLAG	CHAR1_X	CHAR	1	0	Private usage permitted
11	PRICE	☐	NEGO_FARE	FTPD_PRICE	CURR	10	2	Price of negotiated rate
12	CURRENCY	☐	NEGO_FARE_CURRENCY	WAERS	CUKY	5	0	Currency of negotiated rate	TCURC
13	TOTAL_RATE_IND	☐	HOTEL_TOTAL_RATE_IND	CHAR1_X	CHAR	1	0	Total price
14	GUARANTEE_NEEDED	☐	HOTEL_GUARANTEE_NEEDED	CHAR1_X	CHAR	1	0	Reservation Guarantee Required
15	GUARANTEE	☐	HOTEL_GUARANTEE	CHAR40	CHAR	40	0	Guarantee for room reservation at booking
16	DEPOSIT	☐	HOTEL_DEPOSIT_NEEDED	CHAR1_X	CHAR	1	0	Deposit Required for Reservation
17	HOLD_IND	☐	HOTEL_HOLD_IND	CHAR1_X	CHAR	1	0	Guarantee for Room Availability
18	CORPORATE_ID_IND	☐	HOTEL_CORPORATE_ID_IND	CHAR1_X	CHAR	1	0	Company Identification Required
19	MIN_STAY_IND	☐	HOTEL_MIN_STAY_IND	CHAR1_X	CHAR	1	0	Minimum Stay Required
20	MEALS	☐	HOTEL_MEALS	FTPD_HOTEL_MEALS	CHAR	1	0	Hotel Meals
21	KTEXT	☐	KTEXT_CURT	TEXT15	CHAR	15	0	Short text
22	PROVIDER	☐	PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider Code	TA21P
23	LOCID	☐	IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	IATA location	TA21L
24	NAME	☐	HOTEL_NAME	TEXT40	CHAR	40	0	Name of Hotel
25	STRASSE	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
26	STRASSE2	☐	HOTEL_STREET	TEXT60	CHAR	60	0	Street and house number of hotel
27	PLZ	☐	POST_CODE	POST_CODE	CHAR	10	0	Postal Code
28	ORT	☐	HOTEL_LOCATION	TEXT30	CHAR	30	0	Hotel location
29	ORTSTEIL	☐	HOTEL_SUBLOCATION	TEXT30	CHAR	30	0	District of hotel
30	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
31	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
32	LOCNAME	☐	IATA_LOCATION_NAME	TEXT30	CHAR	30	0	IATA Location Name
33	RATE_NAME	☐	HOTEL_RATE_CODE_NAME	TEXT30	CHAR	30	0	Hotel rate description
34	PROVIDER_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_TA20NHS	CURRENCY	TCURC	WAERS	REF	1	CN
2	V_TA20NHS	HOTEL_ID	TA21PH	HOTEL_ID	KEY	1	CN
3	V_TA20NHS	LAND1	T005	LAND1	REF	1	CN
4	V_TA20NHS	LOCID	TA21L	LOCID	REF	1	CN
5	V_TA20NHS	PROVIDER	TA21P	PROVIDER	REF	1	CN
6	V_TA20NHS	RATECODE	TA21H	RATECODE	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in