cancel
Showing results for 
Search instead for 
Did you mean: 

Serial Number for material document number

Former Member
0 Kudos

Hi All,

Can any body tel me where Serial number stores for particular Material Document number.

When user creation/posting MB11 he will enter serial numbers for material in material document.

I already searched the forum. Unluckily i didn't received any related information.

Thanks in Advance.

NK

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I Tried looking standard table which contain Material number, Serial number, Equipment and Material Document but there isn't any.

So I went into SQVI and join two tables, MSEG and OBJK. There I manually draged the MATNR from MSEG Table to OBJK and then selected the fields like Materials Number, Plant, Material Document, Mov Type etc and from other table I selected Material Number plus Serial Number, Equipment (chose your required filters) and then executed and it shows the required records correctly.

Only issue it had was that if you try thousands of records e.g. Materials it went though and brought resukts and some time it dumped.  But it fulfilled my needs successfully.

Former Member
0 Kudos

Check table MSEG field ZEILE

MSEG-ZEILE.

peter_ruiz2
Active Contributor
0 Kudos

Hi Naresh,

Take a look at MSEG-CHARG

hope this helps.

regards,

Peter

Former Member
0 Kudos

Hi,

Every time it is not showing correct. Some time Charg and SERNR is defferent (when i go and see in MB03)

I tried in table - SER03 also. But it is also different.

Thanks,

NK

peter_ruiz2
Active Contributor
0 Kudos

Hi,

Try using the SERI Table.

use the following fields on the where condition

MATNR - Material Number

WABELN - Material Document Number

Regards,

Peter

Former Member
0 Kudos

Hi All,

Thanks for replies. I got solution my self.

From SER03 get OBKNR using MBLNR, MJAHR, ZEILE

using OBKNR get SERNR form OBJK.

Thanks,

NK