FTPT_ITEM SAP (Travel Service Request Item) Table details

Dictionary Type: Table
Description: Travel Service Request Item




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




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

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

The FTPT_ITEM table consists of various fields, each holding specific information or linking keys about Travel Service Request Item 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_ITEM 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_VERSIONNUMC2FTPT_VARIANTFTPD_VARIANT_VERSION
ITEMTravel Request Item Number (Sequential Number) ITEMPOS_NRNUMC3FTPD_ITEM_ID
USERGUser Grouping for Travel Planning EMPLOYEE_GROUP_TPCHAR2TA20BFTPD_EMPLOYEE_GROUP
CATEGORYEnterprise-Specific Travel Service Category ITEMPOS_USER_CATCHAR1TA20CFTPD_USER_CAT
REAL_CATTravel service category CATEGORYCHAR1FTPD_ITEM_CATEGORY
DATE_BEGStart Date of Request Item ITEMPOS_DATE_BEGDATS8FTPD_DATE
TIME_BEGStart Time for Request Item ITEMPOS_TIME_BEGTIMS6FTPD_TIME
LOC_BEGStarting Location of Request Item ITEMPOS_LOC_BEGCHAR3TA21LFTPD_IATA_LOCATION
DATE_ENDEnd date of request item ITEMPOS_DATE_ENDDATS8FTPD_DATE
TIME_ENDEnd time for request item ITEMPOS_TIME_ENDTIMS6FTPD_TIME
LOC_ENDEnd Location of Request Item ITEMPOS_LOC_ENDCHAR3TA21LFTPD_IATA_LOCATION
CLASSRequest item class ITEMPOS_CLASSCHAR2FTPD_ITEM_CLASS
PRICE_AVAIPrice at availability query of request item ITEMPOS_PRICE_AVAICURR10(2) FTPD_PRICE
PRICE_APPRPrice at approval of request item ITEMPOS_PRICE_APPRCURR10(2) FTPD_PRICE
PRICEPrice of request item ITEMPOS_PRICECURR10(2) FTPD_PRICE
CURRENCYCurrency of request item ITEMPOS_CURRENCYCUKY5TCURCWAERS
REF_ITEMReference to another request (return flight) ITEMPOS_REF_NRNUMC3Assigned to domainFTPD_ITEM_ID
STATUSStatus of Request Item ITEMPOS_STATUSCHAR1FTPD_ITEM_STATUS
TEMPLATETemplate indicator VARIANT_TEMPLATECHAR1FTPD_TEMPLATE
BELNRDocument Number NRBELCHAR3NRBEL
FIRMAPaid by Company BEZFACHAR1XFELDTRV_PAID_COMPANY
DEP_ARRArrival/Departure time DEP_ARRCHAR1FTPD_DEP_ARR
.INCLU--AP 0
RES_SYSTEMReservation System RESERVATION_SYSTEMCHAR3TA21PFTPD_PROVIDER_CODE
PERSONSNumber of Persons on Request Item ITEMPOS_NR_PERSNUMC2NUMC2

Key field Non-key field



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

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

SELECT SINGLE *
FROM FTPT_ITEM
INTO CORRESPONDING FIELDS OF WA_FTPT_ITEM
WHERE...

How to access SAP table FTPT_ITEM

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