SAP ABAP Table FTPT_PLANHISTORY (General Plan Data)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP_ADDON (Package) Travel Planning Add-On

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FTPT_PLANHISTORY	Table Relationship Diagram
Short Description	General Plan Data

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	PTRV_HEAD
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	PLAN_VERSION	☑	PLAN_VERSION_NR	FTPD_PLAN_VERSION_NR	NUMC	2	0	Travel Plan Version Number (Sequential Number)
7	DATE_BEG	☐	PLAN_DATBEG	DATUM	DATS	8	0	Start Date of Travel Plan
8	TIME_BEG	☐	PLAN_ZEIBEG	TIME	TIMS	6	0	Start Time of Travel Plan
9	DATE_END	☐	PLAN_DATEND	DATUM	DATS	8	0	End date of travel plan
10	TIME_END	☐	PLAN_ZEIEND	TIME	TIMS	6	0	End time of travel plan
11	DESTINATION	☐	PLAN_ZIEL	RZIELORT	CHAR	59	0	Destination of travel plan
12	REASON	☐	RKUNDE	RKUNDE	CHAR	59	0	Reason for Trip (for example, customer/requisitioner)
13	ACTIVITY_TYPE	☐	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	TA20R
14	STATUS	☐	PLAN_STATUS	FTPD_PSTAT	CHAR	1	0	Travel Plan Status
15	CHANGED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
16	CHANGED_AT_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
17	CHANGED_AT_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_PLANHISTORY	ACTIVITY_TYPE	TA20R	ACTICITY	REF	1	CN
2	FTPT_PLANHISTORY	PERNR	PTRV_HEAD	MANDT	KEY	1	C

History

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