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
⤷ 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 |