SAP ABAP Table TA20NF (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 TA20NF   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 DEPLOC NEGO_FLI_ORG FTPD_IATA_LOCATION CHAR 3   0   Departure location of negotiated airfare rate TA21L
4 ARRLOC NEGO_FLI_DEST FTPD_IATA_LOCATION CHAR 3   0   Arrival Location of Negotiated Airfare Rate TA21L
5 FAREBASIS NEGO_FARE_BASIS FTPD_FARE_BASIS CHAR 8   0   Fare Basis  
6 ENDDA ENDDA DATUM DATS 8   0   End Date  
7 BEGDA BEGDA DATUM DATS 8   0   Start Date  
8 FARETYPE DISC_FARE_TYPE FTPD_DISC_FARE_TYPE CHAR 1   0   Type of negotiated airfare  
9 FARENATURE FARE_NATURE FTPD_FARE_NATURE CHAR 2   0   Rate Type (One-Way or Round Trip)  
10 CORPID CORP_NEGO_ID FTPD_CORP_ID CHAR 8   0   Contract Number  
11 PTC PASSENGER_TYPE_CODE FTPD_PTC CHAR 1   0   Flight Passenger Category  
12 PUSE PUSE_FLAG CHAR1_X CHAR 1   0   Private usage permitted  
13 CABIN FLIGHT_CABIN FTPD_FLIGHT_CABIN CHAR 1   0   Flight Cabin Class  
14 PRICE NEGO_FARE FTPD_PRICE CURR 10   2   Price of negotiated rate  
15 CURRENCY NEGO_FARE_CURRENCY WAERS CUKY 5   0   Currency of negotiated rate TCURC
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TA20NF ARRLOC TA21L LOCID KEY 1 CN
2 TA20NF CURRENCY TCURC WAERS REF 1 CN
3 TA20NF DEPLOC TA21L LOCID KEY 1 CN
4 TA20NF PROVIDER TA21P PROVIDER KEY 1 CN
History
Last changed by/on SAP  20010720 
SAP Release Created in