CONNID in SBOOK
Flight Number (DE: Flugnummer)
CONNID is a field in SAP table SBOOK (Einzelflugbuchung). It represents "Flight Number". Data element: S_CONN_ID. Available in 13 CDS view(s) as connid, ConnectionNumber, ConnectionId.
Business Meaning
| Description (EN) | Flight Number |
|---|---|
| Beschreibung (DE) | Flugnummer |
| Data Element | S_CONN_ID |
| Key Field | Yes |
CDS Views & Technical Names (13)
SBOOK.CONNID is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
connid
(7 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Fdt_Test_Book_Cds | direct | BOOK CDS | ||
| Fdt_Test_Book_P1_Cds | direct | Book with connid parameter | ||
| Fdt_Test_Book_P2_Cds | direct | Book with connid and carrid parameters | ||
| Fdt_Test_Book_P3_Cds | direct | Book with connid and smoker (as boolean) parameters | ||
| sadl_v_cds_view | direct | |||
| Sadl_V_Expvoc_Booking | direct | Integration Test CDS View | ||
| Salv_Ida_Test_Sbook_X_Sbook | direct | SALV IDA Test CDS view for Cartesian Product |
ConnectionNumber
(5 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| FPMT_BOOKING | direct | Flight Booking | ||
| FPMT_BOOKING_CUBE | via 2 level | CONSUMPTION | Flight Booking Cube | |
| FPMT_BOOKING_QUERY_1 | via 3 levels | Flight Booking Query - without Variables | ||
| FPMT_BOOKING_QUERY_2 | via 3 levels | Flight Booking Query with Variable | ||
| FPMT_BOOKING_QUERY_3 | via 3 levels | Flight Booking Query |
ConnectionId
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| S_Bookings | direct | Flight Bookings |
connid2
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Salv_Ida_Test_Sbook_X_Sbook | direct | SALV IDA Test CDS view for Cartesian Product |
Other Tables with Field CONNID (12)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ACMHEXDB_SFLIGHT | ACMHEX_CONN_ID | KEY | ACMHEX: Flights (DBTable) |
| ACMHEXDB_SPFLI | ACMHEX_CONN_ID | KEY | ACMHEX: Flight Schedules (DBTable) |
| DAAG_SBOOK | S_CONN_ID | KEY | Einzelflugbuchung |
| DAAG_SFLIGHT | S_CONN_ID | KEY | Flug |
| SCI_TST_SFLIGHT1 | ABAP.NUMC | KEY | Test / Flug |
| SDSHSFLIGHT | S_CONN_ID | KEY | Flug |
| SFLIGHT | S_CONN_ID | KEY | Flug |
| SIT2_DEMO_BOOK | SIT2_DEMO_CONNECTION_ID | KEY | Situation Demo Booking |
| SIT2_DEMO_CONN | S_CONN_ID | KEY | Situation Demo Connections |
| SIT2_DEMO_FLIGHT | SIT2_DEMO_CONNECTION_ID | KEY | Situation Demo Flights |
| SPFLI | S_CONN_ID | KEY | Flugplan |
| STICKET | S_CONN_ID | KEY | Flugticket |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA