can we write a join on a view and a table

Hi all,

can we write a join on a view and a table. i got the requirement from my functional people about the following one

Select CAUFV-AFUNR, CAUFV-AUART, AFVC-VORNR, CAUFV-FTRMI, CRHD-ARBPL

into <ProOrd>, <OrdTyp>, <Opt>, <RelDat>, <WorCen>

from CAUFV, AFVC, CRHD

where CAUFV-WERKS = plant in selection screen

and CAUFV-AFUNR = production order in selection screen

and CAUFV-AUART = production order type in selection screen

and CAUFV-FTRMI = range of release date in selection screen

and CAUFV-AUFPL = AFVC-AUFPL

and AFVC-ARBID = CRHD-OBJID

and CRHD-OBJTY = ‘A’

here CAUFV is a view and CRHD and AFVC are transperent tables.

please tell me any feasible solution for this..

Thanks in Advance..