Skip to Content
0

As on Date in BEX

Aug 08, 2017 at 11:23 AM

42

avatar image
Former Member

Hi Experts,

Please guide me to create a date field in bex as on date ..as currently report has start date and end date(Fiscal Period) but user wants only one date should be there and it extract data from the start..
for example A company has been created on 2002 then if i run the query today it will get the data from 2002 till today.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Aug 08, 2017 at 12:35 PM
0

so I guess you have range filter set on your fiscal period (from - to). as for FROMyou can set a input ready variable and for TO you can set a sap standard variable current fiscal period.

https://help.sap.com/viewer/6da591e86c4b1014b43de329b9ffb859/7.01.18/en-US/3ab92341c045ef23e10000000a155106.html

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Aug 09, 2017 at 01:53 AM
0

Hi,

How will you know that company A was created on 2002? What field is it? Any other details about your report? Did Koen answered your problem already?

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded