cds_with_session_variable

DDL: CDS_WITH_SESSION_VARIABLE SQL: CDSFRWK_DEMO_16 Type: view

cds having session variable

cds_with_session_variable is a CDS View that provides data about "cds having session variable" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 11 fields with key fields carrid, connid, fldate.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName CDSFRWK_DEMO_16 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label cds having session variable view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY carrid sflight carrid
KEY connid sflight connid
KEY fldate sflight fldate
currency sflight currency
planetype sflight planetype
seatsmax sflight seatsmax
seatsocc sflight seatsocc
lang
usr
user_date
daysToFly 
@AbapCatalog.sqlViewName: 'CDSFRWK_DEMO_16'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'cds having session variable'

define view cds_with_session_variable as select from sflight
{
  key sflight.carrid,
  key sflight.connid,
  key sflight.fldate,
      sflight.currency,
      sflight.planetype,
      sflight.seatsmax,
      sflight.seatsocc,
      $session.client   as session_client, 
      $session.system_language as lang,
      $session.user as usr,
      $session.user_date         as user_date, 
      $session.user_timezone     as user_timezone, 
      dats_days_between(cast(sflight.fldate as abap.dats), cast($session.system_date as abap.dats) ) as daysToFly
 }

Learn More