help in select

hi,

i wont to do this select for all project that how can i do that fits my condtion how can i do that ?

(in the code the project num is come from user.

Regards

    SELECT vbrk~vbeln vbrk~vbtyp vbrk~fkdat vbrk~netwr vbrk~waerk vbrp~kvgr3
      FROM vbrk INNER JOIN vbrp ON vbrp~vbeln EQ vbrk~vbeln
                 AND vbrp~posnr EQ '00010'
                 AND vbrp~ps_psp_pnr EQ l_project "here for all project 
  INTO TABLE sdpro
  WHERE vbrk~rfbsk EQ 'C'
        AND vbrk~fksto EQ ' '
        AND vbrk~sfakn EQ ' '.