FTPT_A_ITEM

Travel Service Request Item | #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)
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
Master Data Relations Join Conditions
Enterprise-Specific Travel Service Category
  • Enterprise-Specific Travel Service Category
  • Client
  • User Grouping for Travel Planning
  • FTPT_A_ITEM.CATEGORY == TA20C.USER_CATEGORY
  • FTPT_A_ITEM.MANDT == TA20C.MANDT
  • FTPT_A_ITEM.USERG == TA20C.USERG
Currency of request item
  • FTPT_A_ITEM.MANDT == TCURC.MANDT
  • FTPT_A_ITEM.CURRENCY == TCURC.WAERS
Starting Location of Request Item
  • Starting Location of Request Item
  • Client
  • FTPT_A_ITEM.LOC_BEG == TA21L.LOCID
  • FTPT_A_ITEM.MANDT == TA21L.MANDT
End Location of Request Item
  • End Location of Request Item
  • Client
  • FTPT_A_ITEM.LOC_END == TA21L.LOCID
  • FTPT_A_ITEM.MANDT == TA21L.MANDT
User Grouping for Travel Planning
  • FTPT_A_ITEM.MANDT == TA20B.MANDT
  • FTPT_A_ITEM.USERG == TA20B.USERG