Skip to Content
avatar image
Former Member

SAP Bex Report for stock issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hi Tushar,

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

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2017 at 06:44 AM

    Hi Bijesh,

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

    Thanks

    Ketan

    Add comment
    10|10000 characters needed characters exceeded