FTPT_REQUEST - Travel Plan Requests

Travel Plan Requests information is stored in SAP table FTPT_REQUEST.
It is part of development package PTRP in software component FI-TV-PL. This development package consists of objects that can be grouped under "Travel Planning".

Fields for table FTPT_REQUEST

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		FTPS_PLAN	0
MANDT	Client	X	MANDT	CLNT	6	*
PERNR	Personnel Number	X	PERNR_D	NUMC	16
REINR	Trip Number	X	REINR	NUMC	20
PLANNR	Travel Plan Number (Sequential Number)	X	PLAN_NR	NUMC	4	*
VARIANTE	Plan variant number (sequential number)	X	VARIANT_NR	NUMC	4
VARIANTVRS	Version of travel plan	X	VARIANT_VERSION	NUMC	4	FTPT_VARIANT
REQUESTVRS	Version of travel request	X	REQUEST_VERSION	NUMC	4	FTPT_REQ_HEAD
PLAN_REQUEST	Plan Request Indicator	X	PLAN_REQUEST	CHAR	2
REQUEST	Request number (sequential number	X	REQUEST_NR	NUMC	4
ITINERARY_NUMBER	Number of trip segment		ITINERARY_NUMBER	NUMC	4
DATE_BEG	Beginning Date of Trip Segment		REQUEST_DATEBEG	DATS	16
TIME_BEG	Start Time of Trip Segment		REQUEST_TIMEBEG	TIMS	12
DATE_END	End Date of Trip Segment		REQUEST_DATEEND	DATS	16
TIME_END	End Time of Trip Segment		REQUEST_TIMEEND	TIMS	12
LOCATION_BEG	Starting location of trip segment		REQUEST_LOC_BEG	CHAR	118
COUNTRY_BEG	Country/Region Key		LAND1	CHAR	6	T005
LOCATION_END	End location of trip segment		REQUEST_LOC_END	CHAR	118
COUNTRY_END	Country/Region Key		LAND1	CHAR	6	T005
REQUEST_TYPE	Travel Item Type		REQUEST_TYPE	CHAR	4
DEP_ARR	Arrival/Departure time		DEP_ARR	CHAR	2
ITEM	Travel Request Item Number (Sequential Number)		ITEMPOS_NR	NUMC	6	FTPT_ITEM
REASON	Reason for Trip (for example, customer/requisitioner)		RKUND	CHAR	34
ACTIVITY	Trip Activity Type		PLAN_ACTIVITY	CHAR	2	TA20R
.INCLU--AP				FTPT_REQUEST_APPEND	0
FIRST_TCODE	Transaction Code		SYTCODE	CHAR	40	*
.INCLU--AP				FTPT_REQUEST_APPEND_ADDRESS	0
.INCLUDE	DEST_ADDRESS			FTPS_ADDRESS	0
.INCLUDE				FTPS_WEB_ADDRESS	0
COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
CITY	City		AD_CITY1	CHAR	80
POST_CODE	City postal code		AD_PSTCD1	CHAR	20
STREET	Street		AD_STREET	CHAR	120
HOUSE_NUM	House Number		AD_HSNM1	CHAR	20
.INCLUDE				FTPS_WEB_GEOCODING	0
LATITUDE	Geo location latitude		GEOLAT	DEC	8
LONGITUDE	Geo location longitude		GEOLON	DEC	8
IATA_FLIGHT	IATA Location for Airport		IATA_LOCATION_AIRPORT	CHAR	6	*
IATA_GROUND	IATA Location for Hotel		IATA_LOCATION_HOTEL	CHAR	6	*
TRAIN_STATION	International Unique Train Station Number		TRAIN_BFNR	INT4	4
RGION	Trip Country/Trip Country Group/Trip Region		RGION	CHAR	10	*
CITY_DISTRICTADR	District		AD_CITY2	CHAR	80
CITY_CODEADR	City code for city/street file		AD_CITYNUM	CHAR	24	*
.INCLU--AP				FTPT_REQUEST_APPEND_ENH	0
.INCLUDE				FTPS_REQUEST_SERVICE_ADDITION	0
OFFICE_FIND	Grouping for Sales Office Determination		OFFICE_FIND	CHAR	4	*
OS_CODE	Other Travel Service: Code		OTHER_SERVICE_CODE	CHAR	2
LOC_BEG_IATA	Start Location of Trip Segment (IATA)		REQUEST_LOC_BEG_IATA	CHAR	6
LOC_END_IATA	End Location of Trip Segment (IATA)		REQUEST_LOC_END_IATA	CHAR	6
OS_STATUS	Status of Other Service		OS_STATUS	CHAR	2
OS_CONF_NUMBER	Confirmation Code of Other Service		OS_CONF_NUMBER	NUMC	32
PRICE	Price of Request		REQUEST_PRICE	CURR	6
CURRENCY	Currency of Request		REQUEST_CURRENCY	CUKY	10	*
COMMENT1	Comment About Request		REQUEST_COMMENT	CHAR	510
.INCLUDE				FTPS_REQUEST_EXPENSES_ADDITION	0
KZREA	Trip Type: Statutory		KZREA	CHAR	2	*
BEREI	Trip Type: Enterprise-Specific		BEREI	CHAR	2	*
KZTKT	Trip Activity Type		KZTKT	CHAR	2	*
KZPRI	Private Stopover		KZPRI	CHAR	2
SLEEP_AT_HOME	Overnight Stay at Home		PTRV_SLEEP_AT_HOME	CHAR	2
ATTR_TRIP_BREAK	Duration of Private Trip Break		PTRVPS_ATTR_TRIP_BREAK	CHAR	2