SAP ABAP Table AUDDD_SFLIGHT (TO (don't use/change it): Flight)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DWB-DIC-ED (Application Component) Dictionary Maintenance
⤷
SEDD_AU_TEST (Package) Test objects for ABAP Unit Tests in Dictionary -don't change
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | AUDDD_SFLIGHT |
|
| Short Description | TO (don't use/change it): Flight |
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_CARR_ID | S_CARR_ID | CHAR | 3 | 0 | Airline Code | SCARR | |
| 3 | |
S_CONN_ID | S_CONN_ID | NUMC | 4 | 0 | Flight Connection Number | SPFLI | |
| 4 | |
S_DATE | S_DATE | DATS | 8 | 0 | Flight date | * | |
| 5 | |
S_PRICE | S_PRICE | CURR | 15 | 2 | Airfare | ||
| 6 | |
S_CURRCODE | S_CURR | CUKY | 5 | 0 | Local currency of airline | SCURX | |
| 7 | |
S_PLANETYE | S_PLANE | CHAR | 10 | 0 | Aircraft Type | SAPLANE | |
| 8 | |
S_SEATSMAX | S_SEATS | INT4 | 10 | 0 | Maximum capacity in economy class | ||
| 9 | |
S_SEATSOCC | S_SEATS | INT4 | 10 | 0 | Occupied seats in economy class | ||
| 10 | |
S_SUM | S_SUM | CURR | 17 | 2 | Total of current bookings | ||
| 11 | |
S_SMAX_B | S_SEATS | INT4 | 10 | 0 | Maximum capacity in business class | ||
| 12 | |
S_SOCC_B | S_SEATS | INT4 | 10 | 0 | Occupied seats in business class | ||
| 13 | |
S_SMAX_F | S_SEATS | INT4 | 10 | 0 | Maximum capacity in first class | ||
| 14 | |
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 | AUDDD_SFLIGHT | CARRID | |
|
|||
| 2 | AUDDD_SFLIGHT | CONNID | |
|
KEY | 1 | CN |
| 3 | AUDDD_SFLIGHT | CURRENCY | |
|
REF | 1 | N |
| 4 | AUDDD_SFLIGHT | MANDT | |
|
KEY | 1 | CN |
| 5 | AUDDD_SFLIGHT | PLANETYPE | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 712 |