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

Reciepts & Issues.

Hi,

i want opening stock of today.

First let me explain what i am dooing,i am taking opening stok of this mont from MBEWH.then i am adding rieciepts and minus issues from month starting date to yesterday,result will be my opening stock of today.

Now my question is

1) what i am dooing is correct or not.

2) while calculating reciepts and issues, how i have to calculate.should i calculate using MSEG by giving mov types or can i take directly those quantities from S031(MC.9) Table.

Ravi Kumar Tumpati.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Dec 09, 2011 at 12:05 PM

    Also you can get desired output through transaction code : MB5B or S_P00_07000139 which will give you list the stock value per movement by unit to unit and opening/closing stock aswell.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 07:38 AM

    Hi,

    You can find Opening stock and closing stock on a particular date using Tcode : MB5B.

    If you want the same using program use below program in WIKI. This will give you opening and closing stock on a particular date.

    http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=72977

    Regards,

    Sankar Tata

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 06:28 AM

    Hi,

    I would suggest -> S031 or -> S032 tables. Since it stores the statistical data about goods movement, It would be faster and would serve the purpose better. The stock would be = opening + receipts - issue. Thanking you.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Pdmasri ,

      It is fine please clarify little bit more,I am giving logic to my ABAPER for calculating open stock of today. i am taking open stock of this mont (closing stock of last mont) from MBEWH,It is fine .my question is regarding reciepts and issues qty should i take from S031(no need of mov types),or should i sum up the qty from MSEG table by giving mov types.

      Ravi.

  • Posted on Dec 09, 2011 at 06:37 AM

    HI

    useful table will be

    MSEG

    MKPF

    Regards

    Kailas Ugale

    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.