SAP ABAP Table FTPT_REQUEST (Travel Plan Requests)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP (Package) Travel Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FTPT_REQUEST	Table Relationship Diagram
Short Description	Travel Plan Requests

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Key to travel plan table
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
5	PLANNR	☑	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)	*
6	VARIANTE	☑	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
7	VARIANTVRS	☑	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan	FTPT_VARIANT
8	REQUESTVRS	☑	REQUEST_VERSION	FTPD_REQUEST_VERSION	NUMC	2	0	Version of travel request	FTPT_REQ_HEAD
9	PLAN_REQUEST	☑	PLAN_REQUEST	FTPD_PLAN_REQUEST	CHAR	1	0	Plan Request Indicator
10	REQUEST	☑	REQUEST_NR	FTPD_REQUEST_NR	NUMC	2	0	Request number (sequential number
11	ITINERARY_NUMBER	☐	ITINERARY_NUMBER	PTRVNUMC2	NUMC	2	0	Number of trip segment
12	DATE_BEG	☐	REQUEST_DATEBEG	DATUM	DATS	8	0	Beginning Date of Trip Segment
13	TIME_BEG	☐	REQUEST_TIMEBEG	TIME	TIMS	6	0	Start Time of Trip Segment
14	DATE_END	☐	REQUEST_DATEEND	DATUM	DATS	8	0	End Date of Trip Segment
15	TIME_END	☐	REQUEST_TIMEEND	TIME	TIMS	6	0	End Time of Trip Segment
16	LOCATION_BEG	☐	REQUEST_LOC_BEG	RZIELORT	CHAR	59	0	Starting location of trip segment
17	COUNTRY_BEG	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
18	LOCATION_END	☐	REQUEST_LOC_END	RZIELORT	CHAR	59	0	End location of trip segment
19	COUNTRY_END	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
20	REQUEST_TYPE	☐	REQUEST_TYPE	FTPD_REQUEST_TYPE	CHAR	2	0	Travel Item Type
21	DEP_ARR	☐	DEP_ARR	FTPD_DEP_ARR	CHAR	1	0	Arrival/Departure time
22	ITEM	☐	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	FTPT_ITEM
23	REASON	☐	RKUND	RKUND	CHAR	17	0	Reason for trip (e.g. customer/requisitioner)
24	ACTIVITY	☐	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	TA20R
25	.INCLU--AP	☐				0	0	Enhancement for FTPT_REQUEST in Extension System
26	FIRST_TCODE	☐	SYTCODE	TCODE	CHAR	20	0	Transaction Code	*
27	.INCLU--AP	☐				0	0	Append Structure for FTPT_REQUEST in Extension System
28	.INCLUDE	☐				0	0	Address and Geocoordinates
29	.INCLUDE	☐				0	0	Travel Web Interface: Addresses
30	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
31	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
32	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
33	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
34	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
35	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
36	.INCLUDE	☐				0	0	Travel Web Interface: Geocoding
37	LATITUDE	☐	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude
38	LONGITUDE	☐	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
39	IATA_FLIGHT	☐	IATA_LOCATION_AIRPORT	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Airport	*
40	IATA_GROUND	☐	IATA_LOCATION_HOTEL	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Hotel	*
41	TRAIN_STATION	☐	TRAIN_BFNR	INT4	INT4	10	0	International Unique Train Station Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_REQUEST	ACTIVITY	TA20R	ACTICITY	REF	1	CN
2	FTPT_REQUEST	COUNTRY	T005	LAND1	KEY	1	CN
3	FTPT_REQUEST	COUNTRY_BEG	T005	LAND1	REF	1	CN
4	FTPT_REQUEST	COUNTRY_END	T005	LAND1	REF	1	CN
5	FTPT_REQUEST	ITEM	FTPT_ITEM	VARIANTVRS	REF	1	C
6	FTPT_REQUEST	REGION	T005S	BLAND	KEY	1	CN
7	FTPT_REQUEST	REQUESTVRS	FTPT_REQ_HEAD	REQUESTVRS	KEY	1	C
8	FTPT_REQUEST	VARIANTVRS	FTPT_VARIANT	VARIANT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in