Skip to Content
Former Member
Nov 29, 2007 at 04:43 PM

Need help


Hi SAP Gurus,

I have a requirement as below :

Parameters : DENSITY(3) TYPE C.

Actually this DENSITY field is 4th , 5th and 6th characters of the 10 digit material number .

Say if the material number is A123456789 then the DENSITY would be 456.

Now if the user enters this DENSITY in his selection screen, he has to get all the materials having this DENISTY from the table MARA.

I tried with the following code:

select matnr from mara into itab where matnr like %DENSITY%.

But it can give me materials with this DENSITY starting at the first character or 2nd character or anywhere.Hope u got my doubt.

Could any one help me out .It's very helpful to me.