/SAPQUERY/T200 - Single Flight Booking
Single Flight Booking information is stored in SAP table /SAPQUERY/T200.
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/T200
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 | /SAPQUERY/T100 |
| BOOKID | Booking number | X | /SAPQUERY/S_BOOK_ID | NUMC | 16 | |
| CUSTOMID | Customer Number | /SAPQUERY/S_CUSTOMER | NUMC | 16 | /SAPQUERY/TA02 | |
| CUSTTYPE | Customer type | /SAPQUERY/S_CUSTTYPE | CHAR | 2 | ||
| SMOKER | Smoker | /SAPQUERY/S_SMOKER | CHAR | 2 | ||
| LUGGWEIGHT | Weight of Luggage | /SAPQUERY/S_LUGWEIGH | QUAN | 5 | ||
| WUNIT | Weight Unit | /SAPQUERY/S_WEIUNIT | UNIT | 6 | T006 | |
| INVOICE | Invoice flag | /SAPQUERY/S_INVFLAG | CHAR | 2 | ||
| CLASS | Flight Class | /SAPQUERY/S_CLASS | CHAR | 2 | ||
| FORCURAM | Booking price in foreign currency (dependent on location) | /SAPQUERY/S_F_CUR_PR | CURR | 8 | ||
| FORCURKEY | Payment currency | /SAPQUERY/S_CURR | CUKY | 10 | * | |
| LOCCURAM | Price of booking in local currency of airline | /SAPQUERY/S_L_CUR_PR | CURR | 8 | ||
| LOCCURKEY | Local currency of airline | /SAPQUERY/S_CURRCODE | CUKY | 10 | * | |
| ORDER_DATE | Booking Date | /SAPQUERY/S_BDATE | DATS | 16 | ||
| COUNTER | Number of sales office | /SAPQUERY/S_COUNTNUM | NUMC | 16 | * | |
| AGENCYNUM | Travel Agency Number | /SAPQUERY/S_AGNCYNUM | NUMC | 16 | * | |
| CANCELLED | Cancelation flag | /SAPQUERY/S_CANCEL | CHAR | 2 | ||
| RESERVED | Reservation flag | /SAPQUERY/S_RESERV | CHAR | 2 | ||
| PASSNAME | Name of the Passenger | /SAPQUERY/S_PASSNAME | CHAR | 50 | ||
| PASSFORM | Form of address | /SAPQUERY/S_FORM | CHAR | 30 | ||
| PASSBIRTH | Date of Birth of a Passenger | /SAPQUERY/S_BIRTHDAT | DATS | 16 | * |