Skip to Content
0
Sep 19, 2017 at 04:09 PM

Is it possible to design a graphical interface for a user-defined query?

84 Views

Dear community,

I have created the following query:

SELECT SUM(Debit), Project FROM BTF1 WHERE
(Account LIKE '68%' OR Account LIKE '58%') AND
RefDate >= '2017.01.01' AND RefDate <= '2017.06.30' GROUP BY Project

Now I would like to design a graphical interface to collect input (namely the RefDate and the Account).

I tried making the input parametric (i.e. T0.[RefDate]>=[%0]): it does open a window to input data, but I would prefer an input window that executes the query after entering input and clicking a button, without opening the query.

Is it possible to do it in SAP B1?

Thanks a lot for the help.