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
⤷ 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 | Table Relationship Diagram |
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 | MANDT | S_MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | AGENCYNUM | S_AGNCYNUM | S_BUSPANUM | NUMC | 8 | 0 | Travel Agency Number | STRAVELAG | |
3 | TRIPNUM | S_TRNUM | S_TRNUM | NUMC | 8 | 0 | Flight trip number | ||
4 | CUSTOMID | S_CUSTOMER | S_BUSPANUM | NUMC | 8 | 0 | Customer Number | SCUSTOM | |
5 | FLCONN1 | S_FLCONN1 | S_FLCONN | NUMC | 4 | 0 | Flight Connection Number of the Flight to Destination | SFLCONN | |
6 | FLDATE1 | S_FLDATE1 | S_DATE | DATS | 8 | 0 | Date of Flight to Destination | * | |
7 | FLCONN2 | S_FLCONN2 | S_FLCONN | NUMC | 4 | 0 | Return Flight Connection | SFLCONN | |
8 | FLDATE2 | S_FLDATE2 | S_DATE | DATS | 8 | 0 | Return Flight Date | * | |
9 | CLASS | S_CLASS | S_CLASS | CHAR | 1 | 0 | Flight Class | ||
10 | NUMADULT | S_NUMADULT | S_NUMPASS | INT2 | 5 | 0 | Number of Passengers: Adults | ||
11 | NUMCHILD | S_NUMCHILD | S_NUMPASS | INT2 | 5 | 0 | Number of Passengers: Children | ||
12 | NUMINFANT | S_NUMINFNT | S_NUMPASS | INT2 | 5 | 0 | Number of Passengers: Small Children | ||
13 | TRIPPRICE | S_TRPRICE | S_PRICE | CURR | 15 | 2 | Trip price | ||
14 | TRIPTAX | S_TRTAX | S_PRICE | CURR | 15 | 2 | Tax | ||
15 | CURRENCY | S_CURR | S_CURR | CUKY | 5 | 0 | Payment currency | * | |
16 | ORDERDATE | S_BDATE | S_BDATE | DATS | 8 | 0 | Booking Date | ||
17 | STATUS | 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 | STRAVELAG | AGENCYNUM | |||
2 | SFLTRIP | CUSTOMID | SCUSTOM | ID | KEY | 1 | CN |
3 | SFLTRIP | FLCONN1 | SFLCONN | FLCONN | |||
4 | SFLTRIP | FLCONN2 | SFLCONN | FLCONN | |||
5 | SFLTRIP | MANDT | T000 | MANDT |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 610 |