this is basic question but iam confusing.
in my selection contains two fields like matnr and werks.
if user give matnr only i will get all matnrs.
if user give matnr and werks i need matnr no's based on werks.
how can i write select statement based on mara and marc.