Skip to Content
avatar image
Former Member

MARA-MATNR & VBAP-MATNR values

The link between MARA and VBAP tables is MATNR. There are difference in the pattern of MATNR in these two tables. Please find attached screenshot for the same. Now my question is why there is difference in values.is there any conversion logic or any reference table where I can look into. Please suggest.

mara vbap.jpg (337.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Dec 24, 2013 at 06:56 AM

    Hi,

    Plz check whether you are checking the same material master Data

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 24, 2013 at 07:36 AM

    Soumen,

    MARA-MATNR is usually copied unchanged into VBAP-MATNR during order creation.  Unless someone has created some customer enhancements, there is no conversion logic or reference table.

    It is not clear to me what you mean by "...difference in the pattern of MATNR in these two tables."  Please elaborate.

    I see nothing in your two displays that indicates any problems.  Actually, I don't even see the same material number displayed in both tables, so I don't know you could be showing a difference in 'patterns' - whatever that is.

    Best Regards,

    DB49

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 24, 2013 at 08:56 AM

    Hi

    Please, check if you are using alternative ID for materials. Check SAP Note 78093 - Display of alternative material identifiers. Although I believe it isn't relevant, check also SAP Note 72286 - Lexicographical <-> non-lexicographical material no.

    I hope this helps you

    Regards

    Eduardo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 24, 2013 at 09:04 AM

    Hi Soumen,

    Copy the MATNR values from VBAP table and give them in the selection screen of SE16N of the MARA table. If you dont find any entry for them, then there is some concern.

    Otherwise, your current screenshot just indicates different materials in VBAP and MARA table, which is usual.

    Thanks,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 24, 2013 at 11:30 AM

    Hi,

    Please check the material number in the VBAP table. make sure you have given the same material number in the selection screen of SE16 which you have copied from MARA table.

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 24, 2013 at 12:37 PM

    Hi

    You are checking different materials. If you check the same material in VBAP and MARA it would be same and this MATNR field join in Query reports work fine. Don't know from what perspective you are asking but I have joined these fields many times and it worked.

    Thank$

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 24, 2013 at 03:09 PM

    I dont think so.  Your screen shot shows only first 200 records from both the tables.  Better check with one example by considering MATNR from MARA and pass on in VBAP.  Update here what is the outcome.

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2014 at 11:29 PM

    Open both tables side by side and then go to Settings - User Parameters on tab Data Browser there is format, see if you selected Check Conversion exits for one and not for other table

    Add comment
    10|10000 characters needed characters exceeded