Quantity for Serial Numbers

[Former Member]

Hello,

Could anyone please tell me which table can I use to access quantity for each material # and serial# combination.

What I mean to say is, can anyone please tell me the table name which stores the quantity associated with that serial #.

e.g. Material # 1234 having serial #s 1111, 2222 and 3333.

Is there a table which has information of

material # Serial # Quantity

1234 1111 1

1234 2222 1

1234 3333 1

I know that each serial # would be always associated with a quantity 1, as serial number is unique for each product. However, I need to check whether the quantity associated with that serial# is zero or not. If zero ignore the serial#, and if not then proceed with some functionality.

Any help would be useful.

[Former Member · Accepted solution]

You will not get the quantity directly. You can get it from the status field, If it is in stock, it has a specific status (ask your PM consultant) otherwise a different one.

Please try the following tables for information:

SERI

EQUI

A combination of material number and serial number is always unique and is an equipment number.

[Former Member · Accepted solution]

Thanks Laxman. I was thinking on the same lines, but just wanted to confirm. Thanks.