SELECT STATEMENT

[Former Member]

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.

[Former Member]

select a~vbeln

a~posnr

a~parvw

a~kunnr

b~vbeln

b~posnr into corresponding fields of table itab

from vbpa as a inner join vbrp as b

on a_{vbeln = b}vbeln and a_{posnr = b}posnr

where a~parvw = 'WE'.

regards,

pavan

REward points if useful

[Former Member]

Can u write ur question more clearly

[Former Member]

chek

SELECT kunnr FROM VBPA INTO TABLE WA_REPORT FOR ALL ENTRIES IN ZS001

where vbrp-vbeln = vbpa-vbeln and

PARVW = "WE" AND

vbrp-posnr = vbpa-posnr .

[Former Member]

HI EXPERTS,

THANKS A LOT GUYS .PROBLEM SOLVED.

GIVEN FULL POINTS TO ALL

CHEERS!

SUNITA.

[Former Member]

hi,

it is nice to hear that u r problem is solved, but points u allotted for varma only, kindly allocate points to all useful answers here onwards.

regards,

pavan