Skip to Content
0
Former Member
Sep 17, 2013 at 02:47 PM

Problem with BETWEEN in transformation routine

18 Views

I have written the following routine within a transformation:

DATA:
LV_SUM_DarlPfandbereich TYPE I.

SELECT SUM( t0~/BIC/Z_LOANMNT ) INTO LV_SUM_DarlPfandbereich
FROM /BIC/PZ_PAWNNUM AS t0
INNER JOIN /BIC/PZ_ACCDOCE AS t2
ON (
t0~/BIC/Z_FILIALE EQ t2~/BIC/Z_FILIALE
AND t0~/BIC/Z_PAWNNUM BETWEEN t2~/BIC/Z_PWNNFRO AND t2~/BIC/Z_PAWNNTO
)
INNER JOIN /BIC/ADSO_GR0200 AS t1
ON ( t1~/BIC/Z_PAWNNUM EQ t0~/BIC/Z_PAWNNUM ).
RESULT = LV_SUM_DarlPfandbereich.

If I check the code for syntax errors I get:

E:Wrong Expression "BETWEEN T2~/BIC/Z_PWNNFRO" in logical condition.


What am I doing false. I cannot figure it out.