Select querry with 'AND' and 'OR'

Hi,

I have a select querry need to execute on 'AND' and 'OR'

SELECT * FROM zcat3_mov

INTO CORRESPONDING FIELDS OF TABLE lt_getdata

WHERE invr_date IN so_date

AND lifnr EQ so_lifnr

AND custodian EQ p_cust

AND bukrs EQ p_comp

AND clear EQ ' '.

1. case

will all the options mandatory

2. case

with or without custodian

3. case

with or without vendor

Can anyone please help me with this three querries.

Thanks

Fed