hi,
may i know if or keyword in sql statement correct? if this field has empty or 0 value then will not select it. this is a char type. or any other way which is better than mine?
thanks.
SELECT axxx ayyy a~parob
INTO CORRESPONDING FIELDS OF wa_tab
FROM coep AS a INNER JOIN csks AS b ON aobjnr = bobjnr
WHERE
a~gjahr = p_gjahr AND
b~kostl IN s_kostl AND
a~parob <> '' OR
a~parob <> '0'.