sadl_sb_aunit_ddic_assoc

DDL: SADL_SB_AUNIT_DDIC_ASSOC SQL: VSADLSB_AU_DDICA Type: view
9 Fields 1 Data Sources

sadl_sb_aunit_ddic_assoc is a CDS View in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 9 fields with key field id.

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName VSADLSB_AU_DDICA view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY id carrid Carrier
mandt
carrid sflight carrid Carrier
connid sflight connid Flight Number
charge sflight price RVP f.PricePro.
currency sflight currency Valuation Crcy
planetype sflight planetype Planetype
seatsmax sflight seatsmax Max. Seats
plane plane

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 sadl_sb_aunit_ddic_assoc.
-- 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: VSADLSB_AU_DDICA

CREATE VIEW sadl_sb_aunit_ddic_assoc AS
SELECT
  carrid AS id,
  sflight.carrid AS carrid,
  sflight.connid AS connid,
  sflight.price AS charge,
  sflight.currency AS currency,
  sflight.planetype AS planetype,
  sflight.seatsmax AS seatsmax,
  plane
FROM sflight
;

Learn More