Question Re: @Consumption.filter.defaultValue using system date in Technology Q&A

@Consumption.filter.defaultValue using system date

panda_tom — Tue, 09 Nov 2021 11:11:09 GMT

Dears

I created a filter field and I want it to display the system date by default，

I tried to use @Consumption.defaultValue but it does not seem to support system variables

eg. @Consumption.defaultValue#SYSTEM_DATE

I tried to define the parameter and use @Environment.systemField: #SYSTEM_DATE, but the system date is still not displayed in the filter field

What should I do to solve this problem

Re: @Consumption.filter.defaultValue using system date

panda_tom — Tue, 09 Nov 2021 11:15:29 GMT

capture2.png capture.png

Re: @Consumption.filter.defaultValue using system date

hajduk — Fri, 02 Feb 2024 18:57:18 GMT

It is two years later, but maybe it helps someone else. Today I was looking for a solution to a similar problem and couldn't find it. By the end of the day I was able to write my own solution. I was looking how can i use dynamic interval of 2 dates as default filter value. This is my solution.

@analytics.query:true
define view ZI_TESTDATE_02
as select from ZI_TESTDATE_01
{
key SalesOrder,
@Consumption.filter: {selectionType: #INTERVAL, multipleSelections: false, mandatory: true}
@Consumption.derivation.lookupEntity: 'scal_tt_date'
@Consumption.derivation.resultElement: 'firstdayofmonthdate
@Consumption.derivation.resultElementHigh: 'lastdayofmonthdate'
@Consumption.derivation.binding: [{targetElement: 'calendardate', type: #SYSTEM_FIELD, value: '#SYSTEM_DATE'}]
TestDate
}

Or for single date this one.

@Consumption.filter: {selectionType: #INTERVAL, multipleSelections: false, mandatory: true}
@Consumption.derivation.lookupEntity: 'scal_tt_date'
@Consumption.derivation.resultElement: 'calendardate'
@Consumption.derivation.binding: [{targetElement: 'calendardate', type: #SYSTEM_FIELD, value: '#SYSTEM_DATE'}]
TestDate

I hope it helps someone. Cheers,

Re: @Consumption.filter.defaultValue using system date

SuryaRamesh — Thu, 26 Jun 2025 19:24:13 GMT

This is also not working

Re: @Consumption.filter.defaultValue using system date

hajduk — Fri, 27 Jun 2025 06:18:46 GMT

Parameter hidden with deriviation

with parameters

@Consumption:{

hidden: true,

derivation:{

lookupEntity: 'ZI_DATE_BUCKET',

resultElement: 'TodayDate'

}

@EndUserText.label: 'Start Date'

p_start_date : abap.dats,

End in zi_date_bucket.

key CalendarDate,

$session.system_date as TodayDate,

dats_add_days(CalendarDate, -1, 'UNCHANGED') as PreviousDay,

Like this is start date hidden and equals today

And example of Filter with derivation

@Consumption: {

filter: {

selectionType: #INTERVAL,

multipleSelections: false,

mandatory: false

derivation: {

lookupEntity: 'ZI_DATE_BUCKET',

resultElement: 'DateMinus14Days',

resultElementHigh: 'PreviousDay',

binding: [{targetElement: 'CalendarDate', type: #SYSTEM_FIELD, value: '#SYSTEM_DATE'}]

}

DeliveryDate,

And in zi_date_bucket

key CalendarDate,

$session.system_date as TodayDate,

dats_add_days(CalendarDate, -1, 'UNCHANGED') as PreviousDay,

dats_add_days(CalendarDate, 21, 'UNCHANGED') as DatePlus21Days,

dats_add_days(CalendarDate, -7, 'UNCHANGED') as DateMinus7Days ,

dats_add_days(CalendarDate, -14, 'UNCHANGED') as DateMinus14Days,

And then