Skip to Content
avatar image
Former Member

Stock Ageing Report

Hi friends,

I have developed a Stock Ageing report using below link.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30f15839-0cf1-2b10-c6a7-ebe68cc87cdc?QuickLink=index&…

However no Quantity is coming under any interval.

Please suggest me few ideas to complete my report ..

Regards,

Kavitha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 23, 2014 at 07:36 AM

    Hi Kavitha,

    I have two questions:

    • Characteristic 0BATCH: is it available at all (i.e. does the company work with Batch Management)?
    • Key Figure Valuated stock qty (0VALSTCKQTY) does it show data in any other query (or test query)?

    I have a feeling that either Characteristic 0BATCH is not used or Key Figure 0VALSTCKQTY does not have values.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 06:40 AM

    I assume you created the report exactly as described in the doc. So do you see any value in the "stock" key figure (i.e. the one not restricted for any interval)?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 06:43 AM

    Hi Kavitha,

    Did you mean for keyfigure 0VALSTCKQTY no data is coming or in formula variables no data is coming?

    Please confirm

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 06:52 AM

    Hi,

    have you check the MB51 report if not please check for the quantity and amount in LC at ECC system.

    have you data for the quantity and amount at PSA - if yes have you written the any routiens at transformations plesae check.

    if have data in the cube have data for the specifc KF'S issue total stock, receivde total stock, issue value and recived vlaues.

    check the cube leve have the all KF's have vlaues.  then check key figures buckets.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 23, 2014 at 09:17 AM

    Hi Friends,

    Thanks for your help.

    I am getting values.And the kf m using is 0CPQABU

    However for few materials i am getting data in both 0 - 30 and 31 - 60 buckets.

    Please guide me.

    Regards,

    Kavitha

    Add comment
    10|10000 characters needed characters exceeded

    • Please drag batch number into your output. And also drag the Manufacturing date attribute (display or nav, any one is fine) of the batch number. I suspect that the date of mfg is blank in many cases, which is why the difference comes out as 735591.

      Also, Batch number should be in the output, because the aging is dependent on the batch number. The replacement path Formula variable does not work correctly if the parent characteristic (batch number) isn't in the output.

      Due to this the system is showing the same stock in multiple buckets.