SFLTRIP - Flight trip
Flight trip information is stored in SAP table SFLTRIP.
It is part of development package SAPBC_TRAVELAGENCY_FLTRIP in software component BC-DWB-TND. This development package consists of objects that can be grouped under "Flight Data Model - Travel Agency - Flight Trip".
It is part of development package SAPBC_TRAVELAGENCY_FLTRIP in software component BC-DWB-TND. This development package consists of objects that can be grouped under "Flight Data Model - Travel Agency - Flight Trip".
Fields for table SFLTRIP
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | S_MANDT | CLNT | 3 | T000 |
| AGENCYNUM | Travel Agency Number | X | S_AGNCYNUM | NUMC | 8 | STRAVELAG |
| TRIPNUM | Flight trip number | X | S_TRNUM | NUMC | 8 | |
| CUSTOMID | Customer Number | S_CUSTOMER | NUMC | 8 | SCUSTOM | |
| FLCONN1 | Flight Connection Number of the Flight to Destination | S_FLCONN1 | NUMC | 4 | SFLCONN | |
| FLDATE1 | Date of Flight to Destination | S_FLDATE1 | DATS | 8 | * | |
| FLCONN2 | Return Flight Connection | S_FLCONN2 | NUMC | 4 | SFLCONN | |
| FLDATE2 | Return Flight Date | S_FLDATE2 | DATS | 8 | * | |
| CLASS | Flight Class | S_CLASS | CHAR | 1 | ||
| NUMADULT | Number of Passengers: Adults | S_NUMADULT | INT2 | 2 | ||
| NUMCHILD | Number of Passengers: Children | S_NUMCHILD | INT2 | 2 | ||
| NUMINFANT | Number of Passengers: Small Children | S_NUMINFNT | INT2 | 2 | ||
| TRIPPRICE | Trip price | S_TRPRICE | CURR | 8 | ||
| TRIPTAX | Tax | S_TRTAX | CURR | 8 | ||
| CURRENCY | Payment currency | S_CURR | CUKY | 5 | * | |
| ORDERDATE | Booking Date | S_BDATE | DATS | 8 | ||
| STATUS | Trip status | S_TRSTAT | CHAR | 1 |