1. Home
  2. Resources
  3. SAP Tables
  4. FTPS_REQUEST - Adobe form: Travel Plan Requests

SAP Table FTPS_REQUEST

Adobe form: Travel Plan Requests

FTPS_REQUEST (Adobe form: Travel Plan Requests) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FTPS_REQUEST to other SAP tables.

FTPS_REQUEST table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PERNR Personnel Number PERNR_D NUMC 8 0
REINR Trip Number REINR NUMC 10 0
PLANNR Travel Plan Number (Sequential Number) PLAN_NR NUMC 2 0
VARIANTE Plan variant number (sequential number) VARIANT_NR NUMC 2 0
VARIANTVRS Version of travel plan VARIANT_VERSION NUMC 2 0
REQUESTVRS Version of travel request REQUEST_VERSION NUMC 2 0
PLAN_REQUEST Plan Request Indicator PLAN_REQUEST CHAR 1 0
NULL Settlement
P Plan
R Request
REQUEST Request number (sequential number REQUEST_NR NUMC 2 0
ITINERARY_NUMBER Number of trip segment ITINERARY_NUMBER NUMC 2 0
DATE_BEG Beginning Date of Trip Segment REQUEST_DATEBEG DATS 8 0
TIME_BEG Start Time of Trip Segment REQUEST_TIMEBEG TIMS 6 0
DATE_END End Date of Trip Segment REQUEST_DATEEND DATS 8 0
TIME_END End Time of Trip Segment REQUEST_TIMEEND TIMS 6 0
LOCATION_BEG Starting location of trip segment REQUEST_LOC_BEG CHAR 59 0
COUNTRY_BEG Country Key LAND1 CHAR 3 0
LOCATION_END End location of trip segment REQUEST_LOC_END CHAR 59 0
COUNTRY_END Country Key LAND1 CHAR 3 0
REQUEST_TYPE Travel Item Type REQUEST_TYPE CHAR 2 0
OF Outbound Flight
RF Return Flight
H Hotel
CE Car Rental
OT Outbound Train
RT Return Train
O Other
DEP_ARR Char 20 CHAR20 CHAR 20 0
ITEM Travel Request Item Number (Sequential Number) ITEMPOS_NR NUMC 3 0
REASON Reason for trip (e.g. customer/requisitioner) RKUND CHAR 17 0
ACTIVITY Trip Activity Type PLAN_ACTIVITY CHAR 1 0
NAME Description of trip activity type - Travel Planning PLAN_ACTIVITY_NAME CHAR 30 0
OFFICE_FIND Grouping for Sales Office Determination OFFICE_FIND CHAR 2 0
OS_CODE Other Travel Service: Code OTHER_SERVICE_CODE CHAR 1 0
LOC_BEG_IATA Start Location of Trip Segment (IATA) REQUEST_LOC_BEG_IATA CHAR 3 0
LOC_END_IATA End Location of Trip Segment (IATA) REQUEST_LOC_END_IATA CHAR 3 0
OS_STATUS Status of Other Service OS_STATUS CHAR 1 0
0 Open
1 Requested
2 Confirmed
3 Cancellation Requested
4 Canceled
OS_CONF_NUMBER Confirmation Code of Other Service OS_CONF_NUMBER NUMC 16 0
PRICE Price of Request REQUEST_PRICE CURR 10 2
CURRENCY Currency of Request REQUEST_CURRENCY CUKY 5 0
COMMENT1 Comment About Request REQUEST_COMMENT CHAR 255 0
OS_NAME Other Travel Service: Name OTHER_SERVICE_NAME CHAR 30 0
OS_STATUS_TEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
REGION Region (State, Province, County) REGIO T005S CHAR 3 0
CITY City AD_CITY1 CHAR 40 0
POST_CODE City postal code AD_PSTCD1 CHAR 10 0
STREET Street AD_STREET CHAR 60 0
HOUSE_NUM House Number AD_HSNM1 CHAR 10 0
ADDRESS Texts used in travel management FITV_TEXT STRG 0 0
TRIP_BREAK Trip Break PTRA_WEB_FORM_TRIP_BREAK CHAR 1 0
X Yes
NULL No

FTPS_REQUEST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FTPS_REQUEST COUNTRY SYST MANDT T005 Countries MANDT
FTPS_REQUEST COUNTRY FTPS_REQUEST COUNTRY T005 Countries LAND1
FTPS_REQUEST REGION SYST MANDT T005S Taxes: Region (Province) Key MANDT
FTPS_REQUEST REGION FTPS_REQUEST COUNTRY T005S Taxes: Region (Province) Key LAND1
FTPS_REQUEST REGION FTPS_REQUEST REGION T005S Taxes: Region (Province) Key BLAND