topic SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Tue, 28 Aug 2007 07:46:39 GMT

HI,

I HAVE TO RETRIVE THE DATA FROM VBPA WHERE ( VBELN = ITAB-VBELN AND PARVW = 'AG' ) + ( VBELN = ITAB-VBELN AND PARVW ='WE'.

SELECT VBELN

PARVW

KUNNR

FROM VBPA

INTO TABLE IT_VBPA

WHERE VBELN = ITAB-VBELN

PARVW = 'AG' .

PARVW = 'WE'.

THANKS

sURESH

Re: SELECT STATEMENT

seshatalpasai_madala — Tue, 28 Aug 2007 07:49:30 GMT

Hi,

SELECT VBELN

PARVW

KUNNR

FROM VBPA

INTO <b>CORRESPONDING FIELDS OF</b> TABLE IT_VBPA

WHERE <b>VBELN = ITAB-VBELN AND ( PARVW = 'AG' OR PARVW = 'WE'</b> ).

Regards,

Sesh

Re: SELECT STATEMENT

Former Member — Tue, 28 Aug 2007 07:50:29 GMT

it looks like you want all the data from VBPA coprresponding to VBELN in ITAB...

please use the query

SELECT VBELN .. from VBPA into table IT_VBPA

FOR ALL ENTRIES in ITAB

where VBELN = ITAB-VBELN and

( PARVW = 'AG' or PARVW = 'WE')