Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Kindly help me in solving the below issue.
Table1:
Material No | Plant | Qty |
28112 | 0001 | 500 |
1234 | 0002 | 100 |
Table2:
Order Date | KEY No | Plant | Qty_1 |
2-11-2013 | 28112 | 0001 | 300 |
22-11-2013 | 28112 | 0001 | 200 |
24-11-2013 | 28112 | 0001 | 300 |
05-12-2013 | 1234 | 0002 | 80 |
06-12-2013 | 1234 | 0002 | 30 |
From the above data, I need to check that for Particular Plant and Material, how many orders are placed as per order date.
Thanks in Advance.............
Just noticed that someone already answered this here: Challenging.............
Please do not post the same thing multiple times, or if you do, at least post a link to the new post on the old one...