SAP table FTPT_ITEM (Travel Service Request Item)
SAP table FTPT_ITEM has 7 primary key fields being MANDT,PERNR,REINR,PLANNR,VARIANT,VARIANTVRS,ITEM.
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 | |
| VARIANT | Plan variant number (sequential number) | NUMC | 2 | 0 | VARIANT_NR | ||
| VARIANTVRS | Version of travel plan | NUMC | 2 | 0 | FTPT_VARIANT | VARIANT_VERSION | |
| ITEM | Travel Request Item Number (Sequential Number) | NUMC | 3 | 0 | ITEMPOS_NR | ||
| USERG | User Grouping for Travel Planning | CHAR | 2 | 0 | TA20B | EMPLOYEE_GROUP_TP | |
| CATEGORY | Enterprise-Specific Travel Service Category | CHAR | 1 | 0 | TA20C | ITEMPOS_USER_CAT | |
| REAL_CAT | Travel service category | CHAR | 1 | 0 | CATEGORY | ||
| DATE_BEG | Start Date of Request Item | DATS | 8 | 0 | ITEMPOS_DATE_BEG | ||
| TIME_BEG | Start Time for Request Item | TIMS | 6 | 0 | ITEMPOS_TIME_BEG | ||
| LOC_BEG | Starting Location of Request Item | CHAR | 3 | 0 | TA21L | ITEMPOS_LOC_BEG | |
| DATE_END | End date of request item | DATS | 8 | 0 | ITEMPOS_DATE_END | ||
| TIME_END | End time for request item | TIMS | 6 | 0 | ITEMPOS_TIME_END | ||
| LOC_END | End Location of Request Item | CHAR | 3 | 0 | TA21L | ITEMPOS_LOC_END | |
| CLASS | Request item class | CHAR | 2 | 0 | ITEMPOS_CLASS | ||
| PRICE_AVAI | Price at availability query of request item | CURR | 10 | 2 | ITEMPOS_PRICE_AVAI | ||
| PRICE_APPR | Price at approval of request item | CURR | 10 | 2 | ITEMPOS_PRICE_APPR | ||
| PRICE | Price of request item | CURR | 10 | 2 | ITEMPOS_PRICE | ||
| CURRENCY | Currency of request item | CUKY | 5 | 0 | TCURC | ITEMPOS_CURRENCY | |
| REF_ITEM | Reference to another request (return flight) | NUMC | 3 | 0 | ITEMPOS_REF_NR | ||
| STATUS | Status of Request Item | CHAR | 1 | 0 | ITEMPOS_STATUS | ||
| TEMPLATE | Template indicator | CHAR | 1 | 0 | VARIANT_TEMPLATE | ||
| BELNR | Document Number | CHAR | 3 | 0 | NRBEL | ||
| FIRMA | Paid by Company | CHAR | 1 | 0 | BEZFA | ||
| DEP_ARR | Arrival/Departure time | CHAR | 1 | 0 | DEP_ARR | ||
| RES_SYSTEM | Reservation System | CHAR | 3 | 0 | TA21P | RESERVATION_SYSTEM | |
| PERSONS | Number of Persons on Request Item | NUMC | 2 | 0 | ITEMPOS_NR_PERS |
FTPT_ITEM foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 FTPT_ITEM | CATEGORY | TA20C | Enterprise-Specific Travel Service Categories | MANDT |
| 0 FTPT_ITEM | CATEGORY | TA20C | Enterprise-Specific Travel Service Categories | USER_CATEGORY |
| 1 FTPT_ITEM | CURRENCY | TCURC | Currency Codes | WAERS |
| 0 FTPT_ITEM | LOC_BEG | TA21L | IATA Locations | MANDT |
| 0 FTPT_ITEM | LOC_BEG | TA21L | IATA Locations | LOCID |
| 1 FTPT_ITEM | LOC_END | TA21L | IATA Locations | MANDT |
| 1 FTPT_ITEM | LOC_END | TA21L | IATA Locations | LOCID |
| 0 FTPT_ITEM | RES_SYSTEM | TA21P | Travel Service Providers | MANDT |
| 0 FTPT_ITEM | RES_SYSTEM | TA21P | Travel Service Providers | CATEGORY |
| 0 FTPT_ITEM | RES_SYSTEM | TA21P | Travel Service Providers | PROVIDER |
| 1 FTPT_ITEM | USERG | TA20B | Control Variant for Travel Planning | MANDT |
| 1 FTPT_ITEM | USERG | TA20B | Control Variant for Travel Planning | USERG |
| 0 FTPT_ITEM | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | .INCLUDE |
| 0 FTPT_ITEM | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | MANDT |
| 0 FTPT_ITEM | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | PERNR |
| 0 FTPT_ITEM | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | REINR |
| 0 FTPT_ITEM | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | PLANNR |