SAP ABAP Table FTPT_PNR_PHONE (PNR telephone references)

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_PNR_PHONE	Table Relationship Diagram
Short Description	PNR telephone references

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	PNR_NR	☑	PNR_NR	FTPD_PNR_NR	INT2	5	0	Line number in PNR	FTPT_PNR
9	CITYCODE	☐	AP_CITYCODE	CHAR20	CHAR	20	0	City code (for telephone number)
10	AREACODE	☐	AP_AREACODE	CHAR20	CHAR	20	0	Area code of telephone number
11	PHONE_NUMBER	☐	AP_PHONE_NUMBER	CHAR40	CHAR	40	0	Telephone Number
12	EXTENSION	☐	AP_EXTENSION	CHAR20	CHAR	20	0	Telephone extension (optional)
13	TYPE	☐	AP_TYPE	FTPD_AP_PHONE_TYPE	CHAR	2	0	Telephone number type (business/private)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_PNR_PHONE	PNR_NR	FTPT_PNR	VARIANTVRS	KEY	1	CN
2	FTPT_PNR_PHONE	VARIANTVRS	FTPT_VARIANT	VARIANT	KEY	1	CN

History

Last changed by/on	SAP	20010720
SAP Release Created in