Skip to Content

BEx query filter based on date - BW 70

Good afternoon,

I need to filter the intervals of date.

The user has to inform the parameter on screen and the systems must bring back only the records that match with the parameter informed.

For instance:

Parameter screen:

Date: 10.12.2016

Material: 000000000000737830

Plant: C003

Correct Result:

Start date End date Kbetr

17.06.2016 02.03.2017 11,90

06.05.2016 31.12.9999 15,39

12.05.2016 31.12.9999 9,67

Things that I tried, but didn´t work:

  • I already created the Formula to use with Parameter Screen (var_data_formula_002)
  • I created the BEx Condition with two rules:
  • Start Date LE var_data_formula_002
  • End Date GE var-data_formula_002
  • I created the two new Key-Figure (start and end date) and used on BEx Condition

Note:

I read the very goods post, but – as I said – for me didn´t work

https://archive.sap.com/discussions/thread/3751737

https://blogs.sap.com/2012/04/29/convert-a-characteristic-into-a-key-figure-bex/

Thanks very much,

Screens:

Condition:

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 03, 2017 at 10:22 AM

    Follow the pictures:

    Add comment
    10|10000 characters needed characters exceeded