Query in SAP

handry_orozco — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Query in SAP

MK_QSL — Mon, 23 Jan 2017 15:34:40 GMT

May be try

Where VBRP~POSNR IN ('00001');