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