Skip to Content
avatar image
Former Member

how to convert Key to characteristic in bex query designer

stock-value.jpg

Hi ,

I am having one complex requirement from the business.

As given below.

1.latest GR value and GR qty it should be based the given Key date.

2.After generating the latest date of the GR, based on that date need to be display the stock value.

Ex. I have executed report as on 31.12.2017

My latest GR is happen in 15.12.2017, with the reference of this GR date my stock value should display.

I have achieved first one by implementing the Replacement path and displayed latest date.

Now i wan tot display stock value as on 15.12.2017.

this GR date is different for each material.

I have to display the stock value for each material based on the latest date of the GR.

Any one please advise the solution.

Thanks

Narayana

stock-value.jpg (17.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06 at 10:51 AM

    Hi Rayana,

    please google for "sap bw stock management"

    it gives a lot of information about how to handle stock.

    You need to have a stocj key figure and the appropriate cube and data management for this.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded