FTPT_TRAIN

Travel Request Item - Train Service | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANT Plan variant number (sequential number)
VARIANTVRS Version of travel plan
ITEM FK Travel Request Item Number (Sequential Number)
SERVICE Train number
Column Name Description
💲 Currency for Seat Reservation Price (SEAT_PRICE_CURR):
SEAT_PRICE Price of Seat Reservation
💲 Currency for Supplement (Train) (SUPPLEMENT_CURR):
SUPPLEMENT Supplement for Train Connection
💲 Currency (BASE_CURR):
BASE_FARE Basic Rate for Rail Excluding Taxes
💲 Currency (TOTAL_CURR):
TOTAL_FARE Total Fare for Rail
💲 Currency (TAXES_CURR):
TAXES Taxes
💲 Currency (LOWER_CURR):
LOWER_FARE Lowest Rate for Rail
Column Name Description
Column Name Description
DATE_DEP Start date
TIME_DEP Start time
DATE_ARR Arrival date
TIME_ARR Arrival time
TICKET_LAST_DATE Last Ticketing Date
Column Name Description
CLASS Train class Show values
COMPART_CLASS Compart. class Show values
STATUS Status Show values
TEMPLATE Template indicator Show values
CONNECTION_TAG Connection Indicator Show values
Column Name Description Domain name
TRAIN_NR Train number FTPD_FLIGHT_NR
COMPARTMENT_NR Compartment no. FTPD_TRAIN_COMPARTMENT_NR
LOC_DEP Departure loc. FTPD_GEO_ID
GATE_DEP Departure platform FTPD_FLIGHT_GATE
LOC_ARR Arrival Location FTPD_GEO_ID
GATE_ARR Arrival platform FTPD_FLIGHT_GATE
COACH_NR Coach number CHAR4
SEAT_NR Seat Number CHAR4
RES_INFO Reservation Information CHAR50
LOC_DEP_NAME Name of Location TEXT100
LOC_ARR_NAME Name of Location TEXT100
Master Data Relations Join Conditions
Check Against Travel Service Request 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
Other Relations Join Conditions
Check Against Rail Company
  • ?
  • Train provider
  • Client
  • FTPT_TRAIN.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_TRAIN.PROVIDER == TA21P.PROVIDER
  • FTPT_TRAIN.MANDT == TA21P.MANDT