Skip to Content
0
Jun 08, 2020 at 08:57 PM

Clone of DEMO_CDS_DATE_TIME does not return rows

114 Views Last edit Jun 08, 2020 at 08:59 PM 3 rev

Dear Community,

My question is related to demo content. When I do a data preview on DEMO_CDS_DATE_TIME from the SAPBAPDEMOS package. I can view the data in the data preview. I see the date and time.

I copied the code into a custom CDS view. I try to do a data preview and do not see the data. Here is my CDS view.

@AbapCatalog.sqlViewName: 'Z_SYSTEM_DATE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Get Current Date ( System Date )'
define view Z_CURRENT_DATE 
 as select from z_expressions {  
    substring( cast( tstmp_current_utctimestamp() 
      as abap.char(17) ), 1, 8 ) as dat, 
    substring( cast( tstmp_current_utctimestamp() 
      as abap.char(17) ), 9, 6 ) as tim }

Please let me know why the dat and tim are not displayed.

System Version Information: SAP Netweaver 7.50 SP Level 0007

Thank You,

Sai