SAP ABAP Table CRMS_UIF_TRAVEL_FLIGHT_DB_3 (Structure to store SFLIGHT)
Hierarchy
☛
WEBCUIF (Software Component) SAP Web UI Framework
⤷
CA-WUI (Application Component) WebClient UI
⤷
BSP_DYN_CONFIG_TAG_LIB_APP_IL (Package) CRM UI Framework Test Application GENIL
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | CRMS_UIF_TRAVEL_FLIGHT_DB_3 |
|
| Short Description | Structure to store SFLIGHT |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
0 | 0 | Flight | |||||
| 2 | |
S_MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 3 | |
S_CARR_ID | S_CARR_ID | CHAR | 3 | 0 | Airline Code | SCARR | |
| 4 | |
S_CONN_ID | S_CONN_ID | NUMC | 4 | 0 | Flight Connection Number | SPFLI | |
| 5 | |
S_DATE | S_DATE | DATS | 8 | 0 | Flight date | * | |
| 6 | |
S_PRICE | S_PRICE | CURR | 15 | 2 | Airfare | ||
| 7 | |
S_CURRCODE | S_CURR | CUKY | 5 | 0 | Local currency of airline | SCURX | |
| 8 | |
S_PLANETYE | S_PLANE | CHAR | 10 | 0 | Aircraft Type | SAPLANE | |
| 9 | |
S_SEATSMAX | S_SEATS | INT4 | 10 | 0 | Maximum capacity in economy class | ||
| 10 | |
S_SEATSOCC | S_SEATS | INT4 | 10 | 0 | Occupied seats in economy class | ||
| 11 | |
S_SUM | S_SUM | CURR | 17 | 2 | Total of current bookings | ||
| 12 | |
S_SMAX_B | S_SEATS | INT4 | 10 | 0 | Maximum capacity in business class | ||
| 13 | |
S_SOCC_B | S_SEATS | INT4 | 10 | 0 | Occupied seats in business class | ||
| 14 | |
S_SMAX_F | S_SEATS | INT4 | 10 | 0 | Maximum capacity in first class | ||
| 15 | |
S_SOCC_F | S_SEATS | INT4 | 10 | 0 | Occupied seats in first class |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | CRMS_UIF_TRAVEL_FLIGHT_DB_3 | CARRID | |
|
|||
| 2 | CRMS_UIF_TRAVEL_FLIGHT_DB_3 | CONNID | |
|
KEY | 1 | CN |
| 3 | CRMS_UIF_TRAVEL_FLIGHT_DB_3 | CURRENCY | |
|
REF | 1 | N |
| 4 | CRMS_UIF_TRAVEL_FLIGHT_DB_3 | MANDT | |
|
KEY | 1 | CN |
| 5 | CRMS_UIF_TRAVEL_FLIGHT_DB_3 | PLANETYPE | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |