SAP ABAP View BW_FI_TV_TICKET (View for Table FTPT_FLIGHT_TST(K))
Hierarchy
☛
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷
FI-TV (Application Component) Travel Management
⤷
FTBW (Package) Data Transfer FI-TV to BW
⤷
⤷
Basic Data
| View Type | D | Database View |
| Database View | BW_FI_TV_TICKET | |
| Short Description | View for Table FTPT_FLIGHT_TST(K) | |
| Root table | FTPT_FLIGHT_TSTK | Ticket Information |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | 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 | MANDT | Client | |||||
| 2 | PERNR | PERNR_D | Personnel Number | |||||
| 3 | REINR | REINR | Trip Number | |||||
| 4 | PLANNR | PLAN_NR | Travel Plan Number (Sequential Number) | |||||
| 5 | VARIANTE | VARIANT_NR | Plan variant number (sequential number) | |||||
| 6 | VARIANTVRS | VARIANT_VERSION | Version of travel plan | |||||
| 7 | TICKET | TICKET | Ticket | |||||
| 8 | PLATING_CARRIER | PLATING_CARRIER | Plating Carrier | |||||
| 9 | LOCAL_TST | LOCAL_TST | Ticket element is local (not in booking system) | |||||
| 10 | LAST_DATE | TST_LAST_DATE | Last Ticketing Date | |||||
| 11 | TICKET_MODE | TST_TICKET_MODE | Ticketing Mode of Airline Ticket | |||||
| 12 | SALES_IND | TST_SALES_IND | Sales Type of Airline Ticket Rate | |||||
| 13 | FARE | TST_FARE | Basic rate for flight ticket without tax | |||||
| 14 | FARE_CURR | TST_FARE_CURR | Currency | |||||
| 15 | ISSUE_TYPE | TST_ISSUE_TYPE | Airline Ticket Issue | |||||
| 16 | TOTAL_FARE_PAID | TST_TOTAL_FARE | Total price of flight ticket | |||||
| 17 | TOTAL_FARE_CURR | TST_TOTAL_FARE_CURR | Currency | |||||
| 18 | REBATE_FARE | TST_REBATED_FARE | Discount price of flight ticket | |||||
| 19 | REBATE_FARE_CURR | TST_REBATED_FARE_CURR | Currency | |||||
| 20 | TICKETNUMBER | TICKET_NUMBER | Ticket Number | |||||
| 21 | TICKETTYPE | TICKETTYPE | Ticket Type | |||||
| 22 | TST_FARE_TYPE | TST_FARE_TYPE | Fare Type (Normal, Negotiated, Etc.) | |||||
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 | 20040210 |
| SAP Release Created in |