Table which links material documnet no and serial no

[Former Member]

HI Gurus,

Please help in finding the table in which I can link the serial number and the corresponding material document number.

Thanks

Tausif

[Former Member]

Hi,

Refer to following link,

Reward pts if usefull.

Regards,

Dhan

[Former Member]

Hi,

Use tables MSEG and MARC as follows:

SELECT mblnr mjahr zeile bwart matnr werks charg

kdauf menge ebeln equnr kzbew kzzug

FROM mseg

INTO TABLE int_move_mseg

FOR ALL ENTRIES IN int_mkpf

WHERE mblnr = int_mkpf-mblnr AND

mjahr = int_mkpf-mjahr AND

werks IN r_werks AND

bwart IN r_bwart AND

kzbew IN r_kzbew AND

xauto NE 'X'.

SELECT matnr werks xchpf sernp

FROM marc

INTO TABLE int_marc

FOR ALL ENTRIES IN int_move_mseg

WHERE matnr = int_move_mseg-matnr

AND werks = int_move_mseg-werks.

Hope this helps.

Reward if helpful.

Regards,

Sipra

[Former Member]

Hi,

EQUI has matnr ( material number ) and sernr ( serial number)

Thanks

Nayan

[Former Member]

Hi

Use tables MKPF and MARC :

first select mblnr ,matnr from mkpf.....

then select serial number from marc ...use for all entries in where condition use matnr = mkpf-matnr...