char operations

[Former Member]

HI gurus!

in my program , i have matnr code of 18 char and which is in selection option of the program.But i want matnr only starting with 5 which is 14th char in the code and matnr code enter in the select option.

so i tried

WHERE a~vkbur IN area AND

b~matnr in mat AND

• b~matnr = '_____________5____' and

• b~matnr = '%5____' and

Regards,

Rahul

[Former Member]

make the selection parameter as 5 char field.. instead of matnr

AT SELECTIO-SCREEN OUTPUT event check if the value of this selection opion starts with 5.. if yes then proceed further and shift this 5char value in actual matnr...

if the value does not start with 5 then give error and STOP. this will not let the user go ahead till user enters matnr starting with 5.

[Former Member]

hi you can get MATNR starting with 5 using b~matnr eq '5%'. but you cannot get matnr starting with 5 and where 5 is the 14th character using SELECT statement.

first you get MATNR's starting with 5 and then use logic to find out whether it's 14th character or not...

if matnr+14(1) eq '5'....like that

[Former Member]

WHERE a~vkbur IN area AND

b_{matnr in mat AND substr(b}matnr,13,1) = '5'

[Former Member]

no its giving error

[Former Member]

Try

WHERE a~vkbur IN area AND

b_{matnr in mat AND b}matnr+13(1) EQ '5'

[Former Member]

try this..it will work definitely...

b~matnr like '_%5____'

Message was edited by:

Muthurajan Ramkumar