SAP Table FTPT_IMR_SEATS
IMR: Seating Information
FTPT_IMR_SEATS (IMR: Seating 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_SEATS to other SAP tables.
FTPT_IMR_SEATS 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 | |||
| RUNNING_NB_PSGR | Index | RUNNING_NUMBER | FTPT_IMR_NAMES | NUMC | 4 | 0 | ||
| RUNNING_NB_SEATS | Index | RUNNING_NUMBER | NUMC | 4 | 0 | |||
| TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | API_1A_TATTOO_NUMBER | NUMC | 4 | 0 | |||
| DISPLAY_NUMBER | Amadeus unique identifier for each element displayed in PNR | API_1A_DISPLAY_NUMBER | NUMC | 4 | 0 | |||
| DEP_ARPT | Airport code definition | API_1A_AIRPORT_CODE | CHAR | 5 | 0 | |||
| ARR_ARPT | Airport code definition | API_1A_AIRPORT_CODE | CHAR | 5 | 0 | |||
| SEAT_STATUS | CHAR | 1 | 0 | |||||
| SEAT_NUMBER | CHAR | 3 | 0 | |||||
| SMOKING_IND | CHAR | 1 | 0 | |||||
| GAUGE_IND | CHAR | 1 | 0 | |||||
| FLIGHT_TATTOO | Amadeus unique identifier for each element stored in PNR | API_1A_TATTOO_NUMBER | NUMC | 4 | 0 | |||
FTPT_IMR_SEATS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| FTPT_IMR_SEATS | RUNNING_NB_PSGR | FTPT_IMR_SEATS | AIR_NUMBER | FTPT_IMR_NAMES | IMR : Name | RECORD_LOCATOR |
| FTPT_IMR_SEATS | RUNNING_NB_PSGR | FTPT_IMR_SEATS | RUNNING_NB_PSGR | FTPT_IMR_NAMES | IMR : Name | AIR_NUMBER |
| FTPT_IMR_SEATS | RUNNING_NB_PSGR | FTPT_IMR_SEATS | MANDT | FTPT_IMR_NAMES | IMR : Name | .INCLUDE |
| FTPT_IMR_SEATS | RUNNING_NB_PSGR | FTPT_IMR_SEATS | RECORD_LOCATOR | FTPT_IMR_NAMES | IMR : Name | MANDT |
