Skip to Content
-1

How to fetch materials based on matnr*

Hi Experts,

How can I fetch all the materials using the * after a where condition. Is it possible?

Lets say I want to fetch materials with ABC* where the material number starts with ABC.
So only/all the materials that start from ABC should be fetched.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 27, 2017 at 01:12 PM

    Do F1 Help on the WHERE statement. Look for the explanation of "LIKE" and also "IN seltab". You can also research RANGE and Range Tables.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 01:23 PM

    It depends on solution implemented on your system, look for the exact conversion-exit associated to domain MATNR.

    • If the conversion exit is a generic one like ALPHA, this is a FAQ and read again your course or online help.
    • If the conversion exit is is not a generic one , you wont be able to select with wildcard on material number in a simple statement. In this case look in your system for a table like MATERIALID with external and internal format and add it in the SELECT statement with a JOIN or SUB QUERY option.
    Add comment
    10|10000 characters needed characters exceeded