topic Re: Serial Number problem in Application Development and Automation Discussions

Serial Number problem

Former Member — Mon, 19 Nov 2007 07:09:52 GMT

Hi men,

i encounter a problem about serial number. In the same plant, the processing is below:

1> when the finished product is receipted and move to the finished stock, we assign a serial number to each one.

2> then we move the product based on serial number from finished stock to sales stock.

3> finally we sell the product based on the serial number from sales stock.

now how can i get the current plant and storage location by the serial number and how can i know if the product related to the serial number is sold or not?

please share your expert idea. thank you in advance.

Re: Serial Number problem

Former Member — Mon, 19 Nov 2007 07:16:29 GMT

Hi,

I give smal point.just try it.

sap creates Equipment master while creating serial number.So, you check equipment master.it has material number and serial number.

L.Velu

Re: Serial Number problem

Former Member — Mon, 19 Nov 2007 07:20:18 GMT

Hi Dave,

If u have the equipment number then go to IE02 and go to additional data ie to the right side of all tabs there u find SER DATA

.click it it and go to history there u get alll history abt ur serila number...

or else try Iq02..

Re: Serial Number problem

Former Member — Mon, 19 Nov 2007 07:26:35 GMT

Hi Velu,

thanks for your reply.

yes i can get the material number and serial number here. but that's not what i want.

i just want to know:

1> How to find out the current plant and storage location related to the serial number?

2> How to identify if the product related to the serial number is sold or not?

Re: Serial Number problem

Former Member — Mon, 19 Nov 2007 07:32:29 GMT

hi,

for 1st Q, i don't have answer now.

for 2nd Q, you check entry in sale doc for equipment num.if is there any entry,that serial number materil is sold, other wise is not sold.

L.Velu

Re: Serial Number problem

Former Member — Mon, 19 Nov 2007 07:39:02 GMT

Hi Kaveri,

thanks for your information. It's really helpful.

I digged out the table EQBS that save the current plant and storage location data of the serial number from the T-Code IE03 (Yes, the T-code IQ03 is also).

I gave you 6 points. do you have any idea about my second question?

thank you very much.