Need help in writing the code
Can you please help in writing the code for the below logic.
Table data will be as below.
Matnr PO Netprice Val
1 P1 10 5
1 P2 10 5
1 P3 10 5
2 P3 10 5
2 P4 10 5
3 P1 10 5
3 P2 10 5
Given conditions are as below.
1.NetPrice/PriceUnit will give the Unit Price for that material in that PO.
2.Sum the UnitPrice for that material in all PO's
3.Calculate the No of PO s for that Material
4. Sum(unitPrice)/No of PO s will give the AvgPrice.
Pls give me the skeleton to write this code.
Moderator Message: This is not a forum, where you can get your work done by others.
Edited by: kishan P on May 13, 2011 3:50 PM