SAP ABAP View V_FTPT_FL_TSTK (View of DB Table FTPT_FLIGHT_TSTK (Airline Ticket Data))
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 | D | Database View |
Database View | V_FTPT_FL_TSTK | |
Short Description | View of DB Table FTPT_FLIGHT_TSTK (Airline Ticket Data) | |
Root table | FTPT_FLIGHT_TSTK | Ticket Information |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | FTPT_FLIGHT_TSTK | FTPT_FLIGHT_TSTK |
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 | FTPT_FLIGHT_TSTK | MANDT | MANDT | Client | |||
2 | PERNR | FTPT_FLIGHT_TSTK | PERNR | PERNR_D | Personnel Number | |||
3 | REINR | FTPT_FLIGHT_TSTK | REINR | REINR | Trip Number | |||
4 | PLANNR | FTPT_FLIGHT_TSTK | PLANNR | PLAN_NR | Travel Plan Number (Sequential Number) | |||
5 | VARIANTE | FTPT_FLIGHT_TSTK | VARIANTE | VARIANT_NR | Plan variant number (sequential number) | |||
6 | VARIANTVRS | FTPT_FLIGHT_TSTK | VARIANTVRS | VARIANT_VERSION | Version of travel plan | |||
7 | TICKET | FTPT_FLIGHT_TSTK | TICKET | TICKET | Ticket | |||
8 | PLATING_CARRIER | FTPT_FLIGHT_TSTK | PLATING_CARRIER | PLATING_CARRIER | Plating Carrier | |||
9 | LOCAL_TST | FTPT_FLIGHT_TSTK | LOCAL_TST | LOCAL_TST | Ticket element is local (not in booking system) | |||
10 | LAST_DATE | FTPT_FLIGHT_TSTK | LAST_DATE | TST_LAST_DATE | Last Ticketing Date | |||
11 | TICKET_MODE | FTPT_FLIGHT_TSTK | TICKET_MODE | TST_TICKET_MODE | Ticketing Mode of Airline Ticket | |||
12 | SALES_IND | FTPT_FLIGHT_TSTK | SALES_IND | TST_SALES_IND | Sales Type of Airline Ticket Rate | |||
13 | FARE | FTPT_FLIGHT_TSTK | FARE | TST_FARE | Basic rate for flight ticket without tax | |||
14 | FARE_CURR | FTPT_FLIGHT_TSTK | FARE_CURR | TST_FARE_CURR | Currency | |||
15 | ISSUE_TYPE | FTPT_FLIGHT_TSTK | ISSUE_TYPE | TST_ISSUE_TYPE | Airline Ticket Issue | |||
16 | TOTAL_FARE_PAID | FTPT_FLIGHT_TSTK | TOTAL_FARE_PAID | TST_TOTAL_FARE | Total price of flight ticket | |||
17 | TOTAL_FARE_CURR | FTPT_FLIGHT_TSTK | TOTAL_FARE_CURR | TST_TOTAL_FARE_CURR | Currency | |||
18 | REBATE_FARE | FTPT_FLIGHT_TSTK | REBATE_FARE | TST_REBATED_FARE | Discount price of flight ticket | |||
19 | REBATE_FARE_CURR | FTPT_FLIGHT_TSTK | REBATE_FARE_CURR | TST_REBATED_FARE_CURR | Currency | |||
20 | TICKETNUMBER | FTPT_FLIGHT_TSTK | TICKETNUMBER | TICKET_NUMBER | Ticket Number | |||
21 | TICKETTYPE | FTPT_FLIGHT_TSTK | TICKETTYPE | TICKETTYPE | Ticket Type | |||
22 | INFO | FTPT_FLIGHT_TSTK | INFO | TICKETINFO | Ticket Information | |||
23 | TST_FARE_TYPE | FTPT_FLIGHT_TSTK | TST_FARE_TYPE | TST_FARE_TYPE | Fare Type (Normal, Negotiated, Etc.) | |||
24 | FULL_FARE | FTPT_FLIGHT_TSTK | FULL_FARE | FLIGHT_FULL_FARE | Unrestricted Rate in the same Cabin Class | |||
25 | FULL_FARE_CURR | FTPT_FLIGHT_TSTK | FULL_FARE_CURR | FLIGHT_FULL_FARE_CURR | Currency | |||
26 | CHEAPEST_FARE | FTPT_FLIGHT_TSTK | CHEAPEST_FARE | CHEAPEST_ALT_FARE | Lowest-Cost Alternative Airfare Rate | |||
27 | CHEAPEST_FARE_C | FTPT_FLIGHT_TSTK | CHEAPEST_FARE_C | CHEAPEST_ALT_FARE_CURR | Currency of Lowest-Cost Alternative Airfare Rate | |||
28 | LCC | FTPT_FLIGHT_TSTK | LCC | LCC | Low-Cost Carrier | |||
29 | URL_LCC | FTPT_FLIGHT_TSTK | URL_LCC | URL_LCC | Low-Cost Carrier: URL for Web Page | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20050520 |
SAP Release Created in | 600 |