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
⤷ 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 | 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 | 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 | TST_FARE_TYPE | FTPT_FLIGHT_TSTK | 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 |