Skip to Content
avatar image
Former Member

from...to boundary

Hi Experts,

I have the following problem:

I am trying to find out which tasks are accomplished in a specific period. In an R/3 table the data of different tasks are stored including the date of the task.

What I am trying is to get all tasks which are accomplished from f.e. 01/05/2006 to f.e. 31/05/2006.

Therefore I have added in an input form two Date Pickers (for "from" and for "to").

In order to get that list I think I have to go for dynamic expressions. I have already tried to use boolean expressions and operators like "<=" and ">=" but it didn´t work that way. But to be honest I am also not sure about the syntax for this specific scenario.

I would appreciate any idea. Perhaps anybody could give me an example of the syntax.

Thanks very much

Thomas

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    May 12, 2006 at 06:58 PM

    Let me see if I get it what u want.

    U want to get the data of tasks from a R/3 backend system in a determinated time.

    if so, u dont need to get involved with dinamic expression, u only have to make a function in R3 with attribute accesss remote (RFC).

    If the dates are input by the user, make two input parameters ( fromDate and toDate ) put the estructure of the table that u wanna output in the table tabs. If the dates r constants dont put any input parameters.

    And in the code, construct your SELECT in the WHERE put the dates ( input or constants) so u have in the table that u defined in Table tab the data that u need. Test it in R/3 and then u only have to use that RFC function in VC.

    if this solution works for u, but u have problems implementing the program let me know.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2006 at 09:18 AM

    Hi Rodrigo,

    Sorry for my late reply. That´s a very good idea. However I have also found another way of doing this. You can also do that by using SQL. I have found a document integrating SQL in VC with an example of filtering between 2 values.

    I think that is also a very interesting approach.

    Cheers

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2006 at 01:19 PM

    Hi Rodrigo,

    Here is the link to the document integrating SQL in Visual Composer:

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6339e7d4-0a01-0010-1c98-db00e52e989a

    Cheers

    Thomas

    Add comment
    10|10000 characters needed characters exceeded