SAP Table FTPT_REQUEST
Travel Plan Requests
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table FTPT_REQUEST (Travel Plan Requests) is a standard table in SAP ERP. It belongs to the package PTRP.
Technical Information
| Table | FTPT_REQUEST |
| Short Text | Travel Plan Requests |
| Package | PTRP |
| Table Type | Transparent Table |
Fields for Table FTPT_REQUEST
| 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 | * |
| VARIANTE | ✔ | Plan variant number (sequential number) | VARIANT_NR | NUMC | 2 | |
| VARIANTVRS | ✔ | Version of travel plan | VARIANT_VERSION | NUMC | 2 | FTPT_VARIANT |
| REQUESTVRS | ✔ | Version of travel request | REQUEST_VERSION | NUMC | 2 | FTPT_REQ_HEAD |
| PLAN_REQUEST | ✔ | Plan Request Indicator | PLAN_REQUEST | CHAR | 1 | |
| REQUEST | ✔ | Request number (sequential number | REQUEST_NR | NUMC | 2 | |
| ITINERARY_NUMBER | Number of trip segment | ITINERARY_NUMBER | NUMC | 2 | ||
| DATE_BEG | Beginning Date of Trip Segment | REQUEST_DATEBEG | DATS | 8 | ||
| TIME_BEG | Start Time of Trip Segment | REQUEST_TIMEBEG | TIMS | 6 | ||
| DATE_END | End Date of Trip Segment | REQUEST_DATEEND | DATS | 8 | ||
| TIME_END | End Time of Trip Segment | REQUEST_TIMEEND | TIMS | 6 | ||
| LOCATION_BEG | Starting location of trip segment | REQUEST_LOC_BEG | CHAR | 59 | ||
| COUNTRY_BEG | Country Key | LAND1 | CHAR | 3 | T005 | |
| LOCATION_END | End location of trip segment | REQUEST_LOC_END | CHAR | 59 | ||
| COUNTRY_END | Country Key | LAND1 | CHAR | 3 | T005 | |
| REQUEST_TYPE | Travel Item Type | REQUEST_TYPE | CHAR | 2 | ||
| DEP_ARR | Arrival/Departure time | DEP_ARR | CHAR | 1 | ||
| ITEM | Travel Request Item Number (Sequential Number) | ITEMPOS_NR | NUMC | 3 | FTPT_ITEM | |
| REASON | Reason for trip (e.g. customer/requisitioner) | RKUND | CHAR | 17 | ||
| ACTIVITY | Trip Activity Type | PLAN_ACTIVITY | CHAR | 1 | TA20R | |
| FIRST_TCODE | Transaction Code | SYTCODE | CHAR | 20 | * | |
| COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | |
| CITY | City | AD_CITY1 | CHAR | 40 | ||
| POST_CODE | City postal code | AD_PSTCD1 | CHAR | 10 | ||
| STREET | Street | AD_STREET | CHAR | 60 | ||
| HOUSE_NUM | House Number | AD_HSNM1 | CHAR | 10 | ||
| LATITUDE | Geo location latitude | GEOLAT | DEC | 15 | ||
| LONGITUDE | Geo location longitude | GEOLON | DEC | 15 | ||
| IATA_FLIGHT | IATA Location for Airport | IATA_LOCATION_AIRPORT | CHAR | 3 | * | |
| IATA_GROUND | IATA Location for Hotel | IATA_LOCATION_HOTEL | CHAR | 3 | * | |
| TRAIN_STATION | International Unique Train Station Number | TRAIN_BFNR | INT4 | 10 | ||
| RGION | Trip Country/Trip Country Group/Trip Region | RGION | CHAR | 5 | * | |
| CITY_DISTRICTADR | District | AD_CITY2 | CHAR | 40 | ||
| CITY_CODEADR | City code for city/street file | AD_CITYNUM | CHAR | 12 | * | |
| OFFICE_FIND | Grouping for Sales Office Determination | OFFICE_FIND | CHAR | 2 | * | |
| OS_CODE | Other Travel Service: Code | OTHER_SERVICE_CODE | CHAR | 1 | ||
| LOC_BEG_IATA | Start Location of Trip Segment (IATA) | REQUEST_LOC_BEG_IATA | CHAR | 3 | * | |
| LOC_END_IATA | End Location of Trip Segment (IATA) | REQUEST_LOC_END_IATA | CHAR | 3 | * | |
| OS_STATUS | Status of Other Service | OS_STATUS | CHAR | 1 | ||
| OS_CONF_NUMBER | Confirmation Code of Other Service | OS_CONF_NUMBER | NUMC | 16 | ||
| PRICE | Price of Request | REQUEST_PRICE | CURR | 10 | ||
| CURRENCY | Currency of Request | REQUEST_CURRENCY | CUKY | 5 | * | |
| COMMENT1 | Comment About Request | REQUEST_COMMENT | CHAR | 255 | ||
| KZREA | Trip Type: Statutory | KZREA | CHAR | 1 | * | |
| BEREI | Trip Type: Enterprise-Specific | BEREI | CHAR | 1 | * | |
| KZTKT | Trip Activity Type | KZTKT | CHAR | 1 | * | |
| KZPRI | Private Stopover | KZPRI | CHAR | 1 | ||
| SLEEP_AT_HOME | Overnight Stay at Home | PTRV_SLEEP_AT_HOME | CHAR | 1 |