Skip to Content
0

how to convert Key to characteristic in bex query designer

Mar 04 at 11:47 AM

39

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Cornelia Lezoch Mar 06 at 10:51 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded