SAP Table FTPT_REQ_HEAD

Framework Data of Travel Request

FTPT_REQ_HEAD (Framework Data of Travel Request) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FTPT_REQ_HEAD to other SAP tables.

FTPT_REQ_HEAD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PERNR Personnel Number PERNR_D PTRV_HEAD NUMC 8 0
REINR Trip Number REINR NUMC 10 0
REQUESTVRS Version of travel request REQUEST_VERSION NUMC 2 0
PLAN_REQUEST Plan Request Indicator PLAN_REQUEST CHAR 1 0
NULL Settlement
P Plan
R Request
LOCATION_END Trip Destination REQUEST_END CHAR 59 0
COUNTRY_END Country Key LAND1 T005 CHAR 3 0
REQUEST_REASON Reason for Trip REQUEST_REASON CHAR 59 0
DATE_BEG Beginning Date of Trip Segment REQUEST_DATEBEG DATS 8 0
TIME_BEG Start Time of Trip Segment REQUEST_TIMEBEG TIMS 6 0
DATE_END End Date of Trip Segment REQUEST_DATEEND DATS 8 0
TIME_END End Time of Trip Segment REQUEST_TIMEEND TIMS 6 0
ACTIVITY_TYPE Trip Activity Type PLAN_ACTIVITY TA20R CHAR 1 0
ESTIMATED_COST Estimated Total Cost of Trip PTRV_ESTIMATED_COST CURR 13 2
CURRENCY Currency Key TRVWAERS TCURC CUKY 5 0
STATUS Travel Plan Status PLAN_STATUS CHAR 1 0
0 Open
1 For Approval
2 Approved
3 Rejected
6 Variant Activated, Not Booked (currently not used)
7 Variant Activated, Partially Booked (currently not used)
8 Variant Activated, Fully Booked (currently not used)
9 Canceled
DATES Changed On AEDAT DATS 8 0
TIMES Time of Last Change AEUHR TIMS 6 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
REPID Change Report AEREP CHAR 40 0
DEPAR Departure from Residence or Place of Work PTRV_DEPAR CHAR 1 0
CREATEDBY User Who Created the Object ANGNAM CHAR 12 0
APPROVEDBY Agent Who Approved the Object GENNAM CHAR 12 0
DELIVERY_DATE Delivery Date REQ_DELIVERY_DATE DATS 8 0
DELIVERY_LOC Delivery Location REQ_DELIVERY_LOC CHAR 12 0
OFFICE Office
HOME Home
OTHER Other
DELIVERY_AREA Delivery Area REQ_DELIVERY_AREA CHAR 64 0
DELIVERY_EMPL Recipient of Delivery REQ_DELIVERY_EMPLOYEE NUMC 8 0
ARRIVAL_WORK Arrival at Accommodations/New Place of Work PTRV_ARRIVAL_WORK CHAR 1 0
NULL Arrival at Workplace
X Arrival at Home
RETURN_WORK Arrival at Home/Workplace PTRV_RETURN_WORK CHAR 1 0
NULL Arrival at Workplace
X Arrival at Home
T_ACTYPE Trip Activity Type KZTKT CHAR 1 0
PERM_TRIP_APPR Standing Approval of Business Trips PTRV_PERM_TRIP_APPROVAL CHAR 1 0
X Yes
NULL No
TT_STATU Trip Type: Statutory KZREA CHAR 1 0
TT_COMSP Trip Type: Enterprise-Specific BEREI CHAR 1 0
GWE Request for Full Trip Segment Reimbursement PTRV_ANTRAG_GWE CHAR 1 0
EDI Significant Official Interest PTRV_ERH_DIENST_INT CHAR 1 0
CARRY_OTH Number of Employees Carpooling with Me (as the driver) PTRV_NO_CARRY_OTHERS NUMC 1 0
CARRIED_BY_OTH Employee is carpooling as a passenger with another employee PTRV_CARRIED_BY_OTHER CHAR 1 0
X Yes
NULL No
DATECOW Date of Commencement of Work PTRV_PS_DATV1_DIENST DATS 8 0
TIMECOW Time at Which Work Commences PTRV_PS_UHRV1_DIENST TIMS 6 0
DATEEOW Date on Which Work Ends PTRV_PS_DATB1_DIENST DATS 8 0
TIMEEOW Time at Which Work Ends PTRV_PS_UHRB1_DIENST TIMS 6 0

FTPT_REQ_HEAD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FTPT_REQ_HEAD ACTIVITY_TYPE FTPT_REQ_HEAD MANDT TA20R Trip activity type - Travel Planning MANDT
FTPT_REQ_HEAD ACTIVITY_TYPE FTPT_REQ_HEAD ACTIVITY_TYPE TA20R Trip activity type - Travel Planning ACTICITY
FTPT_REQ_HEAD COUNTRY_END FTPT_REQ_HEAD MANDT T005 Countries MANDT
FTPT_REQ_HEAD COUNTRY_END FTPT_REQ_HEAD COUNTRY_END T005 Countries LAND1
FTPT_REQ_HEAD CURRENCY FTPT_REQ_HEAD MANDT TCURC Currency Codes MANDT
FTPT_REQ_HEAD CURRENCY FTPT_REQ_HEAD CURRENCY TCURC Currency Codes WAERS
FTPT_REQ_HEAD PERNR FTPT_REQ_HEAD MANDT PTRV_HEAD General Trip Data .INCLUDE
FTPT_REQ_HEAD PERNR FTPT_REQ_HEAD PERNR PTRV_HEAD General Trip Data MANDT
FTPT_REQ_HEAD PERNR FTPT_REQ_HEAD REINR PTRV_HEAD General Trip Data PERNR
FTPT_REQ_HEAD PERNR * PTRV_HEAD General Trip Data REINR