DEMO_CDS_EXCEPT

DDL: DEMO_CDS_EXCEPT Type: view_entity

CDS view entity, set operator EXCEPT

DEMO_CDS_EXCEPT is a CDS View that provides data about "CDS view entity, set operator EXCEPT" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 6 fields.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view entity, set operator EXCEPT view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
carrid carrid
connid connid
price price
connid connid
price price
currency currency 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS view entity, set operator EXCEPT'
@Metadata.ignorePropagatedAnnotations: true

define view entity DEMO_CDS_EXCEPT
  as select from sflight
{
  carrid,
  connid,
  @Semantics.amount.currencyCode: 'currency'
  price,
  currency
}
where
  price < 2000

except

select from sflight
{
  carrid,
  connid,
  price,
  currency
}
where
  price between 600 and 900
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SFLIGHT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More