FTPT_FLIGHT SAP (Travel Request Item - Flight Service) Table details

Dictionary Type: Table
Description: Travel Request Item - Flight Service




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




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

FTPT_FLIGHT is a standard SAP Table which is used to store Travel Request Item - Flight Service data and is available within R/3 SAP systems depending on the version and release level.

The FTPT_FLIGHT table consists of various fields, each holding specific information or linking keys about Travel Request Item - Flight Service 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_FLIGHT 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
VARIANTPlan variant number (sequential number) VARIANT_NRNUMC2FTPD_VARIANT_NR
VARIANTVRSVersion of travel plan VARIANT_VERSIONNUMC2Assigned to domainFTPD_VARIANT_VERSION
ITEMTravel Request Item Number (Sequential Number) ITEMPOS_NRNUMC3FTPT_ITEMFTPD_ITEM_ID
SERVICETravel service item number of flight FLIGHT_SERVICE_NRNUMC3FTPD_FLIGHT_ID
AIRLINEAirline FLIGHT_AIRLINECHAR3TA21PFTPD_PROVIDER_CODE
FLIGHT_NRFlight Number FLIGHT_NRCHAR6FTPD_FLIGHT_NR
DATE_DEPFlight departure date FLIGHT_DATE_DEPDATS8FTPD_DATE
TIME_DEPFlight departure time FLIGHT_TIME_DEPTIMS6FTPD_TIME
LOC_DEPDeparture Location FLIGHT_SLOC_DEPCHAR3TA21LFTPD_IATA_LOCATION
TERM_DEPTerminal Code (Departure) FLIGHT_TERM_DEPCHAR2FTPD_TERMINAL
GATE_DEPFlight departure terminal FLIGHT_GATE_DEPCHAR6FTPD_FLIGHT_GATE
DATE_ARRFlight arrival date FLIGHT_DATE_ARRDATS8FTPD_DATE
TIME_ARRFlight arrival time FLIGHT_TIME_ARRTIMS6FTPD_TIME
LOC_ARRFlight Arrival Location FLIGHT_SLOC_ARRCHAR3TA21LFTPD_IATA_LOCATION
TERM_ARRTerminal code (arrival) FLIGHT_TERM_ARRCHAR2FTPD_TERMINAL
GATE_ARRFlight arrival terminal FLIGHT_GATE_ARRCHAR6FTPD_FLIGHT_GATE
RESTRICT_FARERestricted airfare FARE_RESTRICTCHAR1CHAR1_X
CABINFlight Cabin Class FLIGHT_CABINCHAR1FTPD_FLIGHT_CABIN
RBDFlight Booking Code (RBD) FLIGHT_RBDCHAR1FTPD_FLIGHT_RBD
MARRIEDMarried Segments MARRIED_SEGMENTINT13FTPD_MARRIED_SEG
STATUSFlight Status FLIGHT_STATUSCHAR2FTPD_SERVICE_STATUS
TEMPLATETemplate indicator VARIANT_TEMPLATECHAR1FTPD_TEMPLATE
PNR_NRLine Number of Flight in PNR (if PNR available) FLIGHT_LINENUMBERINT25FTPT_PNRFTPD_PNR_NR
ELEC_TKTElectronic ticketing for flight is possible FLIGHT_ELEC_TKTCHAR1CHAR1_X
PARTICIPATIONAccess type code: Airline FLIGHT_PARTICIPATIONCHAR5FTPD_PARTICIPATION
CHECKIN_TIMECheck-in time FLIGHT_CHECKINTIMS6FTPD_TIME
OP_AIRLINEAirline FLIGHT_AIRLINECHAR3TA21PFTPD_PROVIDER_CODE
PROFILETravel Profile PROF_IDCHAR8TA20PFTPD_PROF_IDPROFILE
PROFITEMTrip rule PROF_ITEMCHAR8TA20PIFTPD_PROF_ITEMPITEM
KZTKTTrip Activity Type PLAN_ACTIVITYCHAR1Assigned to domainFTPD_PLAN_ACTIVITY
SPECHIDClass rule SSPECIDCHAR8TA20PSFTPD_SSPEC_ID
PRIORITYPriority of trip rule PROFIL_PRIROITYCHAR1FTPD_PROF_PRIORITY
HIGHEST_PRIORITYPriority of trip rule PROFIL_PRIROITYCHAR1FTPD_PROF_PRIORITY
BEST_BUY_RCIndicator: Use 'Best Buy' Reason Codes BEST_BUY_REASON_CODECHAR1FTPD_BEST_BUY_REASON_CODE
REASON_CODEReason Code REASON_CODECHAR2Assigned to domainFTPD_REASON_CODE
REASON_TEXTReason Text REASON_TEXTCHAR132TEXT132
.INCLU--AP 0
CONNECTION_TAGConnection Indicator FTPD_CONNECTION_INDICATORCHAR1FTPD_CONNECTION_CODE

Key field Non-key field



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

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

SELECT SINGLE *
FROM FTPT_FLIGHT
INTO CORRESPONDING FIELDS OF WA_FTPT_FLIGHT
WHERE...

How to access SAP table FTPT_FLIGHT

Within an ECC or HANA version of SAP you can also view further information about FTPT_FLIGHT 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!