SAP ABAP Table FTPT_REQ_ADVANCE (Travel Request Advance)

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_REQ_ADVANCE	Table Relationship Diagram
Short Description	Travel Request Advance

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
4	REQUESTVRS	☑	REQUEST_VERSION	FTPD_REQUEST_VERSION	NUMC	2	0	Version of travel request	FTPT_REQ_HEAD
5	PLAN_REQUEST	☑	PLAN_REQUEST	FTPD_PLAN_REQUEST	CHAR	1	0	Plan Request Indicator
6	ADVANCE	☑	ADVANCE_NUMBER	FTPD_ACCOUNT_NUMBER	NUMC	2	0	Sequential number of advance in travel request
7	.INCLUDE	☐				0	0	Trip Advance
8	VORSC	☐	GESBA	GESBE	CURR	10	2	Amount of Advance
9	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	KURSV	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
11	FFACT	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
12	TFACT	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
13	VORHW	☐	GEBAH	GESBE	CURR	10	2	Advance Amount in Settlement Currency
14	KASSA	☐	KASSA	KASSA	CHAR	1	0	Cash Payment Indicator
15	DATVS	☐	DATVS	REDAT	DATS	8	0	Date of Advance Payment
16	PAYCURR	☐	PTRV_PAYCURR	WAERS	CUKY	5	0	Accounting Currency of Expense Receipt or Advance	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_REQ_ADVANCE	REQUESTVRS	FTPT_REQ_HEAD	REQUESTVRS	KEY	1	CN
2	FTPT_REQ_ADVANCE	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20040210
SAP Release Created in