SAP FTPT_PLAN General Plan Data Table data and field list

FTPT_PLAN is a standard SAP Table which is used to store General Plan Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FTPT_PLAN table consists of various fields, each holding specific information or linking keys about General Plan Data 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. .

FTPT_PLAN table Technical Details:

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_PLAN table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FTPT_PLAN table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PERNRPersonnel Number PERNR_DNUMC8PTRV_HEADPERNRPER
REINRTrip Number REINRNUMC10REINR
PLANNRTravel Plan Number (Sequential Number) PLAN_NRNUMC2FTPD_PLAN_NR
DATE_BEGStart Date of Travel Plan PLAN_DATBEGDATS8DATUM
TIME_BEGStart Time of Travel Plan PLAN_ZEIBEGTIMS6TIME
DATE_ENDEnd date of travel plan PLAN_DATENDDATS8DATUM
TIME_ENDEnd time of travel plan PLAN_ZEIENDTIMS6TIME
DESTINATIONDestination of travel plan PLAN_ZIELCHAR59RZIELORT
REASONReason for Trip (for example, customer/requisitioner) RKUNDECHAR59RKUNDE
ACTIVITY_TYPETrip Activity Type PLAN_ACTIVITYCHAR1TA20RFTPD_PLAN_ACTIVITY
STATUSTravel Plan Status PLAN_STATUSCHAR1FTPD_PSTAT
CHANGED_BYUser Name SYUNAMECHAR12SYCHAR12
CHANGED_AT_DATESystem Date SYDATUMDATS8SYDATS
CHANGED_AT_TIMESystem Time SYUZEITTIMS6SYTIME
.INCLU--AP 0
POLICY_VIOLATIONViolation of Travel Policy in Travel Plan PLAN_POLICY_VIOLATIONCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM FTPT_PLAN
INTO CORRESPONDING FIELDS OF WA_FTPT_PLAN
WHERE...

How to access SAP table FTPT_PLAN

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

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

Related SAP tables and the relationships to FTPT_PLAN

    PA0001 - Employee Organizational Assignment
        PTRV_HEAD - General Trip Data
    FTPT_CAR - Travel Request Item - Car Rental Service
    FTPT_HOTEL - Travel Request Item - Hotel Service
    FTPT_TRAIN - Travel Request Item - Train Service
    FTPT_OTHER - Travel Reservation Request Item - Other Services
    PTRV_PERIO - Period Data
        PTRV_SCOM - Trip Statistics: Request/Plan/Expense Costs
        PTRV_SHDR - Trip Totals
        PTRV_SREC - Trip Receipts
            PTRV_SADD - Additional Trip Receipt Data
            PTRV_RECDETAIL - Participant(s) in Entertainment Receipts
    FTPT_PLAN - General Plan Data
            PTRV_VATDETAIL - Supplier Data for VAT Refund in Travel Management
        PTRV_SCOS - Cost Assignment
    FTPT_VARIANT - Table of Travel Plan Variants
        FTPT_ITEM - Travel Service Request Item
        V_FTPT_FL_TSTK - Airline Ticket Data
            V_FTPT_FARECMP - Fare Bases
                V_FTPT_FL_FCMP - Assignment of Flights to Fare Basis
                    V_FTPT_FLIGHT - Flight Segments
    FTPT_FLIGHT - Travel Request Item - Flight Service