table to find serial number for the stock of a material

[Former Member]

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

[kesavadas_thekkillath]

Go to se11

search with SER*

The relation is OBJNR.

[Former Member]

Dear kesav,

Thanks for your response.

I searched in ser* but no relevance for plant and storage location found.

pl. suggest some other table which u know

[GauthamV]

Check EQSE table.

[kesavadas_thekkillath]

can you check EQBS nad EQSE

[Former Member]

Thanks kesav.

I checked EQSE table in that no entries are found.

In EQBS table for that equnr u have plant and storage location.

but the performace while selecting EQUI on the whole will be very slow.

so i want a table with material,serial number,plant and storage location.

kindly suggest.

[Former Member]

you will get all the 4 in table EQUI

also check EQUP

Regards

Satish Boguda

[kesavadas_thekkillath]

performace while selecting EQUI on the whole will be very slow

what do you mean by this ?

[Former Member]

EQUI is the table for your requirement..

Regards

Satish Boguda

[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