Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SELECT STATEMENT

Former Member
0 Kudos
95

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
67

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 .

5 REPLIES 5

Former Member
0 Kudos
67

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 avbeln = bvbeln and aposnr = bposnr

where a~parvw = 'WE'.

regards,

pavan

REward points if useful

Former Member
0 Kudos
67

Can u write ur question more clearly

Former Member
0 Kudos
68

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
0 Kudos
67

HI EXPERTS,

THANKS A LOT GUYS .PROBLEM SOLVED.

GIVEN FULL POINTS TO ALL

CHEERS!

SUNITA.

0 Kudos
67

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