Hi @Rex87, not entirely sure I understand the question. Can you provide a little bit more detail about what you are trying to achieve? 

Hi Anmise, our business has a subset of parts with multiple condition codes - New, Repaired, Overhauled, Core (Unserviceable). Its strange that the Inventory Parts in stock table does not contain/store the condition code data when the front end displays it. We have to get by calling an API (Condition Code Manager). I think this data should have been in a table format for validation, hence was trying to find if anyone knows any table containing P/N, Lot/Batch No, Serial No and Condition Code. I found a similar table ‘Inventory_Parts_In_Stock_Deliv’ that has condition codes with the above info; but when I matched with the ‘Inventory_Parts_In_Stock’ table, I was not able to find records for considerable number of lines (~2000 lines out of 100k+)

Is this for reporting or something else? If a view is enough, I think you might find what you need in inventory_part_in_stock_total. 

Hi Rex87,

we learned the hard way that you have to use the INVENTORY_TRANSACTION_HISTORY (View or table). TRANSACTION_CODE = OESHIP.

The moment your part get shipped the LOTBATCH_NO is in the ITH record. The INVENTORY_PART_IN_STOCK record will be gone when the lotbatch is „finished“.

hope that helps

Michael