FTPT_REQUEST

Travel Plan Requests | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANTE Plan variant number (sequential number)
VARIANTVRS FK Version of travel plan
REQUESTVRS FK Version of travel request
PLAN_REQUEST Plan Request Indicator Show values
REQUEST Request number (sequential number
Column Name Description
💲 Currency of Request (CURRENCY):
PRICE Price of Request
Column Name Description
Column Name Description
DATE_BEG Beginning Date of Trip Segment
TIME_BEG Start Time of Trip Segment
DATE_END End Date of Trip Segment
TIME_END End Time of Trip Segment
Column Name Description
PLAN_REQUEST Plan Request Indicator Show values
REQUEST_TYPE Travel Item Type Show values
DEP_ARR Arrival/Departure time Show values
OS_STATUS Status of Other Service Show values
KZPRI Private Stopover Show values
SLEEP_AT_HOME Overnight Stay at Home Show values
ATTR_TRIP_BREAK Duration of Private Trip Break Show values
Column Name Description Domain name
ITINERARY_NUMBER Number of trip segment PTRVNUMC2
LOCATION_BEG Starting location of trip segment RZIELORT
LOCATION_END End location of trip segment RZIELORT
REASON Reason for Trip (for example, customer/requisitioner) RKUND
FIRST_TCODE Transaction Code TCODE
CITY City TEXT40
POST_CODE City postal code CHAR10
STREET Street TEXT60
HOUSE_NUM House Number TEXT10
LATITUDE Geo location latitude GEOLONLAT
LONGITUDE Geo location longitude GEOLONLAT
IATA_FLIGHT IATA Location for Airport FTPD_IATA_LOCATION
IATA_GROUND IATA Location for Hotel FTPD_IATA_LOCATION
TRAIN_STATION International Unique Train Station Number INT4
RGION Trip Country/Trip Country Group/Trip Region RGION
CITY_DISTRICTADR District TEXT40
CITY_CODEADR City code for city/street file CITY_CODE
OFFICE_FIND Grouping for Sales Office Determination OFFICE_FIND
OS_CODE Other Travel Service: Code FTPD_OS_CODE
LOC_BEG_IATA Start Location of Trip Segment (IATA) FTPD_IATA_LOCATION
LOC_END_IATA End Location of Trip Segment (IATA) FTPD_IATA_LOCATION
OS_CONF_NUMBER Confirmation Code of Other Service FTPD_OS_CONF_NR
COMMENT1 Comment About Request FTPD_REQUEST_COMMENT
KZREA Trip Type: Statutory KZREA
BEREI Trip Type: Enterprise-Specific BEREI
KZTKT Trip Activity Type KZTKT
Master Data Relations Join Conditions
Check Against Trip Activity - Travel Planning
  • Trip Activity Type
  • Client
  • FTPT_REQUEST.ACTIVITY == TA20R.ACTICITY
  • FTPT_REQUEST.MANDT == TA20R.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • FTPT_REQUEST.COUNTRY == T005.LAND1
  • FTPT_REQUEST.MANDT == T005.MANDT
Check Against Country Table T005
  • Country/Region Key
  • Client
  • FTPT_REQUEST.COUNTRY_BEG == T005.LAND1
  • FTPT_REQUEST.MANDT == T005.MANDT
Check Against Country
  • Country/Region Key
  • Client
  • FTPT_REQUEST.COUNTRY_END == T005.LAND1
  • FTPT_REQUEST.MANDT == T005.MANDT
Check Against Item
  • Travel Plan Number (Sequential Number)
  • Plan variant number (sequential number)
  • Personnel Number
  • Travel Request Item Number (Sequential Number)
  • Trip Number
  • Version of travel plan
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • FTPT_REQUEST.MANDT == T005S.MANDT
  • FTPT_REQUEST.COUNTRY == T005S.LAND1
  • FTPT_REQUEST.REGION == T005S.BLAND