FTPT_REQUEST SAP (Travel Plan Requests) Table details

Dictionary Type: Table
Description: Travel Plan Requests




ABAP Code to SELECT data from FTPT_REQUEST
Related tables to FTPT_REQUEST
Access table FTPT_REQUEST




Table field list including key, data, relationships and ABAP select examples

FTPT_REQUEST is a standard SAP Table which is used to store Travel Plan Requests data and is available within R/3 SAP systems depending on the version and release level.

The FTPT_REQUEST table consists of various fields, each holding specific information or linking keys about Travel Plan Requests data available in SAP. These include MANDT (Client), PERNR (Personnel Number), REINR (Trip Number), PLANNR (Travel Plan Number (Sequential Number)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FTPT_REQUEST table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
REINRTrip Number REINRNUMC10REINR
PLANNRTravel Plan Number (Sequential Number) PLAN_NRNUMC2Assigned to domainFTPD_PLAN_NR
VARIANTEPlan variant number (sequential number) VARIANT_NRNUMC2FTPD_VARIANT_NR
VARIANTVRSVersion of travel plan VARIANT_VERSIONNUMC2FTPT_VARIANTFTPD_VARIANT_VERSION
REQUESTVRSVersion of travel request REQUEST_VERSIONNUMC2FTPT_REQ_HEADFTPD_REQUEST_VERSION
PLAN_REQUESTPlan Request Indicator PLAN_REQUESTCHAR1FTPD_PLAN_REQUEST
REQUESTRequest number (sequential number REQUEST_NRNUMC2FTPD_REQUEST_NR
ITINERARY_NUMBERNumber of trip segment ITINERARY_NUMBERNUMC2PTRVNUMC2
DATE_BEGBeginning Date of Trip Segment REQUEST_DATEBEGDATS8DATUM
TIME_BEGStart Time of Trip Segment REQUEST_TIMEBEGTIMS6TIME
DATE_ENDEnd Date of Trip Segment REQUEST_DATEENDDATS8DATUM
TIME_ENDEnd Time of Trip Segment REQUEST_TIMEENDTIMS6TIME
LOCATION_BEGStarting location of trip segment REQUEST_LOC_BEGCHAR59RZIELORT
COUNTRY_BEGCountry Key LAND1CHAR3T005LAND1LND
LOCATION_ENDEnd location of trip segment REQUEST_LOC_ENDCHAR59RZIELORT
COUNTRY_ENDCountry Key LAND1CHAR3T005LAND1LND
REQUEST_TYPETravel Item Type REQUEST_TYPECHAR2FTPD_REQUEST_TYPE
DEP_ARRArrival/Departure time DEP_ARRCHAR1FTPD_DEP_ARR
ITEMTravel Request Item Number (Sequential Number) ITEMPOS_NRNUMC3FTPT_ITEMFTPD_ITEM_ID
REASONReason for trip (e.g. customer/requisitioner) RKUNDCHAR17RKUND
ACTIVITYTrip Activity Type PLAN_ACTIVITYCHAR1TA20RFTPD_PLAN_ACTIVITY
.INCLU--AP 0
FIRST_TCODETransaction Code SYTCODECHAR20Assigned to domainTCODE
.INCLU--AP 0
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUMHouse Number AD_HSNM1CHAR10TEXT10
LATITUDEGeo location latitude GEOLATDEC15(12) GEOLONLAT
LONGITUDEGeo location longitude GEOLONDEC15(12) GEOLONLAT
IATA_FLIGHTIATA Location for Airport IATA_LOCATION_AIRPORTCHAR3Assigned to domainFTPD_IATA_LOCATION
IATA_GROUNDIATA Location for Hotel IATA_LOCATION_HOTELCHAR3Assigned to domainFTPD_IATA_LOCATION
TRAIN_STATIONInternational Unique Train Station Number TRAIN_BFNRINT410INT4
RGIONTrip Country/Trip Country Group/Trip Region RGIONCHAR5Assigned to domainRGION
CITY_DISTRICTADRDistrict AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODEADRCity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
.INCLU--AP 0
OFFICE_FINDGrouping for Sales Office Determination OFFICE_FINDCHAR2Assigned to domainOFFICE_FIND
OS_CODEOther Travel Service: Code OTHER_SERVICE_CODECHAR1FTPD_OS_CODE
LOC_BEG_IATAStart Location of Trip Segment (IATA) REQUEST_LOC_BEG_IATACHAR3Assigned to domainFTPD_IATA_LOCATIONS_IATA_LOCATION
LOC_END_IATAEnd Location of Trip Segment (IATA) REQUEST_LOC_END_IATACHAR3Assigned to domainFTPD_IATA_LOCATIONS_IATA_LOCATION
OS_STATUSStatus of Other Service OS_STATUSCHAR1FTPD_OTHER_SERVICE_STATUS
OS_CONF_NUMBERConfirmation Code of Other Service OS_CONF_NUMBERNUMC16FTPD_OS_CONF_NR
PRICEPrice of Request REQUEST_PRICECURR10(2) FTPD_PRICE
CURRENCYCurrency of Request REQUEST_CURRENCYCUKY5Assigned to domainWAERS
COMMENT1Comment About Request REQUEST_COMMENTCHAR255FTPD_REQUEST_COMMENT
KZREATrip Type: Statutory KZREACHAR1Assigned to domainKZREA
BEREITrip Type: Enterprise-Specific BEREICHAR1Assigned to domainBEREI
KZTKTTrip Activity Type KZTKTCHAR1Assigned to domainKZTKT
KZPRIPrivate Stopover KZPRICHAR1XFELD
SLEEP_AT_HOMEOvernight Stay at Home PTRV_SLEEP_AT_HOMECHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table FTPT_REQUEST using ABAP code

The following ABAP code Example will allow you to do a basic selection on FTPT_REQUEST to SELECT all data from the table
DATA: WA_FTPT_REQUEST TYPE FTPT_REQUEST.

SELECT SINGLE *
FROM FTPT_REQUEST
INTO CORRESPONDING FIELDS OF WA_FTPT_REQUEST
WHERE...

How to access SAP table FTPT_REQUEST

Within an ECC or HANA version of SAP you can also view further information about FTPT_REQUEST and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!