Skip to Content

How to select rows with due date between selected period

Hi Experts,

I'm making a query on 0FIAR_C03 infosite

The requirement that they ask me is that when we have 0FISCPER and Posting Date in lines we could know the amount with 'Due date for net payment' (0NETDUEDATE) less than selected period.

For example, if we select the 0FISCPER 'FEB 2017', 'MAR 2017' and 'APR 2017' then the query should show item with 'Due Date' less than 30.04.2017.

Can anybody help me?

Thanks in advance.

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 10, 2017 at 12:36 PM

    search the world wide web with 'bex query bucket'

    Add comment
    10|10000 characters needed characters exceeded

  • May 10, 2017 at 01:48 PM

    Thanks for your help, I tink this is what I was looking for.

    But In my case one of the dates has to be the last day of the selected period.

    In my previous example,... the selected period was 'Feb 2017' - 'Apr 2017', how can I know which is the last day of 'Apr 2017' period?

    The subtract between that date and the Due Date are the days I need.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • May 11, 2017 at 04:46 AM

    0FISCPER has attribute 0DATETO. You can create a variable with type "replacement path" and fill it from your variable on 0fiscper.

    Add comment
    10|10000 characters needed characters exceeded