SAP Table FTPT_REQUEST
Travel Plan Requests
Unsere Literaturempfehlung
IDoc-Entwicklung für SAP: Customizing, Erweiterung, Eigenentwicklung
Wenn der Standard nicht ausreicht: Mit diesem Buch lernen Sie, IDocs selbstständig zu programmieren und zu erweitern. Die Autorin beschreibt Customizing-Techniken, die Erweiterung der Standardbausteine und komplette Eigenentwicklungen. Ob Rückmeldungen von Statuswerten, E-Mail-Workflows oder Serialisierung – für alle Aufgaben finden Sie Anleitungen und Tipps aus der Programmierpraxis. Neu in dieser Auflage: Überwachung und Fehlerbehandlung mit dem SAP Application Interface Framework.
Bei amazon.de ansehen →
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 |