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

[arunkmd]

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

[bill_froelich]

I have update the primary tag for your question. SAP Inventory Manager refers to a mobile product based on the Agentry platform and does not relate to your question. Please feel free to update the tag to another value if you feel this isn't the correct tag.

[BattleshipCobra]

This article from Steve Lipton might help you understand the structure and contains lots of good detail on the batch transaction table structure:

https://www.linkedin.com/pulse/batch-numbers-writing-recall-report-sap-business-one-steven-lipton/

Hope this helps!

M

[prudhvi_ravipati]

Hi,

Use OBVL Tables which stores batch cost for every transactions where the inventory movement is there in SAP Business One.

Thanks,
Prudhvi.