SAP Table FTPT_ITEM
Travel Service Request Item
FTPT_ITEM (Travel Service Request Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FTPT_ITEM to other SAP tables.
FTPT_ITEM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||||||||||
| REINR | Trip Number | REINR | NUMC | 10 | 0 | |||||||||||||||||
| PLANNR | Travel Plan Number (Sequential Number) | PLAN_NR | NUMC | 2 | 0 | |||||||||||||||||
| VARIANT | Plan variant number (sequential number) | VARIANT_NR | NUMC | 2 | 0 | |||||||||||||||||
| VARIANTVRS | Version of travel plan | VARIANT_VERSION | FTPT_VARIANT | NUMC | 2 | 0 | ||||||||||||||||
| ITEM | Travel Request Item Number (Sequential Number) | ITEMPOS_NR | NUMC | 3 | 0 | |||||||||||||||||
| USERG | User Grouping for Travel Planning | EMPLOYEE_GROUP_TP | TA20B | CHAR | 2 | 0 | ||||||||||||||||
| CATEGORY | Enterprise-Specific Travel Service Category | ITEMPOS_USER_CAT | TA20C | CHAR | 1 | 0 | ||||||||||||||||
| REAL_CAT | Travel service category | CATEGORY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| DATE_BEG | Start Date of Request Item | ITEMPOS_DATE_BEG | DATS | 8 | 0 | |||||||||||||||||
| TIME_BEG | Start Time for Request Item | ITEMPOS_TIME_BEG | TIMS | 6 | 0 | |||||||||||||||||
| LOC_BEG | Starting Location of Request Item | ITEMPOS_LOC_BEG | TA21L | CHAR | 3 | 0 | ||||||||||||||||
| DATE_END | End date of request item | ITEMPOS_DATE_END | DATS | 8 | 0 | |||||||||||||||||
| TIME_END | End time for request item | ITEMPOS_TIME_END | TIMS | 6 | 0 | |||||||||||||||||
| LOC_END | End Location of Request Item | ITEMPOS_LOC_END | TA21L | CHAR | 3 | 0 | ||||||||||||||||
| CLASS | Request item class | ITEMPOS_CLASS | CHAR | 2 | 0 | |||||||||||||||||
| PRICE_AVAI | Price at availability query of request item | ITEMPOS_PRICE_AVAI | CURR | 10 | 2 | |||||||||||||||||
| PRICE_APPR | Price at approval of request item | ITEMPOS_PRICE_APPR | CURR | 10 | 2 | |||||||||||||||||
| PRICE | Price of request item | ITEMPOS_PRICE | CURR | 10 | 2 | |||||||||||||||||
| CURRENCY | Currency of request item | ITEMPOS_CURRENCY | TCURC | CUKY | 5 | 0 | ||||||||||||||||
| REF_ITEM | Reference to another request (return flight) | ITEMPOS_REF_NR | NUMC | 3 | 0 | |||||||||||||||||
| STATUS | Status of Request Item | ITEMPOS_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| TEMPLATE | Template indicator | VARIANT_TEMPLATE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| BELNR | Document Number | NRBEL | CHAR | 3 | 0 | |||||||||||||||||
| FIRMA | Paid by Company | BEZFA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| DEP_ARR | Arrival/Departure time | DEP_ARR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| RES_SYSTEM | Reservation System | RESERVATION_SYSTEM | TA21P | CHAR | 3 | 0 | ||||||||||||||||
| PERSONS | Number of Persons on Request Item | ITEMPOS_NR_PERS | NUMC | 2 | 0 | |||||||||||||||||
FTPT_ITEM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| FTPT_ITEM | CATEGORY | FTPT_ITEM | MANDT | TA20C | Enterprise-Specific Travel Service Categories | MANDT |
| FTPT_ITEM | CATEGORY | FTPT_ITEM | USERG | TA20C | Enterprise-Specific Travel Service Categories | USERG |
| FTPT_ITEM | CATEGORY | FTPT_ITEM | CATEGORY | TA20C | Enterprise-Specific Travel Service Categories | USER_CATEGORY |
| FTPT_ITEM | CURRENCY | FTPT_ITEM | CURRENCY | TCURC | Currency Codes | WAERS |
| FTPT_ITEM | CURRENCY | FTPT_ITEM | MANDT | TCURC | Currency Codes | MANDT |
| FTPT_ITEM | LOC_BEG | FTPT_ITEM | MANDT | TA21L | IATA Locations | MANDT |
| FTPT_ITEM | LOC_BEG | FTPT_ITEM | LOC_BEG | TA21L | IATA Locations | LOCID |
| FTPT_ITEM | LOC_END | FTPT_ITEM | LOC_END | TA21L | IATA Locations | LOCID |
| FTPT_ITEM | LOC_END | FTPT_ITEM | MANDT | TA21L | IATA Locations | MANDT |
| FTPT_ITEM | RES_SYSTEM | FTPT_ITEM | MANDT | TA21P | Travel Service Providers | MANDT |
| FTPT_ITEM | RES_SYSTEM | 'R' | TA21P | Travel Service Providers | CATEGORY | |
| FTPT_ITEM | RES_SYSTEM | FTPT_ITEM | RES_SYSTEM | TA21P | Travel Service Providers | PROVIDER |
| FTPT_ITEM | USERG | FTPT_ITEM | MANDT | TA20B | Control Variant for Travel Planning | MANDT |
| FTPT_ITEM | USERG | FTPT_ITEM | USERG | TA20B | Control Variant for Travel Planning | USERG |
| FTPT_ITEM | VARIANTVRS | FTPT_ITEM | PLANNR | FTPT_VARIANT | Table of Travel Plan Variants | REINR |
| FTPT_ITEM | VARIANTVRS | FTPT_ITEM | VARIANT | FTPT_VARIANT | Table of Travel Plan Variants | PLANNR |
| FTPT_ITEM | VARIANTVRS | FTPT_ITEM | VARIANTVRS | FTPT_VARIANT | Table of Travel Plan Variants | VARIANT |
| FTPT_ITEM | VARIANTVRS | FTPT_ITEM | MANDT | FTPT_VARIANT | Table of Travel Plan Variants | .INCLUDE |
| FTPT_ITEM | VARIANTVRS | FTPT_ITEM | PERNR | FTPT_VARIANT | Table of Travel Plan Variants | MANDT |
| FTPT_ITEM | VARIANTVRS | FTPT_ITEM | REINR | FTPT_VARIANT | Table of Travel Plan Variants | PERNR |
