MARA-BISMT QUERY issue

[former_member401319]

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

Teo

[JL23 · Accepted solution]

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.

[former_member401319 · Accepted solution]

Thank you for the answer. Indeed it is stored without leading zeros.

My next topic is how to put the leading zeros in order to have the other fields displayed. A mass change to all the materials regarding the numbering is not a solution.

Thank you in advance

[JL23 · Accepted solution]

I think this part of the question was already answered with AKPT's reply, you can't achieve it without ABAP coding.

[Prasoon]

Hi,

   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.

Regards,

AKPT