To explain the physical inventory posting.
We need to remember that the quantity we get in the material document is not a direct QCI conversion.
When you post a physical inventory difference you are posting a difference between the quantity counted from table ISEGO2 and the book quantity.
The book quantity is the sum of all the material documents from table MSEGO2.
When you enter the quantity manually in L15 and TO in the physical inventory document via QCI, the quantity calculated in the material document is the difference between this quantity (ISEGO2 table) and the sum of all material documents (MSEGO2 table).
The calculation is based on the material documents we have posted.
For example if you have posted two goods receipts for product A.
Goods receipts 1 at QCI conditions 1 Material temperature 15,00 Test temperature 16,50 CEL Test density 820,0 => 100,000 KG 121,788 L15
Goods receipt 2 at QCI conditions 2 Material temperature 20,00 CEL Test temperature 25,00 CEL Test density 820,0 => 100,000 KG 120,919 L15
And you enter the physical inventory with 198,000 KG at QCI conditions 3 Material temperature 18,00 CEL Test temperature 18,00 CEL Test density 820,0 => 240,847 L15
The program will calculate the difference between the counted quantity 240,847 L15 and the goods receipts quantities (121,788 L15 and 120,919 L15).
The stock quantity is different with different UoM is normal system behaviour in OIL systems, where the additional UoMs are involved. System always posts the material documents in Base UoM. These additional quantities, can be changed manually before posting. Hence, there is possibility for discrepancies.
We can post a physical inventory document(MI07) with zero count for making additional quantities (LIPSO1,LIPSO2) to zero, when Base UoM quantity is zero.
Hope it explains the Oil logic in posting the physical inventory document.
Related SAP Notes/KBA