ACMHEX_SFLIGHT

DDL: ACMHEX_SFLIGHT SQL: ACMHEXSV_SFLIGHT Type: view Package: SACMHIEREX
14 Fields 1 Data Sources 2 Associations

ACMHEX: Flights (= Info-Cube / to-be-protected Entity)

ACMHEX_SFLIGHT is a CDS View that provides data about "ACMHEX: Flights (= Info-Cube / to-be-protected Entity)" in SAP S/4HANA. It reads from 1 data source (acmhexdb_sflight) and exposes 14 fields with key fields carrid, connid, fldate. It has 2 associations to related views. Part of development package SACMHIEREX.

Data Sources (1)

SourceAliasJoin Type
acmhexdb_sflight acmhexdb_sflight from

Associations (2)

CardinalityTargetAliasCondition
[0..1] ACMHEX_SCARR _scarr $projection.carrid = _scarr.carrid
[0..1] ACMHEX_SPFLI _spfli $projection.carrid = _spfli.carrid and $projection.connid = _spfli.connid

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName ACMHEXSV_SFLIGHT view
EndUserText.label ACMHEX: Flights (= Info-Cube / to-be-protected Entity) view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY carrid acmhexdb_sflight carrid Carrier
KEY connid acmhexdb_sflight connid Flight Number
KEY fldate acmhexdb_sflight fldate Flight Date
uuid acmhexdb_sflight uuid Waste Partner UUID
currency acmhexdb_sflight currency Valuation Crcy
planetype acmhexdb_sflight planetype Planetype
seatsmax acmhexdb_sflight seatsmax Max. Seats
seatsocc acmhexdb_sflight seatsocc Occupied Econ.
countryfr acmhexdb_sflight countryfr Departure Country/Region
cityfrom acmhexdb_sflight cityfrom Departure City
countryto acmhexdb_sflight countryto Destination Country/Region
cityto acmhexdb_sflight cityto Destination City
_scarr _scarr
_spfli _spfli

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_SFLIGHT.
-- 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_SFLIGHT

CREATE VIEW ACMHEX_SFLIGHT AS
SELECT
  acmhexdb_sflight.carrid AS carrid,
  acmhexdb_sflight.connid AS connid,
  acmhexdb_sflight.fldate AS fldate,
  acmhexdb_sflight.uuid AS uuid,
  acmhexdb_sflight.currency AS currency,
  acmhexdb_sflight.planetype AS planetype,
  acmhexdb_sflight.seatsmax AS seatsmax,
  acmhexdb_sflight.seatsocc AS seatsocc,
  acmhexdb_sflight.countryfr AS countryfr,
  acmhexdb_sflight.cityfrom AS cityfrom,
  acmhexdb_sflight.countryto AS countryto,
  acmhexdb_sflight.cityto AS cityto
FROM acmhexdb_sflight
LEFT OUTER JOIN ACMHEX_SCARR AS _scarr ON carrid = _scarr.carrid  -- association [0..1]
LEFT OUTER JOIN ACMHEX_SPFLI AS _spfli ON carrid = _spfli.carrid AND connid = _spfli.connid  -- association [0..1]
;

Learn More