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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[frank_horlacher]

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

[Former Member]

HI Arunraj ,

Go to TCode MB5B !

Cheers,

Octav