topic Re: Custom selection values for query in Application Development and Automation Discussions

Custom selection values for query

nibiklavic — Thu, 21 Feb 2019 09:43:10 GMT

Hello together,

is it possible to fill the time range for a SQ01 seleciton screen with coding in SQ02?

The selection I need is not available in standart variant customization. I need to select LIKP-ERZET values from SYUZEIT-30min until SYUZEIT.

I tried :

SP$00002-LOW = sy-uzeit - 60

SP$00002-HIGH = sy-uzeit

in the SQ02 Coding/Initialization Page.

But since I have no experience in ABAP, this code is obviously not working.

Thanks in advance and best regards

Niklas

Re: Custom selection values for query

Former Member — Thu, 21 Feb 2019 10:24:06 GMT

Hi Niklas,

If you want to remove 30 min from the current time, try this:

data lv_30min_less type syst-uzeit.
data lv_30min type syst-uzeit value '003000'.

lv_30min_less = sy-uzeit - lv_30min.

I hope it helps.

Cheers,

Rafael

Re: Custom selection values for query

nibiklavic — Thu, 21 Feb 2019 12:26:45 GMT

Hello Rafael,

thanks for your input. But how can I pass this value to my selection field?

SP$00002-LOW =.... is not working

Regards

Niklas

Re: Custom selection values for query

Former Member — Fri, 22 Feb 2019 10:52:46 GMT

Hi Niklas

To do that, the field should be on the selection screen, and I don't think those fields are assigned in the Initialization section. I have an example that works is the Start-of-selection:

ranges my_opt for kna1-kunnr.
field-symbols <scr_opt> type standard table.

assign ('SP$00001[]') to <scr_opt>.
my_opt-sign = 'I'.
my_opt-option = 'EQ'.
my_opt-low = '0001026868'.
my_opt-high = ''.

append my_opt to <scr_opt>.

Regards,

Rafael