SAP ABAP Table TA20NH (Negotiated hotel rates (corporate nego 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 TA20NH   Table Relationship Diagram
Short Description Negotiated hotel rates (corporate nego 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 PROVIDER NEGO_PROVIDER FTPD_PROVIDER_CODE CHAR 3   0   Provider of negotiated rate TA21P
3 LOCATIONTYPE NEGO_HOTEL_GEO_TYPE FTPD_GEO_TYPE CHAR 1   0   Geographical area type  
4 LOCATION NEGO_HOTEL_GEO FTPD_GEO_ID CHAR 3   0   Geographical area of negotiated hotel rate  
5 PROPERTY NEGO_HOTEL_PROPERTY_CODE FTPD_HOTEL_PROP CHAR 6   0   Identification of individual hotel  
6 HOTELCLASS NEGO_HOTEL_NUMBER_OF_BEDS CHAR1 CHAR 1   0   Negotiated rate: Number of beds  
7 BEDTYPE NEGO_HOTEL_BEDTYPE FTPD_BEDDING_TYPE CHAR 1   0   Bed type of negotiated rate  
8 ROOMTYPE NEGO_HOTEL_ROOMTYPE FTPD_HOTEL_ROOMTYPE CHAR 1   0   Room type of negotiated rate  
9 RATECODE NEGO_HOTEL_RATE_CODE FTPD_HOTEL_RATE_CODE CHAR 3   0   Negotiated hotel rate TA21H
10 ENDDA ENDDA DATUM DATS 8   0   End Date  
11 BEGDA BEGDA DATUM DATS 8   0   Start Date  
12 CORPDISC CORPO_DISCOUNT CHAR20 CHAR 20   0   Contract number for identification  
13 PUSE PUSE_FLAG CHAR1_X CHAR 1   0   Private usage permitted  
14 PRICE NEGO_FARE FTPD_PRICE CURR 10   2   Price of negotiated rate  
15 CURRENCY NEGO_FARE_CURRENCY WAERS CUKY 5   0   Currency of negotiated rate TCURC
16 TOTAL_RATE_IND HOTEL_TOTAL_RATE_IND CHAR1_X CHAR 1   0   Total price  
17 GUARANTEE HOTEL_GUARANTEE CHAR40 CHAR 40   0   Guarantee for room reservation at booking  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TA20NH CURRENCY TCURC WAERS REF 1 CN
2 TA20NH PROVIDER TA21P PROVIDER KEY 1 CN
3 TA20NH RATECODE TA21H RATECODE KEY 1 CN
History
Last changed by/on SAP  20010720 
SAP Release Created in