FTPT_ITEM

Travel Service Request Item | #masterdata | Component: Travel Planning
Column Name Description
MANDT Client
PERNR Personnel Number
REINR Trip Number
PLANNR FK Travel Plan Number (Sequential Number)
VARIANT Plan variant number (sequential number)
VARIANTVRS FK Version of travel plan
ITEM Travel Request Item Number (Sequential Number)
Column Name Description
💲 Currency of request item (CURRENCY):
PRICE_AVAI Price at availability query of request item
PRICE_APPR Price at approval of request item
PRICE Price of request item
Column Name Description
Column Name Description
DATE_BEG Start Date of Request Item
TIME_BEG Start Time for Request Item
DATE_END End date of request item
TIME_END End time for request item
Column Name Description
REAL_CAT Travel service category Show values
STATUS Status of Request Item Show values
TEMPLATE Template indicator Show values
FIRMA Paid by Company Show values
DEP_ARR Arrival/Departure time Show values
Column Name Description Domain name
CLASS Request item class FTPD_ITEM_CLASS
REF_ITEM Reference to another request (return flight) FTPD_ITEM_ID
BELNR Document Number NRBEL
PERSONS Number of Persons on Request Item NUMC2
Master Data Relations Join Conditions
Check Against Category
  • Enterprise-Specific Travel Service Category
  • Client
  • User Grouping for Travel Planning
  • FTPT_ITEM.CATEGORY == TA20C.USER_CATEGORY
  • FTPT_ITEM.MANDT == TA20C.MANDT
  • FTPT_ITEM.USERG == TA20C.USERG
Check Against Currency
  • FTPT_ITEM.MANDT == TCURC.MANDT
  • FTPT_ITEM.CURRENCY == TCURC.WAERS
Check Against IATA Location
  • Starting Location of Request Item
  • Client
  • FTPT_ITEM.LOC_BEG == TA21L.LOCID
  • FTPT_ITEM.MANDT == TA21L.MANDT
Check Against IATA Location
  • End Location of Request Item
  • Client
  • FTPT_ITEM.LOC_END == TA21L.LOCID
  • FTPT_ITEM.MANDT == TA21L.MANDT
Check Against User Grouping for Travel Planning
  • FTPT_ITEM.MANDT == TA20B.MANDT
  • FTPT_ITEM.USERG == TA20B.USERG
Other Relations | to Master Data Relations ↑ Join Conditions
Foreign Key Against Reservation System
  • ?
  • Reservation System
  • Client
  • FTPT_ITEM.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • FTPT_ITEM.RES_SYSTEM == TA21P.PROVIDER
  • FTPT_ITEM.MANDT == TA21P.MANDT