topic Need help in Application Development and Automation Discussions

Need help

Former Member — Thu, 29 Nov 2007 16:43:59 GMT

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.

Regards,

Vishnu.

Re: Need help

naimesh_patel — Thu, 29 Nov 2007 16:48:14 GMT

Try with the code like this:

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

Regards,

Naimesh Patel

Re: Need help

former_member191735 — Thu, 29 Nov 2007 16:48:50 GMT

it is not good idea because of performance.

why dont you select all and then delete from internal table by comparing with your input values.

loop at itab into wa_tab.

if wa_tab+4(3)<> density.

delete from itab.

endif.

endloop.

Re: Need help

Former Member — Thu, 29 Nov 2007 17:11:12 GMT

I think selecting all Materials from Mara also will be a performance issue.

Experts should share there thoughts.

Thanks,

chaithanya.

Re: Need help

Former Member — Thu, 29 Nov 2007 17:25:41 GMT

You won't be able to use the index anyway.

But you can do this:

TABLES mara.

parameters p_den(3).

DATA: f1(10).

CONCATENATE '___' p_den '%' INTO f1.

SELECT * FROM mara 
  into table itab
  WHERE matnr LIKE f1.

I removed a period from 'into itab'.

Rob

Message was edited by:

Rob Burbank

Re: Need help

Former Member — Thu, 29 Nov 2007 18:20:32 GMT

Hi Naimesh,

I have tried your code.It's working perfectly.Thanks a lot.

Vishnu.

Re: Need help

Former Member — Thu, 29 Nov 2007 18:30:50 GMT

It worked? I think you have to use underscores in a SELECT statement.

Rob

Re: Need help

Former Member — Thu, 29 Nov 2007 18:38:12 GMT

Hi Rob,

It worked even with + character.Please let me know in case of any issues.

Vishnu.

Re: Need help

Former Member — Fri, 30 Nov 2007 03:40:15 GMT

I tried it and it didn't work and the documentation says to use underscores. Maybe they've changed it in higher releases. Which release are you on?

Rob