topic Calculated field - CDS in Application Development and Automation Discussions

Calculated field - CDS

f_allocca — Fri, 10 Mar 2023 11:08:33 GMT

Hi Experts,

I'm using the CDS in hana studio, I need to have in final report a custom field ZFIELD like this:

IF budat => sy-datum AND budat =< (sy-datum + 30). ZFIELD = '+30D'

ELSEIF budat < sy-datum AND budat => (sy-datum - 30). ZFIELD = '-30D'

How can I have?

Thanks

Re: Calculated field - CDS

former_member128578 — Fri, 10 Mar 2023 12:38:54 GMT

Hello

have an look at https://4js.com/techdocs/fjs-fgl-manual/index.html#fgl-topics/c_fgl_odiaghdb_005.html

regards

Christian Fritsch

Re: Calculated field - CDS

fedaros — Sat, 11 Mar 2023 10:53:20 GMT

Hi Francesco,

HANA CDS native ? Long time no see... In general documentation with syntax point to same behavior

https://help.sap.com/docs/SAP_HANA_PLATFORM/b3d0daf2a98e49ada00bf31b7ca7a42e/de9843e69bd14989b8a592cf3e6c95d7.html

I didn't tested in CDS but I guess you can figure out with SQL sample below. Ignore the dummy party to create fake data and focus on zfield:

select *,
      case when budat >= current_date and budat <= (add_days(current_date,+30)) then '+30D'
           when budat <  current_date and budat >= (add_days(current_date,-30)) then '-30D'
           else ''
      end                                     as zfield
from 
(select current_date from dummy),
(select '20230305' as budat from dummy union
select '20230310' as budat from dummy union
select '20230311' as budat from dummy union
select '20230312' as budat from dummy union
select '20230315' as budat from dummy);

Result:

Regards, Fernando Da Rós