Skip to Content
0
Jul 18, 2019 at 01:58 PM

Need table details to pick batch wise item cost/ batch transaction value,

171 Views Last edit Jul 22, 2019 at 05:36 PM 2 rev

Need table details to pick batch wise item cost/ batch transaction value, transactions wise & not just closing stock.

Tried to pick Batch wise item cost in particular transactions where row level combined Qty is captured and its split will have multiple batches. Each batch may have different cost which is exactly captured in Inventory audit report but do not know how to derive it in SQL / HANA query.

Tables Tried: OINM, IBT1, OIBT, OILM