SAP Table FTPT_IMR_FLIGHT
IMR - Flight
FTPT_IMR_FLIGHT (IMR - Flight) 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_IMR_FLIGHT to other SAP tables.
FTPT_IMR_FLIGHT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| RECORD_LOCATOR | Passenger Name Record Locator | PNR_RECORD_LOCATOR | CHAR | 20 | 0 | |||
| AIR_NUMBER | Air record unique identifier | AIR_RECORD_NUMBER | FTPT_IMR | NUMC | 12 | 0 | ||
| RUNNING_NUMBER | Index | RUNNING_NUMBER | NUMC | 4 | 0 | |||
| TKT_SEG_IND | CHAR | 1 | 0 | |||||
| FLIGHT_SEG_TYPE | AIR : Description of segment type for itinerary portion | API_1A_AIR_SEGMENT_TYPE | NUMC | 2 | 0 | |||
| TATTOO_NB | Amadeus unique identifier for each element stored in PNR | API_1A_TATTOO_NUMBER | NUMC | 4 | 0 | |||
| DISPLAY_NB | Amadeus unique identifier for each element displayed in PNR | API_1A_DISPLAY_NUMBER | NUMC | 4 | 0 | |||
| OPEN_SEG_IND | CHAR | 1 | 0 | |||||
| STOPOVER_IND | CHAR | 1 | 0 | |||||
| DEPARTURE_ARPT | Airport code definition | API_1A_AIRPORT_CODE | CHAR | 5 | 0 | |||
| ARRIVAL_ARPT | Airport code definition | API_1A_AIRPORT_CODE | CHAR | 5 | 0 | |||
| AIRLINE_CODE | Airline Code definition | API_1A_AIRLINE_CODE | CHAR | 5 | 0 | |||
| FLIGHT_NB | Flight number definition | API_1A_FLIGHT_NUMBER | CHAR | 5 | 0 | |||
| CLASS_OF_SERVICE | Class type definition | API_1A_CLASS_TYPE | CHAR | 2 | 0 | |||
| CLASS_OF_BOOKING | Class type definition | API_1A_CLASS_TYPE | CHAR | 2 | 0 | |||
| DEPARTURE_DATE | DATS | 8 | 0 | |||||
| DEPARTURE_TIME | TIMS | 6 | 0 | |||||
| ARRIVAL_DATE | DATS | 8 | 0 | |||||
| ARRIVAL_TIME | TIMS | 6 | 0 | |||||
| RAW_STATUS_CODE | Raw descrition of amadeus Status Code with Number in Party | API_1A_RAW_STATUS_CODE | CHAR | 5 | 0 | |||
| MEAL_CODE | Amadeus Meal Code | API_1A_MEAL_CODE | CHAR | 3 | 0 | |||
| NB_OF_STOPS | NUMC | 1 | 0 | |||||
| EQUIPMENT_TYPE | Amadeus equipment type code | API_1A_EQUIPMENT_TYPE | CHAR | 3 | 0 | |||
| ENTERTAIN_CODE | CHAR | 1 | 0 | |||||
| BAG_ALLOWANCE | Baggage allowance description | API_1A_BAGGAGE_ALLOWANCE | CHAR | 3 | 0 | |||
| CHECK_IN_TERM | Terminal Code | API_1A_TERMINAL_CODE | CHAR | 2 | 0 | |||
| CHECK_IN_TIME | TIMS | 6 | 0 | |||||
| E_TKT_IND | CHAR | 1 | 0 | |||||
| FLIGHT_DURATION | Flight duration in Format : HH:MM | API_1A_FLIGHT_DURATION | CHAR | 5 | 0 | |||
| NON_SMOKING_IND | CHAR | 1 | 0 | |||||
| SHARED_COMM_CXR | CHAR | 50 | 0 | |||||
| TOUR_SEGMENT_TAG | CHAR | 6 | 0 | |||||
| FLOWN_IND | CHAR | 1 | 0 | |||||
FTPT_IMR_FLIGHT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| FTPT_IMR_FLIGHT | AIR_NUMBER | FTPT_IMR_FLIGHT | MANDT | FTPT_IMR | IMR - General Information | .INCLUDE |
| FTPT_IMR_FLIGHT | AIR_NUMBER | FTPT_IMR_FLIGHT | RECORD_LOCATOR | FTPT_IMR | IMR - General Information | MANDT |
| FTPT_IMR_FLIGHT | AIR_NUMBER | FTPT_IMR_FLIGHT | AIR_NUMBER | FTPT_IMR | IMR - General Information | RECORD_LOCATOR |
