SAP ABAP Table TA20NF1 (Negotiated flight fares (language-dependent))

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	TA20NF1	Table Relationship Diagram
Short Description	Negotiated flight fares (language-dependent)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	*
3	PROVIDER	☑	NEGO_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Provider of negotiated rate	TA21P
4	DEPLOC	☑	NEGO_FLI_ORG	FTPD_IATA_LOCATION	CHAR	3	0	Departure location of negotiated airfare rate	*
5	ARRLOC	☑	NEGO_FLI_DEST	FTPD_IATA_LOCATION	CHAR	3	0	Arrival Location of Negotiated Airfare Rate	*
6	FAREBASIS	☑	NEGO_FARE_BASIS	FTPD_FARE_BASIS	CHAR	8	0	Fare Basis
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date	TA20NF
8	SHORTTXT	☐	NEGO_SHORT_TEXT	TEXT20	CHAR	20	0	Description of Rate
9	LONGTXT	☐	NEGO_LONG_TEXT	TEXT132	CHAR	132	0	Rate Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA20NF1	ENDDA	TA20NF	ENDDA	TEXT	1	N
2	TA20NF1	PROVIDER	TA21P	PROVIDER		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in