topic Re: Asterisk logic in Application Development and Automation Discussions

Asterisk logic

Former Member — Wed, 28 Feb 2007 05:55:16 GMT

Hi,

I am having a parameter p_MATNR. This field should also have asterisk logic(). for example if i enter material number '48hg' it should retrieve all the material numbers that match that pattern.

Can anybody provide me the logic for the above one.

Thanks...

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 05:57:33 GMT

IF p_matnr CA '*'.
ELSE.
CONCATENATE  p_matnr '*' INTO p_matnr.

ENDIF.
SELECT  matnr FROM MARA
              INTO TABEL itab
               WHERE matnr LIKE p_matnr.

Also u can do like this


ranges r_id for mara-matnr.
r_id-low = 'VP*'. (p_matnr)
r_id-sign = 'I'.
r_id-option = 'CP'.
append r_id.

select matnre 
    into table i_table
      from mara
where matnr in r_id.

Re: Asterisk logic

sreeramkumar_madisetty — Wed, 28 Feb 2007 05:59:00 GMT

For Parameter we can use Eq,> ,< only.

It cann't be possible your requirement with Parameters.

But it can be achieved with select-options.

Opt for select-option for your requirement.

Regards,

kumar

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:00:26 GMT

Hi,

This can be achieved using RANGES in your code.

RANGES: gr_matnr FOR mara-matnr.

gr_matnr-sign = 'I'.

gr_matnr-option = 'CS'.

gr_matnr-low = p_matnr.

APPEND gr_matnr.

CLEAR: gr_matnr.

Use this in the WHERE clause saying:

WHERE matnr IN gr_matnr.

Please, let me know if further details are required from my side.

Thanks & Regards,

Goutham.

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:02:53 GMT

Anil,

that is there in sap as built-in feature.

sujatha.

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:03:42 GMT

if you are using select

select matnr into mara-matnr from mara where matnr like '048%'.

it wil fetch the data whose first 3 digit is 048.

if it is a select-option

then

S_op-low = '048*'.

s_op-sign = 'I'.

s_op-option = 'CP'.

append s_op.

regards

shiba dutta

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:04:34 GMT

translate p_matnr using '*%'.

select matnr from mara into table itab where matnr like p_matnr.

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:19:34 GMT

Hi,

With out using ranges and select-options can u provide the coding.

i need to do it only with parameters.

Thanks...

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:22:17 GMT

that meaans your select query should do like that...

just check my previous reply.

here

if p_matnr ca '*'.

concatenate p_matnr '%' into p_matnr.

endif.

select matnr into mara-matnr from mara where matnr like p_matnr.

regards

shiba dutta

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:30:31 GMT

Hi,

Thank u for ur reply.

Yes my requirement is same.

But it is not working. it is giving no records found.

Thanks..

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:33:38 GMT

Have u tried my code.

IF p_matnr CA '*'.
ELSE.
CONCATENATE  p_matnr '*' INTO p_matnr.
 
ENDIF.
SELECT  matnr FROM MARA
              INTO TABEL itab
               WHERE matnr LIKE p_matnr.

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:34:06 GMT

Hi,

the code should be as follows :

replace all occurences of '*' in p_matnr with '%'.

then apply the select statement. In SAP, the '' is not determined by SAP if used in ABAP Code. Instead '%' works similar to ''.

Try it.

Please award points if helpful.

Thanks,

Himanshu.

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:34:36 GMT

Hi anil,

have u tried my reply

search p_matnr for '*'.
if sy-subrc eq 0
translate p_matnr using '*%'.
endif.
 
select matnr from mara into table itab where matnr like p_matnr.

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:43:17 GMT

anil,

DATA: STR1 VALUE '*',

STR2 VALUE '%'.

parameters : p_matnr like mara-matnr.

AT selection-screen.

REPLACE STR1 WITH STR2 INTO p_matnr.

Start-of-selection.

select matnr into mara-matnr from mara where matnr like p_matnr.

Pl.s mark if useful

Re: Asterisk logic

Former Member — Wed, 28 Feb 2007 06:44:58 GMT

Hi anil,

1. 1 -

> will give all MATNR containing 1 anywhere in the code.

2. just copy paste.

report abc.

*----

DATA : MARA LIKE MARA OCCURS 0 WITH HEADER LINE.

DATA : MYMATNR LIKE MARA-MATNR.

PARAMETERS : S_MATNR LIKE MARA-MATNR.

*----

<b>MYMATNR = S_MATNR.

REPLACE ALL OCCURRENCES OF '*' IN MYMATNR WITH '%'.</b>SELECT * FROM MARA

INTO TABLE MARA

WHERE <b>MATNR LIKE MYMATNR.</b>

LOOP AT MARA.

WRITE 😕 MARA-MATNR.

ENDLOOP.

regards,

amit m.