CDS Views: Session variable and Data Manipulation
Session variable: The variables which are assigned at runtime. LTRIM() : Used to remove the 0's before manterial number. @AbapCatalog.sqlViewName: 'ZVB_CDS_SESSION' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'Session variable' define view ZAB_SESSION_VAR as select from ekpo { ebeln , ebelp , aedat , ltrim ( matnr , '0' ) as mat_no , case when statu = 'V' then 'Created via SO' end as status , case bukrs when '0003' then 'Template for cmp' end as compnay_code netpr as net_price , ( netpr - 10 ) as price }where bukrs = '0003' and aedat < $session.system_date