SAP ABAP Table V_TA20NEGOF (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TA20NEGOF	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	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	SHORTTXT	☐	NEGO_SHORT_TEXT	TEXT20	CHAR	20	0	Description of Rate
23	LONGTXT	☐	NEGO_LONG_TEXT	TEXT132	CHAR	132	0	Rate Description
24	NAME	☐	PROVIDER_NAME	TEXT30	CHAR	30	0	Provider Name
25	KTEXT	☐	KTEXT_CURT	TEXT15	CHAR	15	0	Short text
26	MANDATORY_USE	☐	MANDATORY_FLAG	CHAR1_X	CHAR	1	0	Usage of Rate is Mandatory

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in