FTPT_A_TRAIN

Travel Request Item - Train Service | #masterdata | Component: Travel Expenses
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR Travel Plan Number (Sequential Number)
VARIANTE Plan variant number (sequential number)
VARIANTVRS Version of travel plan
ITEM 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
Column Name Description
Column Name Description
DATE_DEP Start date
TIME_DEP Start time
DATE_ARR Arrival date
TIME_ARR Arrival time
Column Name Description
CLASS Train class Show values
COMPART_CLASS Compart. class Show values
STATUS Status Show values
TEMPLATE Template 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
Other Relations Join Conditions
Train provider
  • ?
  • Train provider
  • Client
  • FTPT_A_TRAIN.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_A_TRAIN.PROVIDER == TA21P.PROVIDER
  • FTPT_A_TRAIN.MANDT == TA21P.MANDT