SCARR
Airline
SCARR is an SAP database table in S/4HANA. Airline. It contains 5 fields. 46 CDS views read from this table.
CDS Views using this table (46)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| DEMO_CDS_AGGREGATES_VE | view_entity | from | ||
| demo_cds_assoc_element | view_entity | from | ||
| demo_cds_assoc_exposition | view_entity | from | ||
| demo_cds_assoc_scarr | view_entity | from | ||
| demo_cds_assoc_where | view_entity | from | ||
| demo_cds_auth_fullaccess | view_entity | from | ||
| demo_cds_auth_lit_pfcg | view | from | ||
| demo_cds_auth_pfcg | view | from | ||
| demo_cds_authority_inheriting | view | from | ||
| DEMO_CDS_AUTHORITY_LIT_PFCG_VE | view_entity | from | ||
| demo_cds_authority_literal_2 | view_entity | from | ||
| demo_cds_cast_clnt | view | from | ||
| DEMO_CDS_CAST_CLNT_VE | view_entity | from | ||
| DEMO_CDS_DATA_SOURCE | view_entity | inner | CDS view entity data source example | |
| DEMO_CDS_EXPLICIT_CARD_1 | view_entity | from | ||
| demo_cds_explicit_cardinality | view | from | ||
| DEMO_CDS_EXPOSE_ASSOC | view_entity | from | ||
| DEMO_CDS_EXPOSE_ASSOC_FILTER | view_entity | from | ||
| DEMO_CDS_EXPOSE_ASSOC_VE | view_entity | from | ||
| DEMO_CDS_FLIGHT_TREE_SOURCE | view | from | ||
| demo_cds_join1 | view | inner | ||
| DEMO_CDS_JOIN1_VE | view_entity | inner | ||
| DEMO_CDS_PARAM_VE | view_entity | from | ||
| DEMO_CDS_SCARR_ENTITY | view_entity | from | ||
| DEMO_CDS_SCARR_FROM_ABAP_CLASS | view_entity | from | ||
| DEMO_CDS_SCARR_VE | view_entity | from | CDS view entity that selects from scarr | |
| DEMO_CDS_SINGLE_BUFFERED_VIEW | view_entity | from | ||
| demo_cds_sumdist | view | from | ||
| DEMO_CDS_WITH_DCL_PFCG_2 | view | from | CDS based on DCL with PFCG | |
| demo_cds_wrong_cardinality | view | from | ||
| DEMO_CDS_WRONG_CARDINALITY_1 | view_entity | from | ||
| demo_cds_wrong_to_one_1 | view | from | ||
| DEMO_CDS_WRONG_TO_ONE_1_VE | view_entity | from | CDS view entity with join expression | |
| demo_cds_wrong_to_one_2 | view | from | ||
| DEMO_CDS_WRONG_TO_ONE_2_VE | view_entity | from | CDS view entity with join expression | |
| demo_cds_wrong_to_one_3 | view | from | ||
| DEMO_CDS_WRONG_TO_ONE_3_VE | view_entity | from | CDS view entity with join expression | |
| DEMO_SPFLI_PROJECTION_V1 | view | from | ||
| Fdt_Test_Carr_Cds | view | from | Carrier | |
| FINKET_S_SFLIGHT_19 | view | left_outer | Flight Test1 | |
| FPMT_AIRLINE | view | from | Airline | |
| P_SadlCdsBaseMock | view | from | ||
| S_Carrier | view | from | Flight Carriers | |
| SADL_AUNITRoot | view | from | RESTful ABAP: CDS for Testing (Root) | |
| SADL_SB_AUNIT_SCARR | view | from | ||
| SADL_V_ExpVoc_Airline | view | from | Airline |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Airline
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCARR (
MANDT, -- Client [S_MANDT]
CARRID, -- Airline [S_CARR_ID]
CARRNAME, -- Airline [S_CARRNAME]
CURRCODE, -- Airline Currency [S_CURRCODE]
URL, -- URL [S_CARRURL]
PRIMARY KEY (MANDT, CARRID)
);
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