This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table FTPT_FLIGHT (Travel request item - flight service) is a standard table in SAP ERP. It belongs to the package PTRP.
Table | FTPT_FLIGHT |
Short Text | Travel request item - flight 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 | ✔ | Travel service item number of flight | FLIGHT_SERVICE_NR | NUMC | 3 | |
AIRLINE | Airline | FLIGHT_AIRLINE | CHAR | 3 | TA21P | |
FLIGHT_NR | Flight Number | FLIGHT_NR | CHAR | 6 | ||
DATE_DEP | Flight departure date | FLIGHT_DATE_DEP | DATS | 8 | ||
TIME_DEP | Flight departure time | FLIGHT_TIME_DEP | TIMS | 6 | ||
LOC_DEP | Departure Location | FLIGHT_SLOC_DEP | CHAR | 3 | TA21L | |
TERM_DEP | Terminal Code (Departure) | FLIGHT_TERM_DEP | CHAR | 2 | ||
GATE_DEP | Flight departure terminal | FLIGHT_GATE_DEP | CHAR | 6 | ||
DATE_ARR | Flight arrival date | FLIGHT_DATE_ARR | DATS | 8 | ||
TIME_ARR | Flight arrival time | FLIGHT_TIME_ARR | TIMS | 6 | ||
LOC_ARR | Flight Arrival Location | FLIGHT_SLOC_ARR | CHAR | 3 | TA21L | |
TERM_ARR | Terminal code (arrival) | FLIGHT_TERM_ARR | CHAR | 2 | ||
GATE_ARR | Flight arrival terminal | FLIGHT_GATE_ARR | CHAR | 6 | ||
RESTRICT_FARE | Restricted airfare | FARE_RESTRICT | CHAR | 1 | ||
CABIN | Flight Cabin Class | FLIGHT_CABIN | CHAR | 1 | ||
RBD | Flight Booking Code (RBD) | FLIGHT_RBD | CHAR | 1 | ||
MARRIED | Married Segments | MARRIED_SEGMENT | INT1 | 3 | ||
STATUS | Flight Status | FLIGHT_STATUS | CHAR | 2 | ||
TEMPLATE | Template indicator | VARIANT_TEMPLATE | CHAR | 1 | ||
PNR_NR | Line Number of Flight in PNR (if PNR available) | FLIGHT_LINENUMBER | INT2 | 5 | FTPT_PNR | |
ELEC_TKT | Electronic ticketing for flight is possible | FLIGHT_ELEC_TKT | CHAR | 1 | ||
PARTICIPATION | Access type code: Airline | FLIGHT_PARTICIPATION | CHAR | 5 | ||
CHECKIN_TIME | Check-in time | FLIGHT_CHECKIN | TIMS | 6 | ||
OP_AIRLINE | Airline | FLIGHT_AIRLINE | CHAR | 3 | TA21P | |
PROFILE | Travel Profile | PROF_ID | CHAR | 8 | TA20P | |
PROFITEM | Trip rule | PROF_ITEM | CHAR | 8 | TA20PI | |
KZTKT | Trip Activity Type | PLAN_ACTIVITY | CHAR | 1 | * | |
SPECHID | Class rule | SSPECID | CHAR | 8 | TA20PS | |
PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
HIGHEST_PRIORITY | Priority of trip rule | PROFIL_PRIROITY | CHAR | 1 | ||
BEST_BUY_RC | Indicator: Use 'Best Buy' Reason Codes | BEST_BUY_REASON_CODE | CHAR | 1 | ||
REASON_CODE | Reason Code | REASON_CODE | CHAR | 2 | * | |
REASON_TEXT | Reason Text | REASON_TEXT | CHAR | 132 | ||
CONNECTION_TAG | Connection Indicator | FTPD_CONNECTION_INDICATOR | CHAR | 1 |