topic Re: SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Fri, 28 Dec 2007 05:05:20 GMT

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.

Re: SELECT STATEMENT

Former Member — Fri, 28 Dec 2007 05:21:52 GMT

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

Re: SELECT STATEMENT

Former Member — Fri, 28 Dec 2007 05:31:19 GMT

Can u write ur question more clearly

Re: SELECT STATEMENT

Former Member — Fri, 28 Dec 2007 05:56:43 GMT

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 .

Re: SELECT STATEMENT

Former Member — Fri, 28 Dec 2007 07:21:40 GMT

HI EXPERTS,

THANKS A LOT GUYS .PROBLEM SOLVED.

GIVEN FULL POINTS TO ALL

CHEERS!

SUNITA.

Re: SELECT STATEMENT

Former Member — Fri, 28 Dec 2007 07:31:41 GMT

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