Quantity for Serial Numbers
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.
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:
A combination of material number and serial number is always unique and is an equipment number.