cancel
Showing results for 
Search instead for 
Did you mean: 

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

arunkmd
Explorer
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

View Entire Topic
BattleshipCobra
Contributor
0 Kudos

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