SAP ABAP Table FTPT_TRAIN (Travel Request Item - Train Service)

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_TRAIN	Table Relationship Diagram
Short Description	Travel Request Item - Train Service

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	VARIANT	☑	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	*
8	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	FTPT_ITEM
9	SERVICE	☑	TRAIN_SERVICE_NR	FTPD_TRAIN_ID	NUMC	3	0	Train number
10	PROVIDER	☐	TRAIN_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Train provider	TA21P
11	TRAIN_NR	☐	TRAIN_NR	FTPD_FLIGHT_NR	CHAR	6	0	Train number
12	COMPARTMENT_NR	☐	TRAIN_COMPARTMENT_NR	FTPD_TRAIN_COMPARTMENT_NR	NUMC	6	0	Compartment no.
13	DATE_DEP	☐	TRAIN_DATE_DEP	FTPD_DATE	DATS	8	0	Start date
14	TIME_DEP	☐	TRAIN_TIME_DEP	FTPD_TIME	TIMS	6	0	Start time
15	LOC_DEP	☐	TRAIN_LOC_DEP	FTPD_GEO_ID	CHAR	3	0	Departure loc.
16	GATE_DEP	☐	TRAIN_GATE_DEP	FTPD_FLIGHT_GATE	CHAR	6	0	Departure platform
17	DATE_ARR	☐	TRAIN_DATE_ARR	FTPD_DATE	DATS	8	0	Arrival date
18	TIME_ARR	☐	TRAIN_TIME_ARR	FTPD_TIME	TIMS	6	0	Arrival time
19	LOC_ARR	☐	TRAIN_LOC_ARR	FTPD_GEO_ID	CHAR	3	0	Arrival Location
20	GATE_ARR	☐	TRAIN_GATE_ARR	FTPD_FLIGHT_GATE	CHAR	6	0	Arrival platform
21	CLASS	☐	TRAIN_CLASS	FTPD_TRAIN_CLASS	CHAR	2	0	Train class
22	COMPART_CLASS	☐	TRAIN_COMPARTMENT_CLASS	FTPD_TRAIN_COMPARTMENT_CLASS	CHAR	1	0	Compart. class
23	STATUS	☐	TRAIN_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Status
24	TEMPLATE	☐	VARIANT_TEMPLATE	FTPD_TEMPLATE	CHAR	1	0	Template indicator
25	COACH_NR	☐	TRAIN_COACH_NR	CHAR4	CHAR	4	0	Coach number
26	SEAT_NR	☐	TRAIN_SEAT_NR	CHAR4	CHAR	4	0	Seat Number
27	SEAT_PRICE	☐	TRAIN_SEAT_PRICE	FTPD_PRICE	CURR	10	2	Price of Seat Reservation
28	SEAT_PRICE_CURR	☐	TRAIN_SEAT_PRICE_CURRENCY	WAERS	CUKY	5	0	Currency for Seat Reservation Price	*
29	RES_INFO	☐	TRAIN_RESERVATION_INFO	CHAR50	CHAR	50	0	Reservation Information
30	SUPPLEMENT	☐	TRAIN_SUPPLEMENT	FTPD_PRICE	CURR	10	2	Supplement for Train Connection
31	SUPPLEMENT_CURR	☐	TRAIN_SUPPLEMENT_CURR	WAERS	CUKY	5	0	Currency for Supplement (Train)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_TRAIN	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN
2	FTPT_TRAIN	PROVIDER	TA21P	PROVIDER	REF	1	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in