Skip to Content
0

SAP Bex Report for stock issue

Nov 20, 2017 at 01:05 PM

30

avatar image
Former Member

Hi team,

We are developing a report on Stock in which we need latest Issue date, latest Receipt date and Total Qty (0TOTALSTCK) against Material?

But when we are trying to implement the same in the query, we are able to get the stock correctly but it mismatches the the logic of latest date.

For latest issue and receipt date, we have used 0calday as keyfigure and put the Condition to get the latest issue and receipt date. we are working on bw on hana 7.5.

Please let me know the answer or how to solve this.

thanks

ketan

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

2 Answers

avatar image
Former Member Nov 21, 2017 at 12:01 AM
0

Hi Tushar,

I think you can solve this by using exception aggregation on the Date key figures. Use Max aggregation.

Cheers

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 21, 2017 at 06:44 AM
0

Hi Bijesh,

Thanks for your reply.. can you please let me know more in detail...i am also facing the same issue?

Thanks

Ketan

Share
10 |10000 characters needed characters left characters exceeded