SAP ABAP View V_TA20NEGOF_2 (Negotiated Airfares)
Hierarchy
☛
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷ FI-TV-PL (Application Component) Travel Planning
⤷ PTRP_ADDON (Package) Travel Planning Add-On
⤷ FI-TV-PL (Application Component) Travel Planning
⤷ PTRP_ADDON (Package) Travel Planning Add-On
Basic Data
View Type | C | Maintenance View |
Maintenance View | V_TA20NEGOF_2 | |
Short Description | Negotiated Airfares | |
Root table | TA20NEGOF | Negotiated Flight Fares (Corporate Nego Fares) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TA20NEGOF | TA20NEGOF | ||
2 | TA21P | TA20NEGOF | PROVIDER | E |
3 | TA20NEGOF1 | TA20NEGOF | ENDDA | I |
4 | TCURC | TA20NEGOF | CURRENCY | E |
5 | TCURT | TCURC | WAERS | I |
6 | TA20ROUTE | TA20NEGOF | ROUTING | E |
7 | TA23ROUTE1 | TA20ROUTE | ROUTING_NUMBER | I |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | TA20NEGOF | MANDT | MANDT | Client | |||
2 | PROVIDER | TA20NEGOF | PROVIDER | NEGO_PROVIDER | Provider of negotiated rate | |||
3 | GEOORG_TYPE | TA20NEGOF | GEOORG_TYPE | GEO_ORIGIN_TYPE | Geographical Origin Type | |||
4 | GEOORG | TA20NEGOF | GEOORG | GEO_ORIGIN | Geographical Origin | |||
5 | GEODEST_TYPE | TA20NEGOF | GEODEST_TYPE | GEO_DESTINATION_TYPE | Type of Geographical Destination | |||
6 | GEODEST | TA20NEGOF | GEODEST | GEO_DESTINATION | Geographical Destination | |||
7 | DIRECTIONALITY | TA20NEGOF | DIRECTIONALITY | DIRECTIONALITY | Direction | |||
8 | FAREBASIS | TA20NEGOF | FAREBASIS | NEGO_FARE_BASIS | Fare Basis | |||
9 | ENDDA | TA20NEGOF | ENDDA | ENDDA | End Date | |||
10 | BEGDA | TA20NEGOF | BEGDA | BEGDA | Start Date | |||
11 | FARETYPE | TA20NEGOF | FARETYPE | NEGO_FARE_TYPE | Type of Negotiated Airfare Rate | |||
12 | FARENATURE | TA20NEGOF | FARENATURE | FARE_NATURE | Rate Type (One-Way or Round Trip) | |||
13 | CORPID | TA20NEGOF | CORPID | CORP_NEGO_ID | Contract Number | |||
14 | PTC | TA20NEGOF | PTC | PASSENGER_TYPE_CODE | Flight Passenger Category | |||
15 | PUSE | TA20NEGOF | PUSE | PUSE_FLAG | Private usage permitted | |||
16 | CABIN | TA20NEGOF | CABIN | FLIGHT_CABIN | Flight Cabin Class | |||
17 | CLASS | TA20NEGOF | CLASS | FLIGHT_BOOKING_CODE | Booking Code | |||
18 | ROUTING | TA20NEGOF | ROUTING | ROUTING_NUMBER | Route | |||
19 | BASE_PRICE | TA20NEGOF | BASE_PRICE | NEGO_FARE | Price of negotiated rate | |||
20 | PRICE | TA20NEGOF | PRICE | NEGO_FARE | Price of negotiated rate | |||
21 | CURRENCY | TA20NEGOF | CURRENCY | NEGO_FARE_CURRENCY | Currency of negotiated rate | |||
22 | SHORTTXT | TA20NEGOF1 | SHORTTXT | NEGO_SHORT_TEXT | Description of Rate | |||
23 | LONGTXT | TA20NEGOF1 | LONGTXT | NEGO_LONG_TEXT | Rate Description | |||
24 | NAME | TA21P | NAME | R | PROVIDER_NAME | Provider Name | ||
25 | KTEXT | TCURT | KTEXT | R | KTEXT_CURT | Short text | ||
26 | MANDATORY_USE | TA20NEGOF | MANDATORY_USE | MANDATORY_FLAG | Usage of Rate is Mandatory | |||
27 | NAME_ROUTE | TA23ROUTE1 | NAME | R | ROUTE_NAME | Route Name | ||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 110 |