cancel
Showing results for 
Search instead for 
Did you mean: 

BEx query filter based on date - BW 70

0 Kudos

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:

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Follow the pictures: