Das Standardwerk zum Änderungs- und Transportmanagement in der 4. Auflage! In diesem Buch finden Sie alle Informationen, die Sie zum Planen, Implementieren und Warten von Systemlandschaften benötigen. Sie lernen die Grundlagen und die Bedienung aller relevanten Werkzeuge und erhalten detaillierte Anleitungen zur Änderungs- und Transportverwaltung. Diese Neuauflage berücksichtigt Neuerungen in den Bereichen SAP NetWeaver AS Java und Development Infrastructure, CTS+, SAP Solution Manager und Enhancement Packages. Bringen Sie ihr Wissen auf den neuesten Stand!
Bei amazon.de ansehen →The table FTPT_HOTEL (Travel Request Item - Hotel Service) is a standard table in SAP ERP. It belongs to the package PTRP.
Table | FTPT_HOTEL |
Short Text | Travel Request Item - Hotel Service |
Package | PTRP |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
PERNR | ✔ | Personnel Number | PERNR_D | NUMC | 8 | |
REINR | ✔ | Trip Number | REINR | NUMC | 10 | |
PLANNR | ✔ | Travel Plan Number (Sequential Number) | PLAN_NR | NUMC | 2 | * |
VARIANT | ✔ | Plan variant number (sequential number) | VARIANT_NR | NUMC | 2 | |
VARIANTVRS | ✔ | Version of travel plan | VARIANT_VERSION | NUMC | 2 | * |
ITEM | ✔ | Travel Request Item Number (Sequential Number) | ITEMPOS_NR | NUMC | 3 | FTPT_ITEM |
SERVICE | ✔ | Hotel number | HOTEL_SERVICE_NR | NUMC | 3 | |
HOTEL | Hotel Chain | HOTEL_PROVIDER | CHAR | 3 | TA21P | |
PROPERTY | Hotel Code (Key for an Individual Hotel) | HOTEL_PROPERTY | CHAR | 6 | ||
DATE_ARR | Arrival Date Hotel | HOTEL_DATE_ARR | DATS | 8 | ||
DATE_DEP | Departure Date Hotel | HOTEL_DATE_DEP | DATS | 8 | ||
LOC | Hotel Location | HOTEL_SLOCATION | CHAR | 3 | TA21L | |
NAME | Name of Hotel | HOTEL_NAME | CHAR | 40 | ||
ADDRESS | Hotel Address (address string separated by #) | HOTEL_ADDRESS | CHAR | 132 | ||
CLASS | Hotel category | HOTEL_CLASS | CHAR | 1 | ||
ROOMTYPE | Hotel Room Type | HOTEL_ROOMTYPE | CHAR | 1 | ||
MEALS | Hotel Meals | HOTEL_MEALS | CHAR | 1 | ||
OCCUPANCY | Number of hotel occupants | HOTEL_OCCUPANCY | INT1 | 3 | ||
ROOMS | Number of Hotel Rooms | HOTEL_NUMBER_OF_ROOMS | INT1 | 3 | ||
BEDS | Number of Beds | HOTEL_NUMBER_OF_BEDS | CHAR | 1 | ||
BED_TYPE | Bed Type | HOTEL_BEDDING_TYPE | CHAR | 1 | ||
ROOM_RATE_CODE | Rate Code (Hotel-Specific) | HOTEL_ROOM_RATE_CODE | CHAR | 3 | ||
RATE_CODE | Hotel Rate Category | HOTEL_RATE_PLAN_CODE | CHAR | 3 | * | |
RATE_CHANGE_IND | Price Change Due To Requested Period of Stay | HOTEL_RATE_CHANGE | CHAR | 1 | ||
GUARANTEE_NEEDED | Reservation Guarantee Required | HOTEL_GUARANTEE_NEEDED | CHAR | 1 | ||
GUARANTEE | Guarantee for room reservation at booking | HOTEL_GUARANTEE | CHAR | 40 | ||
DEPOSIT_NEEDED | Deposit Required for Reservation | HOTEL_DEPOSIT_NEEDED | CHAR | 1 | ||
DEPOSIT | Deposit payment method for room reservation | HOTEL_DEPOSIT | CHAR | 40 | ||
HOLD_IND | Guarantee for Room Availability | HOTEL_HOLD_IND | CHAR | 1 | ||
HOLD_TIME | Time limit for guarantee of room availability | HOTEL_HOLD_TIME | TIMS | 6 | ||
SELL_RULE_IND | Reservation Rules Exist | HOTEL_SELL_RULE_IND | CHAR | 1 | ||
CORPORATE_ID_IND | Company Identification Required | HOTEL_CORPORATE_ID_IND | CHAR | 1 | ||
CORPORATE_ID | Company identification for room reservation | HOTEL_CORPORATE_ID | CHAR | 30 | ||
QUALIFIED_IND | Rate Category Indicator: Authorization Required | HOTEL_QUALIFIED_IND | CHAR | 1 | ||
MIN_STAY_IND | Minimum Stay Required | HOTEL_MIN_STAY_IND | CHAR | 1 | ||
TOTAL_RATE_IND | Total price | HOTEL_TOTAL_RATE_IND | CHAR | 1 | ||
RATE | Rate/Price Per Night | HOTEL_RATE | CURR | 10 | ||
PRICE | Total Price for Hotel Stay | HOTEL_PRICE | CURR | 10 | ||
CURRENCY | Currency | HOTEL_CURRENCY | CUKY | 5 | TCURC | |
ADD_INFO | Additional hotel information | HOTEL_ADD_INFO | CHAR | 132 | ||
STATUS | Hotel Status | HOTEL_STATUS | CHAR | 2 | ||
TEMPLATE | Template indicator | VARIANT_TEMPLATE | CHAR | 1 | ||
AREA_LOC | Hotel Area | HOTEL_AREA_LOC | CHAR | 1 | ||
TRANS_LOC | Transportation Option to Hotel | HOTEL_TRANS_LOC | CHAR | 1 | ||
CONF_NUM | Hotel Reservation Number | HOTEL_CONFIRMATION_NUMBER | CHAR | 17 | ||
MEMBSHIP_PROVCAT | Customer Program: Provider Category | MEMBSHIP_PROVIDER_CATEGORY | CHAR | 1 | ||
MEMBSHIP_PROV | Customer Program: Provider Code | MEMBSHIP_PROVIDER_CODE | CHAR | 3 | * | |
MEMBSHIP_KRZL | Customer Program Code | PROV_PROGRAM_SHORTHAND | CHAR | 3 | TA21PF | |
MEMBSHIP_ID | Customer number | PROV_PROGRAM_NR | CHAR | 20 | ||
FLIGHT_MEM_PROV | Frequent flyer program: Provider code | FLIGHT_PROGRAM_PROVIDER_CODE | CHAR | 3 | * | |
FLIGHT_MEM_KRZL | Frequent Flyer Program ID | FLIGHT_PROGRAM_SHORTHAND | CHAR | 3 | TA21PF | |
FLIGHT_MEM_ID | Frequent flyer number | FLIGHT_PROGRAM_NR | CHAR | 20 | ||
PNR_NR | Line Number of Hotel in PNR (if PNR available) | HOTEL_LINENUMBER | INT2 | 5 | FTPT_PNR | |
PROFILE | Travel Profile | PROF_ID | CHAR | 8 | * | |
PROFITEM | Trip rule | PROF_ITEM | CHAR | 8 | * | |
KZTKT | Trip Activity Type | PLAN_ACTIVITY | CHAR | 1 | * | |
SPECHID | Class rule | SSPECID | CHAR | 8 | * | |
PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
HIGHEST_PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
COMPLETE_ACCESS | Direct Access to Reservation System of Hotel | COMPLETE_ACCESS_IND | CHAR | 1 | ||
BOOKING_CODE | Reservation Code for a Hotel Room | HOTEL_BOOKING_CODE | CHAR | 10 | ||
CATALOGUE_ID | Hotel Catalog Item (enterprise-specific) | HOTEL_ID | CHAR | 8 | TA21PH | |
CANCEL_TIME | Hotel Reservation: Cancelation Deadline | HOTEL_CANCEL_TIME | CHAR | 5 | ||
CANCEL_TYPE | Hotel Reservation: Time Unit for Cancelation Deadline | HOTEL_CANCEL_TYPE | CHAR | 1 | ||
SMOKE | Nonsmoking Room Requested | HOTEL_PREF_SMOKE | CHAR | 1 | ||
HCATG | Preferred Hotel Category | HOTEL_PREF_CLASS | CHAR | 1 | ||
BEDTP | Preferred Bed Type | HOTEL_PREF_BEDTYPE | CHAR | 1 | ||
RCATG | Preferred Room Category | HOTEL_PREF_ROOMTYPE | CHAR | 1 | ||
PREF1 | Hotel Chain - First Preference | HOTEL_PREF_PROVIDER | CHAR | 3 | TA21P | |
PREF2 | Hotel Chain - Second Preference | HOTEL_PREF_PROVIDER2 | CHAR | 3 | TA21P | |
PREF3 | Hotel Chain - Third Preference | HOTEL_PREF_PROVIDER3 | CHAR | 3 | TA21P | |
REASON_CODE | Reason Code | REASON_CODE | CHAR | 2 | * | |
REASON_TEXT | Reason Text | REASON_TEXT | CHAR | 132 | ||
GUARANTEE_GUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | ||
DEPOSIT_GUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | ||
LOC_TEXT | Location for Hotel Search | HRS_HOTEL_LOCATION | CHAR | 64 | ||
COUNTRY | HRS Country Code | HRS_HOTEL_COUNTRY | CHAR | 3 | ||
SINGLE_DOUBLE | Room Occupancy | HRS_HOTEL_OCCUPANCY | CHAR | 12 | ||
SEARCH_RADIUS | Radius for Hotel Search | HRS_HOTEL_SEARCH_RADIUS | NUMC | 4 | ||
HOTEL_NUMBER | HRS Hotel Number | HRS_HOTEL_NUMBER | CHAR | 10 | ||
BOOKING_NR | HRS Booking Number | HRS_HOTEL_BOOKING_NR | CHAR | 32 | ||
BOOKING_PW | HRS Booking Password | HRS_HOTEL_BOOKING_PW | CHAR | 32 | ||
RATE_NUMBER | HRS Rate | HRS_HOTEL_RATE_NUMBER | CHAR | 10 | ||
LOC_CODE | Hotel location code - Provider Specific | HOTEL_LOCATION_CODE | CHAR | 20 | ||
CORPORATE_RATE | Hotel Rate Type | HOTEL_RATE_TYPE | CHAR | 1 | ||
RATE_NAME | Direct Hotel/Room Rate Name | FTPD_HOTEL_RATE_NAME | CHAR | 40 | ||
EXCEEDING_FARE | Excess Amount over Lowest Offer | EXCEEDING_FARE | CURR | 10 | ||
EXCEEDING_FARE_C | Currency of Excess Amount over Lowest Offer | EXCEEDING_FARE_CURR | CUKY | 5 | * |