Query in SAP

[handry_orozco]

Hi experts

Select BSID~GJAHR

            BSID~VBELN

            BSID~BUDAT  

            BSID~BELNR   

            BSID~BUZEI   

            BSID~HKONT   

            BSID~WRBTR   

            BSID~SHKZG

            VBRP~WERKS 

  From BSID

  Left Join VBRP 

            On (BSID~VBELN = VBRP~VBELN

          And BSID~BUDAT = VBRP~ERDAT)

  Where VBRP~POSNR IN '00001';

VBRP~POSNR IN '00001';

But show this error "In the WHERE condition, no field in the right table of a LEFT OUTER JOIN can appear: "VBRP ~ POSNR"

I need this condition

Thanks

[MK_QSL]

May be try

  Where VBRP~POSNR IN ('00001');