SAP ABAP Table FTPT_PNR_ADDRESS (PNR delivery / billing addresses)

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_ADDRESS	Table Relationship Diagram
Short Description	PNR delivery / billing addresses

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	FIRSTNAME	☐	AM_FIRSTNAME	FTPD_NAME	CHAR	40	0	First Name
10	SURNAME	☐	AM_SURNAME	FTPD_NAME	CHAR	40	0	Name
11	ADDRESS	☐	AM_ADDRESS	FTPD_ADDRESS	CHAR	60	0	Street and number
12	ZIPCODE	☐	AM_ZIPCODE	FTPD_ZIPCODE	CHAR	10	0	Postal Code
13	CITY_CODE	☐	AM_CITYCODE	PAD_ORT01	CHAR	40	0	City
14	COUNTRY	☐	AM_COUNTRY	LAND1	CHAR	3	0	Country	T005
15	.INCLU--AP	☐				0	0	Append Structure for Structure FTPT_PNR_ADDRESS
16	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_PNR_ADDRESS	COUNTRY	T005	LAND1	REF
2	FTPT_PNR_ADDRESS	PNR_NR	FTPT_PNR	VARIANTVRS	KEY	1	CN
3	FTPT_PNR_ADDRESS	VARIANTVRS	FTPT_VARIANT	VARIANT	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in