/SAPQUERY/T100 - Flight
Flight information is stored in SAP table /SAPQUERY/T100.
It is part of development package /SAPQUERY/BC in software component BC-SRV-QUE. This development package consists of objects that can be grouped under "Feature Content for SAP Query".
It is part of development package /SAPQUERY/BC in software component BC-SRV-QUE. This development package consists of objects that can be grouped under "Feature Content for SAP Query".
Fields for table /SAPQUERY/T100
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
CARRID | Airline Code | X | /SAPQUERY/S_CARR_ID | CHAR | 6 | /SAPQUERY/TA00 |
CONNID | Flight Connection Number | X | /SAPQUERY/S_CONN_ID | NUMC | 8 | /SAPQUERY/T000 |
FLDATE | Flight date | X | /SAPQUERY/S_DATE | DATS | 16 | |
PRICE | Airfare | /SAPQUERY/S_PRICE | CURR | 8 | ||
CURRENCY | Local currency of airline | /SAPQUERY/S_CURRCODE | CUKY | 10 | * | |
PLANETYPE | Aircraft Type | /SAPQUERY/S_PLANETYE | CHAR | 20 | * | |
SEATSMAX | Maximum capacity in economy class | /SAPQUERY/S_SEATSMAX | INT4 | 4 | ||
SEATSOCC | Occupied seats in economy class | /SAPQUERY/S_SEATSOCC | INT4 | 4 | ||
PAYMENTSUM | Total of current bookings | /SAPQUERY/S_SUM | CURR | 9 | ||
SEATSMAX_B | Maximum capacity in business class | /SAPQUERY/S_SMAX_B | INT4 | 4 | ||
SEATSOCC_B | Occupied seats in business class | /SAPQUERY/S_SOCC_B | INT4 | 4 | ||
SEATSMAX_F | Maximum capacity in first class | /SAPQUERY/S_SMAX_F | INT4 | 4 | ||
SEATSOCC_F | Occupied seats in first class | /SAPQUERY/S_SOCC_F | INT4 | 4 |