I have calculate no of days = sy-datum- last injurt date at bex .
In cube I am getting Iast injurt date at company code level. But at bex i wnat to use last injurt date. I am not using any key figures here?
comp code last injurt
1000 20th jan
1000 23rd jan
In bex no of days = 30th jan ( sy-date) - 23rd jan
please let me know what is best possible solution?