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,