Getting a Syntax Error: Unknown Fields in SAP ABAP

You need to add spaces after or before braces as follows −

SELECT  *
FROM CNTRB
WHERE AGE > 30
AND   CNTRB > 10000
AND NOT ( FUND1 = 'value' AND FUND2 = '0' )