SAP table FTPT_FLIGHT_TSTK (Ticket Information)
SAP table FTPT_FLIGHT_TSTK has 7 primary key fields being MANDT,PERNR,REINR,PLANNR,VARIANTE,VARIANTVRS,TICKET.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||
| REINR | Trip Number | NUMC | 10 | 0 | REINR | ||
| PLANNR | Travel Plan Number (Sequential Number) | NUMC | 2 | 0 | * | PLAN_NR | |
| VARIANTE | Plan variant number (sequential number) | NUMC | 2 | 0 | VARIANT_NR | ||
| VARIANTVRS | Version of travel plan | NUMC | 2 | 0 | FTPT_VARIANT | VARIANT_VERSION | |
| TICKET | Ticket | NUMC | 3 | 0 | TICKET | ||
| PLATING_CARRIER | Plating Carrier | CHAR | 3 | 0 | TA21P | PLATING_CARRIER | |
| LOCAL_TST | Ticket element is local (not in booking system) | CHAR | 1 | 0 | LOCAL_TST | ||
| LAST_DATE | Last Ticketing Date | DATS | 8 | 0 | TST_LAST_DATE | ||
| TICKET_MODE | Ticketing Mode of Airline Ticket | CHAR | 1 | 0 | TST_TICKET_MODE | ||
| SALES_IND | Sales Type of Airline Ticket Rate | CHAR | 4 | 0 | TST_SALES_IND | ||
| FARE | Basic rate for flight ticket without tax | CURR | 10 | 2 | TST_FARE | ||
| FARE_CURR | Currency | CUKY | 5 | 0 | TCURC | TST_FARE_CURR | |
| ISSUE_TYPE | Airline Ticket Issue | CHAR | 1 | 0 | TST_ISSUE_TYPE | ||
| TOTAL_FARE_PAID | Total price of flight ticket | CURR | 10 | 2 | TST_TOTAL_FARE | ||
| TOTAL_FARE_CURR | Currency | CUKY | 5 | 0 | TCURC | TST_TOTAL_FARE_CURR | |
| REBATE_FARE | Discount price of flight ticket | CURR | 10 | 2 | TST_REBATED_FARE | ||
| REBATE_FARE_CURR | Currency | CUKY | 5 | 0 | TCURC | TST_REBATED_FARE_CURR | |
| TICKETNUMBER | Ticket Number | NUMC | 15 | 0 | TICKET_NUMBER | ||
| TICKETTYPE | Ticket Type | CHAR | 1 | 0 | TICKETTYPE | ||
| INFO | Ticket Information | CHAR | 77 | 0 | TICKETINFO | ||
| TST_FARE_TYPE | Fare Type (Normal, Negotiated, Etc.) | CHAR | 2 | 0 | TST_FARE_TYPE | ||
| FULL_FARE | Unrestricted Rate in the same Cabin Class | CURR | 10 | 2 | FLIGHT_FULL_FARE | ||
| FULL_FARE_CURR | Currency | CUKY | 5 | 0 | TCURC | FLIGHT_FULL_FARE_CURR | |
| CHEAPEST_FARE | Lowest-Cost Alternative Airfare Rate | CURR | 10 | 2 | CHEAPEST_ALT_FARE | ||
| CHEAPEST_FARE_C | Currency of Lowest-Cost Alternative Airfare Rate | CUKY | 5 | 0 | * | CHEAPEST_ALT_FARE_CURR | |
| LCC | Low-Cost Carrier | CHAR | 1 | 0 | LCC | ||
| URL_LCC | Low-Cost Carrier: URL for Web Page | CHAR | 255 | 0 | URL_LCC | ||
| EXCEEDING_FARE | Excess Amount over Lowest Offer | CURR | 10 | 2 | EXCEEDING_FARE | ||
| EXCEEDING_FARE_C | Currency of Excess Amount over Lowest Offer | CUKY | 5 | 0 | * | EXCEEDING_FARE_CURR | |
| TAXES | Taxes | CURR | 10 | 2 | FLIGHT_TAXES_AMOUNT | ||
| TAXES_CURR | Currency | CUKY | 5 | 0 | * | FLIGHT_TAX_CURRENCY | |
| LAST_TIME | Latest Ticketing Time | TIMS | 6 | 0 | TST_LAST_TIME | ||
| LAST_APPROVAL_DATE | Last Ticketing Date | DATS | 8 | 0 | TST_LAST_DATE | ||
| LAST_APPROVAL_TIME | Latest Ticketing Time | TIMS | 6 | 0 | TST_LAST_TIME |
FTPT_FLIGHT_TSTK foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 FTPT_FLIGHT_TSTK | FARE_CURR | TCURC | Currency Codes | MANDT |
| 0 FTPT_FLIGHT_TSTK | FARE_CURR | TCURC | Currency Codes | WAERS |
| 1 FTPT_FLIGHT_TSTK | FULL_FARE_CURR | TCURC | Currency Codes | MANDT |
| 1 FTPT_FLIGHT_TSTK | FULL_FARE_CURR | TCURC | Currency Codes | WAERS |
| 0 FTPT_FLIGHT_TSTK | PLATING_CARRIER | TA21P | Travel Service Providers | MANDT |
| 0 FTPT_FLIGHT_TSTK | PLATING_CARRIER | TA21P | Travel Service Providers | CATEGORY |
| 0 FTPT_FLIGHT_TSTK | PLATING_CARRIER | TA21P | Travel Service Providers | PROVIDER |
| 1 FTPT_FLIGHT_TSTK | REBATE_FARE_CURR | TCURC | Currency Codes | MANDT |
| 1 FTPT_FLIGHT_TSTK | REBATE_FARE_CURR | TCURC | Currency Codes | WAERS |
| 0 FTPT_FLIGHT_TSTK | TOTAL_FARE_CURR | TCURC | Currency Codes | MANDT |
| 0 FTPT_FLIGHT_TSTK | TOTAL_FARE_CURR | TCURC | Currency Codes | WAERS |
| 1 FTPT_FLIGHT_TSTK | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | .INCLUDE |
| 1 FTPT_FLIGHT_TSTK | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | MANDT |
| 1 FTPT_FLIGHT_TSTK | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | PERNR |
| 1 FTPT_FLIGHT_TSTK | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | REINR |
| 1 FTPT_FLIGHT_TSTK | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | PLANNR |