Skip to Content

Stock aging report in BI

Dear All,

I want to enhance stock aging report in BI, which is created on 0IC_C03 info cube. Here i have below format data at present.

Material Stock Bt 15 Days Stock Bt 16 to 30 Days Stock Bt 31 to 60 Days Stock Bt 61 to 90 Days Stock Above 90 Days Valuated stock qty AAAA 102.050 KG 69.690 KG 410.730 KG 36.428 KG 0.000 KG 618.898 KG

First i am trying to know, how we got these values. Based on key figure formulas, i got to know first two fields(Stock Bt 15 Days, Stock Bt 16 to 30 Days) value. Same way am checking for other fields but am not getting. Please tell is there any way to check the stock aging report.

Like above data, i want to enhance Stock Bt 91 to 180 Days, Stock Bt 180 to 360 Days.

Thanks,

Manjunath.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 05, 2013 at 06:32 AM

    Hi,

    Check this out:

    http://scn.sap.com/docs/DOC-11163

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 04, 2013 at 10:36 AM

    HI

    How are the first two KPI defined? Based on what date? Why can't you not use those to calculate whats between 91-180 etc?

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 04, 2013 at 07:19 PM

    Hi Manju,

    They would have done it this way !!

    They would have taken Calday or Posting Date and done Off Setting with 0-14,15-30,30-60,etc.

    The Offsetting is like Calday/Posting Date - Create a Variable and then offset it with 0 as lower range and 15 as Higher Range and then Restrict it with Value/Price.This way they would have created , RKF1, RKF2, RKF3,RKF4.

    So have a look at that RKF and then do it as per new Requirement.

    So Paste that RKF here,can guide you further...

    rgds

    SVU

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.