cancel
Showing results for 
Search instead for 
Did you mean: 

Serial Number

Former Member
0 Kudos

Dear PP Gurus,

I have Created a Finished Product and 2 Raw Materials with the Serial Profile ( Serial Number Management) Activated . Goods issue of Raw material is done for the finished product against a particular production and serial numbers for the raw materials are generated. Serial Numbers for the Finished Product is generated while Goods receipt is done.

I Wanted to know whether there is any report to see the rawmaterial (serial Number wise) used to produce the finished product(Serial Number wise). ie Which serial numbered raw material is used for producing a particular serial numbered finished product.

Thanks and regards

Rakesh.B.S

Accepted Solutions (1)

Accepted Solutions (1)

rupesh_brahmankar3
Active Contributor
0 Kudos

Hi,

IQ09 gives you the Material & Serial Number Combination..

You need to create a SAP query through SQVI. or Z-Report for your requirement, serial numbered raw material is used for producing a particular serial numbered finished product.

Using serial numbers, one can very well track their history. It is stored in IQO3. If a material is serially managed, its stock can be seen in MMBE (header data has the option of showing the serial numbers). Using MB03, you can obtain the list of documents & only once u enter those documents you can view the serial numbers. These also get stored in SAP tables.The same can be retreived & reports can be developed.

I hope this solves ure problem.

Regards,

R.Brahmankar

Answers (2)

Answers (2)

Former Member
0 Kudos

Closing

Former Member
0 Kudos

Dear Mr.Brahmankar

Could you pls tell me the details of the table and fields to generate the Z-reports.

Thank you for the information rendered.

But i want a report thats shows the serial no of the Raw materials used

to produce a particular serial numbered finished product.

For Ex

Si.No Finished Prod Serial No Raw Material Serial No

1 F 01 R 01

Ie Raw Materail Serial Numbered 01 is used to produce Finished Product Serial numbered 01.

Regards

Rakesh.B.S

muthusamy_sankaran
Active Contributor
0 Kudos

Hi,

Some useful table for serial numbers

SER00 Generic table for serial numbers

SER01 Serial numbers assigned to a delivery

SER02 Serial numbers assigned to a guarentee

SER03 Serial numbers assigned to a material document

SER04 Serial numbers assigned to an inspection lot

SER05 Serial numbers for a production order

SER06 Serial numbers for Handling Units

SER07 Serial numbers for Stocktaking

SER08 serial numbers for Orders (SD)

Regards,

Sankaran

rupesh_brahmankar3
Active Contributor
0 Kudos

Hi,

Table EQSE. This is the table for Serial number records.When GR is done serial number is updated in table OBJK u can use this table with relation to GR document then You can see the table SER03 for the material document (field MBLNR). Here you will obtain the object number (SER03-OBKNR). With this number you can check now the table OBJK for the serial numbers

Regards

R.Brahmankar