How to get all sernr of material at specific lgort

[Former Member]

Hi, experts.
How to get all sernr of material at specific lgort?
It quantity should be equal to MARD-LABST field.

[RaymondGiuseppi]

Be aware that MARD-LABST relates to Valuated Unrestricted-Use Stock, so your assertion of 'It quantity should be equal to MARD-LABST field' can be false. (e.g. part is not valuated or some strock is on hold)

Did you already

• Look at tables such as EQBS and EQUI
• Try to trace/debug MMBE

[Former Member]

I need to get only Unrestricted use sernrs

[RaymondGiuseppi]

If you didn't try to find it yourself with suggestions 😟 , use table T156C to identify 'Stock Type of Goods Movement ' related to 'Unrestricted-use stock' and cross it with EQBS

[Former Member]

Thanks, but why some values are not shown at EQBS
 i got some sernrs at EQUI ( with active status in jest ) and don't have them at EQBS,
how to find where does it stored ?

(  werk and lager is empty at equi and i look them throw eqbs) 

[RaymondGiuseppi]

You can find information in tables SER03 and OBJK, by searching for the last movement of the PN/SN.
(In fact, this SN may be in some special stock such as supplier, customer, transit, or even not relevant for inventory management)

[Former Member]

Not sure what are you talking about.
I found record at OBJK by filtering matnr and sernr
Put the value of OBKNR inro SER03
Get last MBLNR and put it into MSEG
Material sent to the same LGORT, which i want to get all the SERNRS from
But the are no values in EQBS.