CdsFrwk_Spcl_Functions

DDL: CDS_WITH_SPCL_FUNCTIONS SQL: CdsFrwk_DEMO_13 Type: view Package: SABP_UNIT_DOUBLE_CDS_DEMO
2 Fields 2 Data Sources

cds having currency and unit conversion

CdsFrwk_Spcl_Functions is a CDS View that provides data about "cds having currency and unit conversion" in SAP S/4HANA. It reads from 2 data sources (sflight, spfli) and exposes 2 fields. Part of development package SABP_UNIT_DOUBLE_CDS_DEMO.

Data Sources (2)

SourceAliasJoin Type
sflight sflight from
spfli spfli inner

Parameters (1)

NameTypeDefault
to_currency abap.cuky( 5 )

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName CdsFrwk_DEMO_13 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label cds having currency and unit conversion view

Fields (2)

KeyFieldSource TableSource FieldDescription
amount sflight price RVP f.PricePro.
distance spfli distance Travel Distance

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 CdsFrwk_Spcl_Functions.
-- 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: CdsFrwk_DEMO_13
-- Parameters: to_currency : abap.cuky( 5 )

CREATE VIEW CdsFrwk_Spcl_Functions AS
SELECT
  sflight.price AS amount,
  spfli.distance AS distance
FROM sflight
INNER JOIN spfli ON /* join condition not captured in parsed metadata */
;

Learn More