Passing partial key in where condtion !

[Former Member]

Hi,

I have come across a requirement where i need to pass partial key in where condition in select query.

For ex :

select * from mara into table lt_mara

                where matnr+16(2) = '10'.

Tried CP(Contains Pattern) aswell.

How to pass partial key in where condition?

Regards

Deva

[Former Member]

Hi

try to use LIKE in your where condition:

select * from mara into table lt_mara

                where matnr  like  '%10'.

Max

[Former Member]

Max, wouldn't matnr  like  '%10' fetch all articles where '10' is present instead of only the ones where            16(2) = '10'?

V.

[Former Member]

What Max said is correct.

SELECT SINGLE matnr FROM mara INTO lv_m WHERE matnr like '%10' is the correct since you are selecting articles ending with 10.

[Former Member]

what if i want to fetch the matnr which has 10 in the 3rd and 4th character

Ex : MA10TERIAL

[Former Member]

MATNR LIKE '__10%'.

V.

[Former Member]

Hope the below explanation helps.

[Former Member]

Try this.  The previous answer would get all entries that ended in '10" regardless of length.  Use 16 underscores instead of "%".

select * from mara into table lt_mara

                where matnr  like  '________________10'.

You could also set up a range table containing an entry with your selection criteria.

select * from mara into table lt_mara

                where matnr  IN r_matnr.