SAP Table FTPT_IMR
IMR - General Information
FTPT_IMR (IMR - General Information) 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 to other SAP tables.
FTPT_IMR 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 | NUMC | 12 | 0 | |||
| AIR_VERSION | NUMC | 3 | 0 | |||||
| AIR_OPTION | CHAR | 2 | 0 | |||||
| RECORD_TYPE | CHAR | 1 | 0 | |||||
| TRAINING_IND | CHAR | 1 | 0 | |||||
| AIR_NETWORK_ID | 2 Digit code identifying the Amadeus Network Id | API_1A_NETWORK_ID | NUMC | 2 | 0 | |||
| AIR_LNIATA | 8 Digit code identifying a terminal address in Amadeus | API_1A_LNIATA | NUMC | 8 | 0 | |||
| RETRANSM_IND | CHAR | 1 | 0 | |||||
| ACTION_TYPE | CHAR | 4 | 0 | |||||
| VOID_DATE | DATS | 8 | 0 | |||||
| VOID_AGENT_SINE | Travel Agency sine in code in Amadeus | API_1A_AGENT_SINE | CHAR | 4 | 0 | |||
| TKT_NETWORK_ID | 2 Digit code identifying the Amadeus Network Id | API_1A_NETWORK_ID | NUMC | 2 | 0 | |||
| TKT_LNIATA | 8 Digit code identifying a terminal address in Amadeus | API_1A_LNIATA | NUMC | 8 | 0 | |||
| BO_NETWORK_ID | 2 Digit code identifying the Amadeus Network Id | API_1A_NETWORK_ID | NUMC | 2 | 0 | |||
| BO_LNIATA | 8 Digit code identifying a terminal address in Amadeus | API_1A_LNIATA | NUMC | 8 | 0 | |||
| CITY_IDENTIFIER | 5 character code identifying a City Code | API_1A_CITY_CODE | CHAR | 5 | 0 | |||
| AIRLINE_CODE | Airline Code definition | API_1A_AIRLINE_CODE | CHAR | 5 | 0 | |||
| NUM_PSGR_PNR | INT2 | 5 | 0 | |||||
| NUM_PSGR_IMR | INT2 | 5 | 0 | |||||
| NON_HOMOGEN_IND | CHAR | 1 | 0 | |||||
| BOOKING_OFFICE | Code identifying an office id in Amadeus | API_1A_OFFICE_ID | CHAR | 12 | 0 | |||
| BOOKING_IATA_NUM | IATA Number of office id. | API_1A_OFFICE_IATA_NUMBER | NUMC | 8 | 0 | |||
| TICKETING_OFFICE | Code identifying an office id in Amadeus | API_1A_OFFICE_ID | CHAR | 12 | 0 | |||
| TICKETING_IATA | IATA Number of office id. | API_1A_OFFICE_IATA_NUMBER | NUMC | 8 | 0 | |||
| TKT_OFFICE_SUBD | CHAR | 2 | 0 | |||||
| TKT_COUPON_IDENT | CHAR | 15 | 0 | |||||
| PNR_CREATION_DAT | DATS | 8 | 0 | |||||
| PNR_CREATION_TIM | TIMS | 6 | 0 | |||||
| PNR_CHANGE_DATE | DATS | 8 | 0 | |||||
| PNR_CHANGE_TIME | TIMS | 6 | 0 | |||||
| AIR_CREATION_DAT | DATS | 8 | 0 | |||||
| AIR_CREATION_TIM | TIMS | 6 | 0 | |||||
| AGENCY_ACCOUNT | CHAR | 10 | 0 | |||||
| ORDER_NUMBER | CHAR | 10 | 0 | |||||
| AMADEUS_ENTRY | CHAR | 20 | 0 | |||||
