SAP table FTPT_VARIANT (Table of Travel Plan Variants)
SAP table FTPT_VARIANT has 6 primary key fields being MANDT,PERNR,REINR,PLANNR,VARIANT,VARIANTVRS.
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 | FTPT_PLAN | PLAN_NR | |
| VARIANT | Plan variant number (sequential number) | NUMC | 2 | 0 | VARIANT_NR | ||
| VARIANTVRS | Version of travel plan | NUMC | 2 | 0 | VARIANT_VERSION | ||
| NAME | Variant description | CHAR | 30 | 0 | VARIANT_NAME | ||
| PRICE | Variant price | CURR | 10 | 2 | VARIANT_PRICE | ||
| CURRENCY | Currency of variant price | CUKY | 5 | 0 | TCURC | VARIANT_CURR | |
| STATUS | Variant status | CHAR | 1 | 0 | VARIANT_STAT | ||
| PRICING_STATUS | Status of variant price request | CHAR | 1 | 0 | VARIANT_PRICING_STATUS | ||
| INFO_TXT | Information text for variant status | CHAR | 132 | 0 | VARIANT_STINF | ||
| TEMPLATE | Template indicator | CHAR | 1 | 0 | VARIANT_TEMPLATE | ||
| BOOK_REQUEST | Booking flag was started | CHAR | 1 | 0 | BOOK_REQUEST | ||
| REC_LOCATOR | Passenger Name Record Locator | CHAR | 20 | 0 | PNR_RECORD_LOCATOR | ||
| DB_ORDER_NR | Passenger Name Record Locator | CHAR | 20 | 0 | PNR_RECORD_LOCATOR | ||
| FLIGHT_CANCELED | Indicator: Flight Cancelation Exists | CHAR | 1 | 0 | FLIGHT_CANCELED | ||
| AGENCYSTATUS | Travel Agency Status | CHAR | 1 | 0 | AGENCY_STATUS | ||
| RES_SYSTEM | Reservation System | CHAR | 3 | 0 | * | RESERVATION_SYSTEM | |
| LAST_UPDATE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP |
FTPT_VARIANT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 FTPT_VARIANT | CURRENCY | TCURC | Currency Codes | WAERS |
| 1 FTPT_VARIANT | PLANNR | FTPT_PLAN | General Plan Data | .INCLUDE |
| 1 FTPT_VARIANT | PLANNR | FTPT_PLAN | General Plan Data | MANDT |
| 1 FTPT_VARIANT | PLANNR | FTPT_PLAN | General Plan Data | PERNR |
| 1 FTPT_VARIANT | PLANNR | FTPT_PLAN | General Plan Data | REINR |