REVAL Join of Cardex with Control Tables

SELECT ilkco, pcev07, COUNT(*) FROM proddta.F554113, proddta.F554114, proddta.F4111
WHERE
rauk01 = pcuk01 AND
raukid = pcukid AND
raukid = ilukid AND
--raitm = 349869 AND
pcev07 = 'E'
GROUP BY ilkco, pcev07