How to find the serial number used during Goods receipt

[Former Member]

Hi ,

Have used serial numbers whle doing GR, but cannot find the table where the serila numbers are stored.

table ser01 contains the material document and the serialization procedure. I want to find a table where the serial numbers that I have used for the GR, are store. I want to retrieve them and send them in an interface.

Rgds

Sumendra

[Former Member · Accepted solution]

Hi,

Try this.

From Table: SER03 get OBKNR using MBLNR, MJAHR, ZEILE

Then in Table OBJK using OBKNR get SERNR Serial Number

Regards

GK.

[Former Member]

Hi

Function Module GET_SERNOS_OF_DOCUMENT can be used to retrieve serial numbers corresponding to any of the following documents.

Material document

Physical Inventory document

Import parameters:

Input parameters which needs to be passed changes based on the type of document.

Following are required fields to be passed as input parameters to get respective document serial numbers

3. Material document

KEYDATA-TASER = 'SER03'

KEYDATA-MBLNR - Material Document

KEYDATA-MJAHR - Material Document Year (optional)

KEYDATA-ZEILE - Item of Material document(optional)

7. Physical Inventory document

KEYDATA-TASER = 'SER07'

KEYDATA-IBLNR -Physical Inventory document

Output table:

Serial Number details are retreived in the following table

SERNOS

Serial numbers can be extracted from field SERNOS-SERNR

regards

Prashanth

Edited by: Prashanth@SD on Nov 3, 2010 6:20 AM

[Former Member]

Hi Sumendra,

Please refer to the following link to get the serial number link table

Regards

Srinivas

[Former Member]

Hi,

Tcode SE 16 and Table is EDIDC and Field SERIAL.Will this help?Also try program RIOBJK00.

Edited by: Thimmayya Belliappa on Nov 2, 2010 3:37 PM