cancel
Showing results for 
Search instead for 
Did you mean: 

Serial Number for Current Stock

dineshudl
Discoverer
0 Kudos
148
Hi Team, I am currently working with the Serial Number Profile settings, where the "Stock Check for Serial Number" is set to "No Stock Validation." The current stock of Material X is 10 units in the Unrestricted Area and 5 units in Quality Stock. I need to develop a custom program to list the serial numbers corresponding to the stock quantities. To do this, I am looking for the correct function module (FM), BAPI, or SAP tables that can accurately retrieve the serial numbers for the current stock. I have already tried standard SAP reporting t-codes such as IQ03, IQ08, IQ09, and tables like EQBS, EQUI, and JEST. However, these tables are not meeting my requirements, as they are inconsistent. For example, these tables return 100+ serial numbers with the ESTO status and stock type '01', while my actual stock is only 10 units. This discrepancy occurs because users often manually change the status of serial numbers in IQ02 using the "Edit >> Special Serial No." function, and also because NO stock validation for serial numbers during stock posting. Could you please guide me on the correct approach to obtain the accurate serial number list for current stock? Thanks and Regards, Dinesh Kumar V.
View Entire Topic
alex_frank
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Dinesh,

Please have a look at note https://me.sap.com/notes/612132 "FAQ: Stock consistency between serial numbers and MM-IM".

Without stock check set to error, you can post a GR for e. g. 10 PC, but only add 2 serial numbers. So there can't be a hidden table that has consistent inventory and serial number management stock. If you require this consistency, please follow the answer to the last question in the note.

BR,
Alex