SELECT STATEMENT

Hi Gurus,

help me with select statement.

Ship to code--- Get vbpa-kunnr where

vbrp-vbeln = vbpa-vbeln

and PARVW = "WE"

AND vbrp-posnr = vbpa-posnr.

i have a structure called zooos1 i defined these fields .

i want this kunnr into <wa_report>-kunnr.

plz help me gurus,

THANKS&REGARDS

SUNITA.