ACMHEX_SPFLI

DDL: ACMHEX_SPFLI SQL: ACMHEXSV_SPFLI Type: view Package: SACMHIEREX
10 Fields 1 Data Sources 2 Associations

ACMHEX: Flight-Schedules (= Dimension-2: CONNID)

ACMHEX_SPFLI is a CDS View of category Dimension that provides data about "ACMHEX: Flight-Schedules (= Dimension-2: CONNID)" in SAP S/4HANA. It reads from 1 data source (acmhexdb_spfli) and exposes 10 fields with key fields carrid, connid. It has 2 associations to related views. Part of development package SACMHIEREX.

Data Sources (1)

SourceAliasJoin Type
acmhexdb_spfli acmhexdb_spfli from

Associations (2)

CardinalityTargetAliasCondition
[0..1] ACMHEX_HIERS4DIM2 _hiers4dim2 $projection.carrid = _hiers4dim2.carrier_id and $projection.connid = _hiers4dim2.connection_id
[0..1] ACMHEX_SCARR _scarr $projection.carrid = _scarr.carrid

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACMHEXSV_SPFLI view
EndUserText.label ACMHEX: Flight-Schedules (= Dimension-2: CONNID) view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY carrid acmhexdb_spfli carrid Carrier
KEY connid acmhexdb_spfli connid Flight Number
countryfr acmhexdb_spfli countryfr Departure Country/Region
cityfrom acmhexdb_spfli cityfrom Departure City
countryto acmhexdb_spfli countryto Destination Country/Region
cityto acmhexdb_spfli cityto Destination City
deptime acmhexdb_spfli deptime Departure Time
arrtime acmhexdb_spfli arrtime Arrival Time
_hiers4dim2 _hiers4dim2
_scarr _scarr

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ACMHEX_SPFLI.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ACMHEXSV_SPFLI

CREATE VIEW ACMHEX_SPFLI AS
SELECT
  acmhexdb_spfli.carrid AS carrid,
  acmhexdb_spfli.connid AS connid,
  acmhexdb_spfli.countryfr AS countryfr,
  acmhexdb_spfli.cityfrom AS cityfrom,
  acmhexdb_spfli.countryto AS countryto,
  acmhexdb_spfli.cityto AS cityto,
  acmhexdb_spfli.deptime AS deptime,
  acmhexdb_spfli.arrtime AS arrtime
FROM acmhexdb_spfli
LEFT OUTER JOIN ACMHEX_HIERS4DIM2 AS _hiers4dim2 ON carrid = _hiers4dim2.carrier_id AND connid = _hiers4dim2.connection_id  -- association [0..1]
LEFT OUTER JOIN ACMHEX_SCARR AS _scarr ON carrid = _scarr.carrid  -- association [0..1]
;

Learn More