Skip to Content
author's profile photo Former Member
Former Member

SAP has a table that maintains Stock on Hand for each day

SAP has a table that maintains Stock on Hand for each day

do u know which table is that

as i need to find data on stock on hand

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 11:14 AM

    HI Arunraj ,

    Go to TCode MB5B !

    Cheers,

    Octav

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2011 at 01:13 PM

    In SAP APO there is no such table because all the stock data is kept in LiveCache. However you can display the stock situation with transactions

    /SAPAPO/RRP3 - Product View

    /SAPAPO/SNP94 - Interactive Supply Network Planning

    there is a key figure called Stock on Hand.

    /SAPAPO/RRP4 - Receipts View

    /SAPAPO/PPT1 - Product Planning Table

    /SAPAPO/POV1 - Product Overview

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 02:01 PM

    HI Arunraj

    if there is any specific time of the day that you want to extract the data, you can copy the data from the order series key figure (assuming that you want to extract the data from the order series keyfigure) to a time series key figure and extract the data from the time series key figure into a cube, etc.

    I mention a specific time of the day because the stock situation is likely to change multiple times of the day due to stock movements on account of various reasons. Hence if you can establish a rule or a cut-off time of the stock situation, you can use the above route.

    Hope this helps.

    Thanks, Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 11:26 AM

    Hi Arun Raj,

    When you say stock on hand, do you mean just the qty available in stock or Stock+receipts-reqmts for each period?

    If you meant just the stock qty, you can use BAPI "BAPI_STSRVAPS_GETLIST2" to extract the stocks of the location products.

    If you meant Stock+receipts-reqmts for each period you can use the time series logic suggested above after configuring your data view/macros to accomodate all relevant recipt & requirement categories.

    Regards,

    Ashok

    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.