Dear Experts,
This is a very tough one
I have created a Query using SAP Query .. This query is for displaying the PO quantity from table : EKPO and the delivered quantity from table : EKBE
Then I have created a "Local Field" to calcualate the Still to be delivered quantity Local Field = PO quantity - Delivered Quantity
The problem is if the item has been recived more than one time with different quantities .. for example :
PO quant = 12
1. Delivered Quantity = 3 Local Field = 12 - 3
2. Delivered Quantity = 4 Local Field = 12 - 4
3. Delivered Quantity = 5 Local Field = 12 - 5
As you can see the local field is 9 in the first delivery and 8 in the second and 7 in the third , It should be 9 in the first and 5 in the second and 0 in the third .
When i run the report then try to sum the quantites you can imagine that the total sum of local field will be = 24 although the PO quantity is just 12
Note : If you could help me to know how to write a SELECT statement in the sap query or manipulating the Local Field using ABAP
Please Advice and don't till me to use ABAP program from scratch
Best Rgards