SAP ABAP Table SFLTRIP (Flight trip)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DWB (Application Component) ABAP Workbench, Java IDE and Infrastructure
⤷
SAPBC_TRAVELAGENCY_FLTRIP (Package) Flight Data Model - Travel Agency - Flight Trip
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | SFLTRIP |
|
| Short Description | Flight trip |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
S_MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
S_AGNCYNUM | S_BUSPANUM | NUMC | 8 | 0 | Travel Agency Number | STRAVELAG | |
| 3 | |
S_TRNUM | S_TRNUM | NUMC | 8 | 0 | Flight trip number | ||
| 4 | |
S_CUSTOMER | S_BUSPANUM | NUMC | 8 | 0 | Customer Number | SCUSTOM | |
| 5 | |
S_FLCONN1 | S_FLCONN | NUMC | 4 | 0 | Flight Connection Number of the Flight to Destination | SFLCONN | |
| 6 | |
S_FLDATE1 | S_DATE | DATS | 8 | 0 | Date of Flight to Destination | * | |
| 7 | |
S_FLCONN2 | S_FLCONN | NUMC | 4 | 0 | Return Flight Connection | SFLCONN | |
| 8 | |
S_FLDATE2 | S_DATE | DATS | 8 | 0 | Return Flight Date | * | |
| 9 | |
S_CLASS | S_CLASS | CHAR | 1 | 0 | Flight Class | ||
| 10 | |
S_NUMADULT | S_NUMPASS | INT2 | 5 | 0 | Number of Passengers: Adults | ||
| 11 | |
S_NUMCHILD | S_NUMPASS | INT2 | 5 | 0 | Number of Passengers: Children | ||
| 12 | |
S_NUMINFNT | S_NUMPASS | INT2 | 5 | 0 | Number of Passengers: Small Children | ||
| 13 | |
S_TRPRICE | S_PRICE | CURR | 15 | 2 | Trip price | ||
| 14 | |
S_TRTAX | S_PRICE | CURR | 15 | 2 | Tax | ||
| 15 | |
S_CURR | S_CURR | CUKY | 5 | 0 | Payment currency | * | |
| 16 | |
S_BDATE | S_BDATE | DATS | 8 | 0 | Booking Date | ||
| 17 | |
S_TRSTAT | S_TRPSTAT | CHAR | 1 | 0 | Trip status |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | SFLTRIP | AGENCYNUM | |
|
|||
| 2 | SFLTRIP | CUSTOMID | |
|
KEY | 1 | CN |
| 3 | SFLTRIP | FLCONN1 | |
|
|||
| 4 | SFLTRIP | FLCONN2 | |
|
|||
| 5 | SFLTRIP | MANDT | |
|
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 610 |