Skip to Content
author's profile photo Former Member
Former Member

Table which links material documnet no and serial no

HI Gurus,

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

Thanks

Tausif

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 08:52 AM

    Hi,

    Refer to following link,

    table-for-storing-serial-number-data-assigned-to-m

    Reward pts if usefull.

    Regards,

    Dhan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 08:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 08:54 AM

    Hi,

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

    Thanks

    Nayan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 09:00 AM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.