Calculating Batch Item Cost

[stsj]

Hi everyone, we are trying to calculate the batch cost as we realize that the cost from batch is empty.

Therefore, we are trying to do a calculation by taking the item cost from the Receipt from Production and multiplying the quantity - $0.2470 x 170,000 = $41,990.

However, there is a slight difference in cost when calculating with the numbers taken from the Production Order Summary screen - $41,986.48/170,000= $0.246979.

There is decimal difference in the cost calculated from the Receipt from Production and from the Production Summary. $0.246979 and $0.2470.

Also how should I calculate the cost per batch if the Receipt from Production item has 2 batch numbers for 1 product?

I have tried looking the following tables - IBT1, OINM and ITL1 but I am unable to get value that I want to get.

Can someone help to provide a query to get the cost from each of the item batch and may I ask what will cause the cost to become empty in the batch details?

Thank you.