Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get all sernr of material at specific lgort

shiz0frenik
Participant
0 Kudos

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

6 REPLIES 6

raymond_giuseppi
Active Contributor
0 Kudos

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

0 Kudos

I need to get only Unrestricted use sernrs

0 Kudos

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

0 Kudos

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) 

0 Kudos

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)

0 Kudos

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.