SAP ABAP Table FTPT_ITEM (Travel Service Request Item)

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

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	FTPT_VARIANT
8	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)
9	USERG	☐	EMPLOYEE_GROUP_TP	FTPD_EMPLOYEE_GROUP	CHAR	2	0	User Grouping for Travel Planning	TA20B
10	CATEGORY	☐	ITEMPOS_USER_CAT	FTPD_USER_CAT	CHAR	1	0	Enterprise-Specific Travel Service Category	TA20C
11	REAL_CAT	☐	CATEGORY	FTPD_ITEM_CATEGORY	CHAR	1	0	Travel service category
12	DATE_BEG	☐	ITEMPOS_DATE_BEG	FTPD_DATE	DATS	8	0	Start Date of Request Item
13	TIME_BEG	☐	ITEMPOS_TIME_BEG	FTPD_TIME	TIMS	6	0	Start Time for Request Item
14	LOC_BEG	☐	ITEMPOS_LOC_BEG	FTPD_IATA_LOCATION	CHAR	3	0	Starting Location of Request Item	TA21L
15	DATE_END	☐	ITEMPOS_DATE_END	FTPD_DATE	DATS	8	0	End date of request item
16	TIME_END	☐	ITEMPOS_TIME_END	FTPD_TIME	TIMS	6	0	End time for request item
17	LOC_END	☐	ITEMPOS_LOC_END	FTPD_IATA_LOCATION	CHAR	3	0	End Location of Request Item	TA21L
18	CLASS	☐	ITEMPOS_CLASS	FTPD_ITEM_CLASS	CHAR	2	0	Request item class
19	PRICE_AVAI	☐	ITEMPOS_PRICE_AVAI	FTPD_PRICE	CURR	10	2	Price at availability query of request item
20	PRICE_APPR	☐	ITEMPOS_PRICE_APPR	FTPD_PRICE	CURR	10	2	Price at approval of request item
21	PRICE	☐	ITEMPOS_PRICE	FTPD_PRICE	CURR	10	2	Price of request item
22	CURRENCY	☐	ITEMPOS_CURRENCY	WAERS	CUKY	5	0	Currency of request item	TCURC
23	REF_ITEM	☐	ITEMPOS_REF_NR	FTPD_ITEM_ID	NUMC	3	0	Reference to another request (return flight)	*
24	STATUS	☐	ITEMPOS_STATUS	FTPD_ITEM_STATUS	CHAR	1	0	Status of Request Item
25	TEMPLATE	☐	VARIANT_TEMPLATE	FTPD_TEMPLATE	CHAR	1	0	Template indicator
26	BELNR	☐	NRBEL	NRBEL	CHAR	3	0	Document Number
27	FIRMA	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
28	DEP_ARR	☐	DEP_ARR	FTPD_DEP_ARR	CHAR	1	0	Arrival/Departure time
29	.INCLU--AP	☐				0	0	Append for FTPT_ITEM
30	RES_SYSTEM	☐	RESERVATION_SYSTEM	FTPD_PROVIDER_CODE	CHAR	3	0	Reservation System	TA21P

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_ITEM	CATEGORY	TA20C	USER_CATEGORY	REF	1	CN
2	FTPT_ITEM	CURRENCY	TCURC	WAERS	REF	1	CN
3	FTPT_ITEM	LOC_BEG	TA21L	LOCID	REF	1	CN
4	FTPT_ITEM	LOC_END	TA21L	LOCID	REF	1	CN
5	FTPT_ITEM	RES_SYSTEM	TA21P	PROVIDER	REF	1	CN
6	FTPT_ITEM	USERG	TA20B	USERG	REF	1	CN
7	FTPT_ITEM	VARIANTVRS	FTPT_VARIANT	VARIANT	KEY	1	CN

History

Last changed by/on	SAP	20060208
SAP Release Created in