[Help] - Query for Serial Number in Material Movements!

[Former Member]

Hello SAP gurus,

I am creating a SAP Query to retrieve the serial number used in a production order, components only. The query is like this:

AFKO -- MSEG -- SER03

I have the information tha I used a number of serial numbers in the material movement but I dont know wich ones!!!

Can someone help me with this?

Thanks in advance,

Adelmo Silva

Edited by: Adelmo Silva on Oct 17, 2008 11:11 AM

[muthusamy_sankaran · Accepted solution]

Hi,

When GR is done serial number is updated in table OBJK, you 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,

Sankaran

[rupesh_brahmankar3 · Accepted solution]

Dear,

Go to SA38 and Execute Program "RIOBJK00"

Also you can write an ABAP Query using Table SER03- OBKNR and MSEG.

In table SER05, the list of serial number details can be obtained.

key the order noin ser05 table, get field OBJKNR, then pass this OBJKNR in table OBJK and in table EQUI to get the serial nos. GERNR

Regards,

R.Brahmankar

[Former Member]

Hi,

You can get serial number list assigned to unrestricted stock of FG in MMBE.

Path - MMBE -

---

select stock -

---

header menu------enviornment -

---

Equipment or serial number

There you will get list of all serial number asgined to stock.

Regards,

Ashish