ONLY NONZERO VALUES

HELLO EVERYONE,

I AM USING 2 TABLES <b>MARA</b> AND <b>MCHB</b>.WITH <b>MARA-MATNR</b> V HAV TO RETRIEVE <b>MCHB-MATNR</b> AND <b>WERKS</b>.THE <b>WERKS</b> BEING RETRIEVED FROM <b>MHCB</b> HAS TO B NONZERO.THE <b>WERKS</b> FLD WITH ZERO MUST NOT BE RETRIEVED AGAINST THE <b>MATNR</b>.CAN ANYONE KINDLY HELP ME.

THANKING YOU IN ANTICIPATION.

REGARDS,

SIRISHA.