SAP table FTPT_REQUEST (Travel Plan Requests)

SAP table FTPT_REQUEST has 9 primary key fields being MANDT,PERNR,REINR,PLANNR,VARIANTE,VARIANTVRS,REQUESTVRS,PLAN_REQUEST,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 PERNR_D
REINR Trip Number NUMC 10 0 REINR
PLANNR Travel Plan Number (Sequential Number) NUMC 2 0 * PLAN_NR
VARIANTE Plan variant number (sequential number) NUMC 2 0 VARIANT_NR
VARIANTVRS Version of travel plan NUMC 2 0 FTPT_VARIANT VARIANT_VERSION
REQUESTVRS Version of travel request NUMC 2 0 FTPT_REQ_HEAD REQUEST_VERSION
PLAN_REQUEST Plan Request Indicator CHAR 1 0 PLAN_REQUEST
REQUEST Request number (sequential number NUMC 2 0 REQUEST_NR
ITINERARY_NUMBER Number of trip segment NUMC 2 0 ITINERARY_NUMBER
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
LOCATION_BEG Starting location of trip segment CHAR 59 0 REQUEST_LOC_BEG
COUNTRY_BEG Country/Region Key CHAR 3 0 T005 LAND1
LOCATION_END End location of trip segment CHAR 59 0 REQUEST_LOC_END
COUNTRY_END Country/Region Key CHAR 3 0 T005 LAND1
REQUEST_TYPE Travel Item Type CHAR 2 0 REQUEST_TYPE
DEP_ARR Arrival/Departure time CHAR 1 0 DEP_ARR
ITEM Travel Request Item Number (Sequential Number) NUMC 3 0 FTPT_ITEM ITEMPOS_NR
REASON Reason for Trip (for example, customer/requisitioner) CHAR 17 0 RKUND
ACTIVITY Trip Activity Type CHAR 1 0 TA20R PLAN_ACTIVITY
FIRST_TCODE Transaction Code CHAR 20 0 * SYTCODE
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
CITY City CHAR 40 0 AD_CITY1
POST_CODE City postal code CHAR 10 0 AD_PSTCD1
STREET Street CHAR 60 0 AD_STREET
HOUSE_NUM House Number CHAR 10 0 AD_HSNM1
LATITUDE Geo location latitude DEC 15 12 GEOLAT
LONGITUDE Geo location longitude DEC 15 12 GEOLON
IATA_FLIGHT IATA Location for Airport CHAR 3 0 * IATA_LOCATION_AIRPORT
IATA_GROUND IATA Location for Hotel CHAR 3 0 * IATA_LOCATION_HOTEL
TRAIN_STATION International Unique Train Station Number INT4 10 0 TRAIN_BFNR
RGION Trip Country/Trip Country Group/Trip Region CHAR 5 0 * RGION
CITY_DISTRICTADR District CHAR 40 0 AD_CITY2
CITY_CODEADR City code for city/street file CHAR 12 0 * AD_CITYNUM
OFFICE_FIND Grouping for Sales Office Determination CHAR 2 0 * OFFICE_FIND
OS_CODE Other Travel Service: Code CHAR 1 0 OTHER_SERVICE_CODE
LOC_BEG_IATA Start Location of Trip Segment (IATA) CHAR 3 0 REQUEST_LOC_BEG_IATA
LOC_END_IATA End Location of Trip Segment (IATA) CHAR 3 0 REQUEST_LOC_END_IATA
OS_STATUS Status of Other Service CHAR 1 0 OS_STATUS
OS_CONF_NUMBER Confirmation Code of Other Service NUMC 16 0 OS_CONF_NUMBER
PRICE Price of Request CURR 10 2 REQUEST_PRICE
CURRENCY Currency of Request CUKY 5 0 * REQUEST_CURRENCY
COMMENT1 Comment About Request CHAR 255 0 REQUEST_COMMENT
KZREA Trip Type: Statutory CHAR 1 0 * KZREA
BEREI Trip Type: Enterprise-Specific CHAR 1 0 * BEREI
KZTKT Trip Activity Type CHAR 1 0 * KZTKT
KZPRI Private Stopover CHAR 1 0 KZPRI
SLEEP_AT_HOME Overnight Stay at Home CHAR 1 0 PTRV_SLEEP_AT_HOME
ATTR_TRIP_BREAK Duration of Private Trip Break CHAR 1 0 PTRVPS_ATTR_TRIP_BREAK
G Priv. Break of More Than & Working Days
K Priv. Break up to & Working Days
L Priv. Break of More Than & Days
S Priv. Break up to & Days

FTPT_REQUEST foreign key relationships

Table Field Check Table Check Field
0 FTPT_REQUEST ACTIVITY TA20R Trip activity type - Travel Planning MANDT
0 FTPT_REQUEST ACTIVITY TA20R Trip activity type - Travel Planning ACTICITY
1 FTPT_REQUEST COUNTRY T005 Countries MANDT
1 FTPT_REQUEST COUNTRY T005 Countries LAND1
0 FTPT_REQUEST COUNTRY_BEG T005 Countries MANDT
0 FTPT_REQUEST COUNTRY_BEG T005 Countries LAND1
1 FTPT_REQUEST COUNTRY_END T005 Countries MANDT
1 FTPT_REQUEST COUNTRY_END T005 Countries LAND1
0 FTPT_REQUEST ITEM FTPT_ITEM Travel Service Request Item .INCLUDE
0 FTPT_REQUEST ITEM FTPT_ITEM Travel Service Request Item MANDT
0 FTPT_REQUEST ITEM FTPT_ITEM Travel Service Request Item PERNR
0 FTPT_REQUEST ITEM FTPT_ITEM Travel Service Request Item REINR
0 FTPT_REQUEST ITEM FTPT_ITEM Travel Service Request Item PLANNR
0 FTPT_REQUEST ITEM FTPT_ITEM Travel Service Request Item VARIANTVRS
1 FTPT_REQUEST REGION T005S Taxes: Region (Province) Key LAND1
0 FTPT_REQUEST REQUESTVRS FTPT_REQ_HEAD Framework Data of Travel Request PERNR
0 FTPT_REQUEST REQUESTVRS FTPT_REQ_HEAD Framework Data of Travel Request REINR
0 FTPT_REQUEST REQUESTVRS FTPT_REQ_HEAD Framework Data of Travel Request REQUESTVRS
1 FTPT_REQUEST VARIANTVRS FTPT_VARIANT Table of Travel Plan Variants .INCLUDE
1 FTPT_REQUEST VARIANTVRS FTPT_VARIANT Table of Travel Plan Variants MANDT
1 FTPT_REQUEST VARIANTVRS FTPT_VARIANT Table of Travel Plan Variants PERNR
1 FTPT_REQUEST VARIANTVRS FTPT_VARIANT Table of Travel Plan Variants REINR
1 FTPT_REQUEST VARIANTVRS FTPT_VARIANT Table of Travel Plan Variants PLANNR