select query

[former_member582701]

Hello!

I have this select:

SELECT SINGLE AUFPL

FROM AFKO

INTO l_aufpl

WHERE AUFNR = i_header-benum.

But i_header-benum has long 10 and AUFNR has long 12. I need compare AUFNR+2(10) with i_header-benum.

Ty

Points are garanteed.

[Former Member]

Hi

When you are using for all entries and comparing the table fields with other internal table field both the fields should be of same type and length

Move the i_header-benum to 12 CHAR varaible and pass to AUFNR in the where clause.

Reward points for useful Answers

Regards

Anji

[Former Member]

Hello,

Do like this.

concatenate i_header-benum '%' into i_header-benum..
SELECT SINGLE AUFPL
FROM AFKO
INTO l_aufpl
WHERE AUFNR like i_header-benum. " Check here

If useful reward.

Vasanth

[Former Member]

Hi

You cant use offset values inside the select query...You have to select the values first inti the internal table then do the search. Anyway inside select it's not possible...

Reward All Helpfull answers..............

[former_member582701]

the problem is that benum is like

0001000324 and aufnr like

XX0001000324.

If i copy benum into a char 12 is not working yet.

____________

ok, % has worked but concatenating into a char 12 and put % before not after.

Biju, you can do it like vasanth has told.

Message was edited by:

Manel Casadesus

[Former Member]

Hi,

Pass the variables i_neadre-benum and AUFNR to function

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

and store it in to variabales and then compare those 2 variables.

Regards

Jitendra