SAP ABAP Table FTPS_WEB_PLAN_OUT (Trip Planning Data (Portal RFC Interface))

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP_WEB_INTERFACE (Package) RFC Modules for Web User Interface: Travel Planning

Basic Data

Table Category	INTTAB	Structure
Structure	FTPS_WEB_PLAN_OUT	Table Relationship Diagram
Short Description	Trip Planning Data (Portal RFC Interface)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	(RFC Portal Interface)
2	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	REINR	☐	REINR	REINR	NUMC	10	0	Trip Number
4	PLANNR	☐	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)	*
5	VARIANT	☐	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
6	VARIANTVRS	☐	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan	*
7	.INCLUDE	☐				0	0	Planning Data Variant (Portal RFC-Interface)
8	REC_LOCATOR	☐	PNR_RECORD_LOCATOR	FTPD_PNR_RECORD_LOCATOR	CHAR	20	0	Passenger Name Record Locator
9	REC_LOC_RAIL	☐	PNR_RECORD_LOCATOR	FTPD_PNR_RECORD_LOCATOR	CHAR	20	0	Passenger Name Record Locator
10	.INCLUDE	☐				0	0	Plan Planning Data (Portal RFC Interface)
11	DATE_BEG	☐	PLAN_DATBEG	DATUM	DATS	8	0	Start Date of Travel Plan
12	TIME_BEG	☐	PLAN_ZEIBEG	TIME	TIMS	6	0	Start Time of Travel Plan
13	DATE_END	☐	PLAN_DATEND	DATUM	DATS	8	0	End date of travel plan
14	TIME_END	☐	PLAN_ZEIEND	TIME	TIMS	6	0	End time of travel plan
15	DESTINATION	☐	PLAN_ZIEL	RZIELORT	CHAR	59	0	Destination of travel plan
16	REASON	☐	RKUNDE	RKUNDE	CHAR	59	0	Reason for Trip (for example, customer/requisitioner)
17	ACTIVITY_TYPE	☐	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	*
18	ACTIVITY_NAME	☐	PLAN_ACTIVITY_NAME	TEXT30	CHAR	30	0	Description of trip activity type - Travel Planning
19	AGENCYSTATUS	☐	AGENCY_STATUS	PTPD_AGENCY_STATUS	CHAR	1	0	Travel Agency Status
20	AGENCYSTATUS_NAME	☐	AGENCY_STATUS_NAME	TEXT30	CHAR	30	0	Name of agency status for travel plan
21	.INCLUDE	☐				0	0	Req_head Planning Data (Portal RFC-Interface)
22	COUNTRY_END	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
23	CURRENCY	☐	TRVWAERS	WAERS	CUKY	5	0	Currency Key	*
24	COUNTRY_END_NAME	☐	LANDX	TEXT15	CHAR	15	0	Country Name
25	.INCLUDE	☐				0	0	Ticket Information (Portal RFC Interface)
26	LAST_DATE	☐	TST_LAST_DATE	FTPD_DATE	DATS	8	0	Last Ticketing Date
27	TOTAL_FARE_PAID	☐	TST_TOTAL_FARE	FTPD_PRICE	CURR	10	2	Total price of flight ticket
28	TOTAL_FARE_CURR	☐	TST_TOTAL_FARE_CURR	WAERS	CUKY	5	0	Currency	*
29	TICKET_TEXT	☐	FTPD_WEB_TICKET_TEXT	TEXT255	CHAR	255	0	Long Text
30	TICKET_ISSUED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
31	TOTAL_FARE_TYPE	☐	FTPD_WEB_LONG_NAME	TEXT100	CHAR	100	0	Long Text
32	TOTAL_FARE_PAID_LOC	☐	TST_TOTAL_FARE	FTPD_PRICE	CURR	10	2	Total price of flight ticket
33	FLIGHT_PRICE_TEXT	☐	FTPD_WEB_LONG_NAME	TEXT100	CHAR	100	0	Long Text
34	FLIGHT_FARE_TEXT	☐	FTPD_WEB_LONG_NAME	TEXT100	CHAR	100	0	Long Text
35	FLIGHT_TICKET_TEXT	☐	FTPD_WEB_LONG_NAME	TEXT100	CHAR	100	0	Long Text
36	FLIGHT_LCC_BOOKING_CODE_TEXT	☐			CHAR	50	0
37	TOTAL_PRICE_LOC	☐	FTPD_WEB_RATE	FTPD_PRICE	CURR	10	2	Rate in Local Currency
38	LOCAL_CURRENCY	☐	FTPD_WEB_CURR	WAERS	CUKY	5	0	Item Local Currency	*
39	TOTAL_PRICE_HOTEL_LOC	☐	FTPD_WEB_RATE	FTPD_PRICE	CURR	10	2	Rate in Local Currency
40	TOTAL_PRICE_CAR_LOC	☐	FTPD_WEB_RATE	FTPD_PRICE	CURR	10	2	Rate in Local Currency
41	TOTAL_PRICE_TRAIN_LOC	☐	FTPD_WEB_RATE	FTPD_PRICE	CURR	10	2	Rate in Local Currency
42	TOTAL_PRICE_OS_LOC	☐	FTPD_WEB_RATE	FTPD_PRICE	CURR	10	2	Rate in Local Currency
43	DISTANCE_UNIT	☐	PTRV_DISTKZ	PTRV_DISTKZ	CHAR	1	0	Unit of Distance
44	ETIX_REQUESTED	☐	FLIGHT_ELEC_TKT	CHAR1_X	CHAR	1	0	Electronic ticketing for flight is possible
45	PAF	☐	PAF	FTPD_FLIGHT_CORP_PROGRAM_ID	CHAR	4	0	Airline Program for Corporate Customers	*
46	.INCLUDE	☐				0	0	Address and Geocoordinates
47	.INCLUDE	☐				0	0	Travel Web Interface: Addresses
48	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
49	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
50	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
51	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
52	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
53	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
54	.INCLUDE	☐				0	0	Travel Web Interface: Geocoding
55	LATITUDE	☐	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude
56	LONGITUDE	☐	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
57	IATA_FLIGHT	☐	IATA_LOCATION_AIRPORT	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Airport	*
58	IATA_GROUND	☐	IATA_LOCATION_HOTEL	FTPD_IATA_LOCATION	CHAR	3	0	IATA Location for Hotel	*
59	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	FTPS_WEB_PLAN_OUT	COUNTRY	T005	LAND1	KEY	1	CN
2	FTPS_WEB_PLAN_OUT	REGION	T005S	BLAND	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	200