SAP ABAP Table V_FTPT_FL_TSTK (Generated Table for View V_FTPT_FL_TSTK)
Basic Data
Table Category | VIEW | General view structure |
General view structure | V_FTPT_FL_TSTK | Table Relationship Diagram |
Short Description | Generated Table for View V_FTPT_FL_TSTK |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
3 | REINR | REINR | REINR | NUMC | 10 | 0 | Trip Number | ||
4 | PLANNR | PLAN_NR | FTPD_PLAN_NR | NUMC | 2 | 0 | Travel Plan Number (Sequential Number) | ||
5 | VARIANTE | VARIANT_NR | FTPD_VARIANT_NR | NUMC | 2 | 0 | Plan variant number (sequential number) | ||
6 | VARIANTVRS | VARIANT_VERSION | FTPD_VARIANT_VERSION | NUMC | 2 | 0 | Version of travel plan | FTPT_VARIANT | |
7 | TICKET | TICKET | FTPD_TICK_ID | NUMC | 3 | 0 | Ticket | ||
8 | PLATING_CARRIER | PLATING_CARRIER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Plating Carrier | TA21P | |
9 | LOCAL_TST | LOCAL_TST | CHAR1_X | CHAR | 1 | 0 | Ticket element is local (not in booking system) | ||
10 | LAST_DATE | TST_LAST_DATE | FTPD_DATE | DATS | 8 | 0 | Last Ticketing Date | ||
11 | TICKET_MODE | TST_TICKET_MODE | FTPD_TST_MODE | CHAR | 1 | 0 | Ticketing Mode of Airline Ticket | ||
12 | SALES_IND | TST_SALES_IND | FTPD_TST_SALES_IND | CHAR | 4 | 0 | Sales Type of Airline Ticket Rate | ||
13 | FARE | TST_FARE | FTPD_PRICE | CURR | 10 | 2 | Basic rate for flight ticket without tax | ||
14 | FARE_CURR | TST_FARE_CURR | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
15 | ISSUE_TYPE | TST_ISSUE_TYPE | FTPD_TST_ISSUE_TYPE | CHAR | 1 | 0 | Airline Ticket Issue | ||
16 | TOTAL_FARE_PAID | TST_TOTAL_FARE | FTPD_PRICE | CURR | 10 | 2 | Total price of flight ticket | ||
17 | TOTAL_FARE_CURR | TST_TOTAL_FARE_CURR | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
18 | REBATE_FARE | TST_REBATED_FARE | FTPD_PRICE | CURR | 10 | 2 | Discount price of flight ticket | ||
19 | REBATE_FARE_CURR | TST_REBATED_FARE_CURR | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
20 | TICKETNUMBER | TICKET_NUMBER | FTPD_TICKET_NUMBER | NUMC | 15 | 0 | Ticket Number | ||
21 | TICKETTYPE | TICKETTYPE | FTPD_TICKET_TYPE | CHAR | 1 | 0 | Ticket Type | ||
22 | INFO | TICKETINFO | FTPD_TICKET_INFO | CHAR | 77 | 0 | Ticket Information | ||
23 | TST_FARE_TYPE | TST_FARE_TYPE | FTPD_TST_FARE_TYPE | CHAR | 2 | 0 | Fare Type (Normal, Negotiated, Etc.) | ||
24 | FULL_FARE | FLIGHT_FULL_FARE | FTPD_PRICE | CURR | 10 | 2 | Unrestricted Rate in the same Cabin Class | ||
25 | FULL_FARE_CURR | FLIGHT_FULL_FARE_CURR | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
26 | CHEAPEST_FARE | CHEAPEST_ALT_FARE | FTPD_PRICE | CURR | 10 | 2 | Lowest-Cost Alternative Airfare Rate | ||
27 | CHEAPEST_FARE_C | CHEAPEST_ALT_FARE_CURR | WAERS | CUKY | 5 | 0 | Currency of Lowest-Cost Alternative Airfare Rate | ||
28 | LCC | LCC | XFELD | CHAR | 1 | 0 | Low-Cost Carrier | ||
29 | URL_LCC | URL_LCC | TEXT255 | CHAR | 255 | 0 | Low-Cost Carrier: URL for Web Page |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | V_FTPT_FL_TSTK | FARE_CURR | TCURC | WAERS | REF | 1 | CN |
2 | V_FTPT_FL_TSTK | FULL_FARE_CURR | TCURC | WAERS | REF | 1 | CN |
3 | V_FTPT_FL_TSTK | PLATING_CARRIER | TA21P | PROVIDER | REF | 1 | CN |
4 | V_FTPT_FL_TSTK | REBATE_FARE_CURR | TCURC | WAERS | REF | 1 | CN |
5 | V_FTPT_FL_TSTK | TOTAL_FARE_CURR | TCURC | WAERS | REF | 1 | CN |
6 | V_FTPT_FL_TSTK | VARIANTVRS | FTPT_VARIANT | VARIANT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050520 |
SAP Release Created in |