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

Daily Stock and Sales Report

Hello.I need to develop a stock and sales report in R/3. The columns in the output are:

SKU Code, Opening stock qty (as on 1st day of the month), Closing stock qty (as of end of transaction date), Sales Qty, Sales Qty value, Unit of Measure, Date.

While I have an idea how to go about the opening stock and sales details, I need help with the closing stock quantity calculation. Which tables do I access, fields, etc. .. any suggestions?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 27, 2013 at 08:43 AM

    Dear all,

    Thank you for all the help and suggestions. I finally got it. Forget about using MKPF and MSEG. Use S031 and S033 instead. Thanks once again. P.F.A. the coding which I used. Hope it will be useful.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 10, 2013 at 08:43 PM

    Roslin,

    Can you please give an explain for Closing stock quantity?

    Stock at the end of the day could also be understood as closing stock quantity!

    What is the definition of sales quantity? Is it sales order quantity or billing document quantity?

    For stock, you can look into

    - MKPF, with posting date

    - take the material documents got, and put in table MSEG, with movement type = 101, material and get the quantity

    For sales quantity and value, you can look into

    - VBRK / VBAK

    - and then into VBRP / VBAP and get the quantity and the netwr (net value) at line item level, for a material.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 11, 2013 at 07:02 AM

    Dear

    This coding seems ok to me. I was talking about MSEG table only. May be MSEG will create performance problem rest are ok.

    For sale return you can show in same column too with - sign with quantity and value. If it is client's requirement to show in separate column then create it.

    Please note that sale is taken into consideration with Invoices quantity and stock with movement types. Once we tried to cater sale with movement type 601 too but that was just a waist of time because we can't ever match 601 with invoices quantity due to FOC issues. So just focus on VBRP and VBRK for Sales.

    Thank$

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 10, 2013 at 08:55 PM

    take a look at mb5b

    regards

    Matthias

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 11, 2013 at 01:51 AM

    Hi,

    Could you please explain bit more on closing stock quantity. Are you referring to the stock which is at storage location?If so why are you involving sales stock in closing stock ?

    Please help me on closing stock, so that we can guide you.

    I have developed similar report for one of my India implementations. Its very cumbersome report.So, be clear on the requirement and also, take help from MM as we need to consider lot of movement types.

    Regards, Sai Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 11, 2013 at 06:21 AM

    Normally due to some special fields you need to develop a report for this, but I always prefer to use standard for part analysis. For example, in one of my Clients they had a 700 page Legacy System report showing stock movements for the month ... now who is going to read this document.

    I always like to review the MB* transactions and review the MC* transactions.. Good examples:-

    MCBA / MC.1 / MC46 / MC50

    MCTA, etc

    If you have a good background with LIS/SIS you could configure your own structure and do it from there too. And as Ali has pointed if you do go down the ABAP bath then there will be multiple changes and bug fixes.

    Regards

    Waza

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 11, 2013 at 05:10 AM

    Roslin

    We also have a same report with ZPSI Tcode. PSI means Production, Sale and Inventory. For this report we have struggled a lot and after so many issues finally we have accurate report. We can give material number or material group in selection with dates and system shows it's opening stock, procurement, production, sale and inventory (closing stock).

    For this first you have to see whether you are creating this report on date wise or month (period) wise. If this is date wise then you have to calculate closing stock. For opening stock use MARDH table. For calculating stock consider all movement types and use table MSEG and MKPF. You will never get closing stock date wise in any SAP table. Historical data is always period wise.

    For sale you have to use tables VBRK and VBRP. Invoice value, quantity, material number and unit of measure etc are in these fields.

    Discuss this with your ABAPER and update me if you need more clarification.

    Thank$

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 10, 2013 at 06:34 PM

    Dear,

    Your requirement is not possible by one thing .You need to get data from many sources into Excel and you have to observe .Please have look into MM60 and MC.1 T.Codes .

    Note : There are so many sources to get the Data from Many reports .Please search in Google .

    Thanks,

    Naren

    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.