CDS_TDAI_TEST_GEN_MUL_EXPR

DDL: CDS_TDAI_TEST_GEN_MUL_EXPR Type: view_entity
8 Fields 2 Data Sources

CDS for test generation using AI demo

CDS_TDAI_TEST_GEN_MUL_EXPR is a CDS View that provides data about "CDS for test generation using AI demo" in SAP S/4HANA. It reads from 2 data sources (carriers, sflight) and exposes 8 fields with key fields carrid, connid, fldate.

Data Sources (2)

SourceAliasJoin Type
carriers _carrier_data inner
sflight flight from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS for test generation using AI demo view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY carrid sflight carrid Carrier
KEY connid sflight connid Flight Number
KEY fldate sflight fldate Flight Date
currency sflight currency Valuation Crcy
planetype sflight planetype Planetype
seatsocc sflight seatsocc Occupied Econ.
payment_sum
dec1521004endasGST_tax

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

CREATE VIEW CDS_TDAI_TEST_GEN_MUL_EXPR AS
SELECT
  flight.carrid AS carrid,
  flight.connid AS connid,
  flight.fldate AS fldate,
  flight.currency AS currency,
  flight.planetype AS planetype,
  flight.seatsocc AS seatsocc,
  cast( flight.paymentsum as abap.dec( 15, 2 ) ) AS payment_sum,
  case _carrier_data.carrname when 'LUFTHANSA' then division( 5 * cast( flight.price as abap.dec( 15, 2 ) ), 100 , 4 ) else division( 2 * cast( flight.price as abap.dec( 15, 2 ) ), 100 , 4 ) end as GST_tax AS dec1521004endasGST_tax
FROM sflight AS flight
INNER JOIN carriers AS _carrier_data ON /* join condition not captured in parsed metadata */
;

Learn More