SAP table FTPT_REQ_HEAD (Framework Data of Travel Request)

SAP table FTPT_REQ_HEAD has 5 primary key fields being MANDT,PERNR,REINR,REQUESTVRS,PLAN_REQUEST.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

FTPT_REQ_HEAD foreign key relationships

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