Skip to Content

SAP Report for the deliveries and orders of the material with the Available quantity

Dear Experts,

Our warehouse team is looking a report which contains the sales and Deliveries of the Material, Sales & Delivery Date With the Quantities and the unrestricted stock in Use. They need this report in order to calculate the Quantities that are delivered during a Certain period of time (For Ex: May/June 2020) and the to calculate the unrestricted stock. Because normally we have unrestricted stock in MMBE But it will not show up the update of "Scheduled for Delivery".

So now I'm developing a Query with the Tables VBAK, VBAP, LIKP, LIPS, MARA, MARD & MARM(For Unit conversion). But when I execute the system throws an error message "No data was selected".

I've attached the screenshot of the joined Tables.

Can you suggest me solution to solve this issue? Or is there any alternate solution to solve the issue?

Awaiting your answers.

Thank you in Advance. Regards,

Mukkesh

joined-table.jpg (270.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 09 at 11:05 AM

    VBAP-VBELN joined to LIKP-VBELN is incorrect.

    Better use VBAP-VBELN = LIPS-VGBEL.

    Please have in mind that with such kind of selection you will not see all documents, e.g. deliveries without reference (created with VL01NO) and deliveries referencing purchase orders will not be displayed in your query. If you have items like packaging or manually added lines in the delivery - they will not be displayed as well. If such information on items is needed - it is better to create a z-report instead of a query.

    By the way, this screenshot probably shows only a part of the join, there may be more mistakes in how you linked the tables.

    For example, I see no link between MARA-MATNR and all tables where this material is used.

    Also, when you use MARD, MARM, VBAK, LIPS, etc. in the same query, the output will look very ugly and unusable. If possible - consider getting rid of some of the tables from this join and perform the unit conversion in free code section in the infoset (or even better - create a custom report).

    I don't really know which fields you intend to use, for example why you need MARD when you do not seem to link WERKS and LGORT to other tables.

    Have you considered the use of logical databases for your query? I do not know what data you require, but it is a good practice to check logical databases before you start building joins by yourself.

    Please have in mind that a query selecting from the tables that you mentioned probably will not have good performance. If the users intend to run it for lots of documents in foreground - consider placing some restrictions in the selection screen.

    Edit: one more thing - I hope that you are aware that MMBE is not the right report for checking available stock. When you work with orders and deliveries, you use CO09.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 09 at 10:46 AM

    Standard Reports VA06 and MB52 are good to start with. VA06 will show the order quantity and delivered quantity while MB52 shows the unrestricted stock quantity.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Lakshmipathi,

      Thank you for your response. I need this information for the warehouse team to calculate material requirement for the stock movement. I need Exactly the information in MD04 as a report. So, I tried to develop a query using the table given above.

      Is there any alternate solution to get the informations in MD04 as a report in Excel? For Example: The user's intention is to get the information about the past Deliveries (With the Quantities and Date), Stock available for the material, The purchase order(Not Mandatory) and the sales order (Planned for delivery as in MD04).

      I hope you understood what I'm trying to say. I just need to information from MD04 as a report in Excel.

      Awaiting your suggestions.

      Thank you in advance. Mukkesh

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.