SAP ABAP View SFLCONN2 (Flight Connection Information for Flight BAPIs)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DWB (Application Component) ABAP Workbench, Java IDE and Infrastructure
⤷ SAPBC_IBF_SFLCONN (Package) FlightConnection BO and BAPIs (Demo Only)
⤷ BC-DWB (Application Component) ABAP Workbench, Java IDE and Infrastructure
⤷ SAPBC_IBF_SFLCONN (Package) FlightConnection BO and BAPIs (Demo Only)
Basic Data
View Type | D | Database View |
Database View | SFLCONN2 | |
Short Description | Flight Connection Information for Flight BAPIs | |
Root table | SFLCONN | Flight connection offered by travel agency |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | SFLCONN | SFLCONN | ||
2 | SFLCONNPOS | |||
3 | SFLIGHT |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | SFLCONN | MANDT | JL | EQ | 0 | 0 | ||||
2 | SFLCONNPOS | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | SFLCONN | AGENCYNUM | JL | EQ | 0 | 0 | ||||
4 | SFLCONNPOS | AGENCYNUM | JR | EQ | AND | 0 | 0 | |||
5 | SFLCONN | FLCONN | JL | EQ | 0 | 0 | ||||
6 | SFLCONNPOS | FLCONN | JR | EQ | AND | 0 | 0 | |||
7 | SFLIGHT | MANDT | JL | EQ | 0 | 0 | ||||
8 | SFLCONNPOS | MANDT | JR | EQ | AND | 0 | 0 | |||
9 | SFLIGHT | CARRID | JL | EQ | 0 | 0 | ||||
10 | SFLCONNPOS | CARRID | JR | EQ | AND | 0 | 0 | |||
11 | SFLIGHT | CONNID | JL | EQ | 0 | 0 | ||||
12 | SFLCONNPOS | CONNID | JR | EQ | AND | 0 | 0 | |||
13 | SFLCONNPOS | HOP | EQ | '1' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | SFLCONN | MANDT | S_MANDT | Client | |||
2 | AGENCYNUM | SFLCONN | AGENCYNUM | S_AGNCYNUM | Travel Agency Number | |||
3 | FLCONN | SFLCONN | FLCONN | S_FLCONN | Flight connection number at travel agency | |||
4 | COUNTRYFR | SFLCONN | COUNTRYFR | LAND1 | Country Key | |||
5 | CITYFROM | SFLCONN | CITYFROM | S_FROM_CIT | Departure city | |||
6 | AIRPFROM | SFLCONN | AIRPFROM | S_FROMAIRP | Departure airport | |||
7 | COUNTRYTO | SFLCONN | COUNTRYTO | LAND1 | Country Key | |||
8 | CITYTO | SFLCONN | CITYTO | S_TO_CITY | Arrival city | |||
9 | AIRPTO | SFLCONN | AIRPTO | S_TOAIRP | Destination airport | |||
10 | FLTIME | SFLCONN | FLTIME | S_FLTIME | Flight time | |||
11 | DEPTIME | SFLCONN | DEPTIME | S_DEP_TIME | Departure time | |||
12 | ARRTIME | SFLCONN | ARRTIME | S_ARR_TIME | Arrival time | |||
13 | DISTANCE | SFLCONN | DISTANCE | S_DISTANCE | Distance | |||
14 | DISTID | SFLCONN | DISTID | S_DISTID | Mass unit of distance (kms, miles) | |||
15 | PERIOD | SFLCONN | PERIOD | S_PERIOD | Arrival n day(s) later | |||
16 | HOP | SFLCONNPOS | HOP | S_HOP | Number of Route Segment | |||
17 | CARRID | SFLCONNPOS | CARRID | S_CARR_ID | Airline Code | |||
18 | CONNID | SFLCONNPOS | CONNID | S_CONN_ID | Flight Connection Number | |||
19 | FLDATE | SFLIGHT | FLDATE | S_DATE | Flight date | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 610 |