SAP ABAP Table TA20NEGOF (Negotiated Flight Fares (Corporate Nego Fares))

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	TA20NEGOF	Table Relationship Diagram
Short Description	Negotiated Flight Fares (Corporate Nego Fares)

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	PROVIDER	☑	NEGO_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Provider of negotiated rate	TA21P
3	GEOORG_TYPE	☑	GEO_ORIGIN_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Geographical Origin Type
4	GEOORG	☑	GEO_ORIGIN	FTPD_GEO_ID	CHAR	3	0	Geographical Origin
5	GEODEST_TYPE	☑	GEO_DESTINATION_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Type of Geographical Destination
6	GEODEST	☑	GEO_DESTINATION	FTPD_GEO_ID	CHAR	3	0	Geographical Destination
7	DIRECTIONALITY	☑	DIRECTIONALITY	FTPD_DIRECTIONALITY	CHAR	1	0	Direction
8	FAREBASIS	☑	NEGO_FARE_BASIS	FTPD_FARE_BASIS	CHAR	8	0	Fare Basis
9	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
10	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
11	FARETYPE	☐	NEGO_FARE_TYPE	FTPD_NEGO_FARE_TYPE	CHAR	1	0	Type of Negotiated Airfare Rate
12	FARENATURE	☐	FARE_NATURE	FTPD_FARE_NATURE	CHAR	2	0	Rate Type (One-Way or Round Trip)
13	CORPID	☐	CORP_NEGO_ID	FTPD_CORP_ID	CHAR	8	0	Contract Number	TA20CORPID
14	PTC	☐	PASSENGER_TYPE_CODE	FTPD_PTC	CHAR	1	0	Flight Passenger Category
15	PUSE	☐	PUSE_FLAG	CHAR1_X	CHAR	1	0	Private usage permitted
16	CABIN	☐	FLIGHT_CABIN	FTPD_FLIGHT_CABIN	CHAR	1	0	Flight Cabin Class
17	CLASS	☐	FLIGHT_BOOKING_CODE	FTPD_BOOKING_CODE	CHAR	2	0	Booking Code
18	ROUTING	☐	ROUTING_NUMBER	FTPD_ROUTING_NUMBER	NUMC	4	0	Route	TA20ROUTE
19	BASE_PRICE	☐	NEGO_FARE	FTPD_PRICE	CURR	10	2	Price of negotiated rate
20	PRICE	☐	NEGO_FARE	FTPD_PRICE	CURR	10	2	Price of negotiated rate
21	CURRENCY	☐	NEGO_FARE_CURRENCY	WAERS	CUKY	5	0	Currency of negotiated rate	TCURC
22	MANDATORY_USE	☐	MANDATORY_FLAG	CHAR1_X	CHAR	1	0	Usage of Rate is Mandatory
23	FARE_INDEX	☐	FARE_INDEX	NUMC06	NUMC	6	0	Rate Index Tables

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA20NEGOF	CORPID	TA20CORPID	CORPID	KEY	1	CN
2	TA20NEGOF	CURRENCY	TCURC	WAERS	REF	1	CN
3	TA20NEGOF	PROVIDER	TA21P	PROVIDER	KEY	1	CN
4	TA20NEGOF	ROUTING	TA20ROUTE	ROUTING_NUMBER	KEY	1	CN

History

Last changed by/on	SAP	20030130
SAP Release Created in