SAP ABAP Table TA20NRH (Discount Agreement for Hotel Accommodations)
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 TA20NRH   Table Relationship Diagram
Short Description Discount Agreement for Hotel Accommodations    
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 PROVIDER_CODE FTPD_PROVIDER_CODE CHAR 3   0   Provider Code TA21P
3 RATECODE HOTEL_RATE_CODE FTPD_HOTEL_RATE_CODE CHAR 3   0   Hotel rate TA21H
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 HOTEL_PROPERTY FTPD_HOTEL_PROP CHAR 6   0   Hotel Code (Key for an Individual Hotel)  
7 HOTELCLASS NEGO_HOTEL_CLASS FTPD_HOTEL_CLASS CHAR 1   0   Hotel category  
8 ROOMTYPE NEGO_HOTEL_ROOMTYPE FTPD_HOTEL_ROOMTYPE CHAR 1   0   Room type of negotiated rate  
9 BEDTYPE NEGO_HOTEL_BEDTYPE FTPD_BEDDING_TYPE CHAR 1   0   Bed type of negotiated rate  
10 ENDDA ENDDA DATUM DATS 8   0   End Date  
11 BEGDA BEGDA DATUM DATS 8   0   Start Date  
12 CORP_DISC CORPO_DISCOUNT CHAR20 CHAR 20   0   Contract number for identification  
13 PUSE PUSE_FLAG CHAR1_X CHAR 1   0   Private usage permitted  
14 DISCTYPE REBATE_DISC_TYPE FTPD_DISC_TYPE CHAR 1   0   Discount Type  
15 DISCPERCENT REBATE_DISC_PERCENT INT2 INT2 5   0   Discount in Percent  
16 DISCAMOUNT REBATE_DISC_AMOUNT FTPD_AMOUNT CURR 10   2   Discount Amount  
17 CURRENCY NEGO_FARE_CURRENCY WAERS CUKY 5   0   Currency of negotiated rate TCURC
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TA20NRH CURRENCY TCURC WAERS REF 1 CN
2 TA20NRH PROVIDER TA21P PROVIDER KEY 1 CN
3 TA20NRH RATECODE TA21H RATECODE KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in