Skip to Content
avatar image
Former Member

table to find serial number for the stock of a material

Dear All,

I have a requirement in which i want to find the serial number for the stock of a material.

in Equi i have serial number with material.

But i want it with plant also.

pl. suggest me in which table u have serial number,material , plant and storage location.

Regards & thanks,

Vidhya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 08, 2010 at 10:59 AM

    Go to se11

    search with SER*

    The relation is OBJNR.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2010 at 11:10 AM

    can you check EQBS nad EQSE

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      thanks for all.

      Actually performance in the sense,while writing a select query with material only the in the selection it will be very slow.

      In EQUI i will have material and serial number but not plant and storage location.

      I am unable to relate the 4.

      pl. guide