Skip to Content


Hello SAP Experts,

Starting from Material number and plant i need to build a query in which to be available based on selection criteria plant and material number the following: material no, material no EAN, material no description, old material number, old material number EAN, old material number description, follow up material no (MRP4 view, MARC table), follow up material EAN, follow up material description.

In SQ02, starting from table MARC with MARA and MAKT and alias tables I managed to have all the needed info fro current material and follow up material.

The problem is that I am not able to succesfully link the actual material number to old material number and to have the expected output. I can generate the old material number based on actual material no, but based on old material no I cannot retreive the EAN and description.

Is anyone more familiar with this kind of queries?

Thank you very much in advance


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 12, 2016 at 03:13 PM

    you probably have the problems because the numbers are stored differently internally.

    BISMT is just a text field. What you see is equal to how it is stored in the table.

    But MATNR is stored in length of 18 characters with leading zeros in the table while it is displayed without leading zeroes (in an unchanged SAP system)

    Use SE16 to look at the values, there choose from menu Settings > User parameters

    remove the flag from "consider conversion exit " from the tab Data Browser.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 12, 2016 at 03:20 PM


    You can achieve the requirement with a small piece of code in the query. Refer the link: Building an SAP Query using ABAP Code

    Follow the method and bring the data based on your own logic.



    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.