SELECT STATEMENT

[Former Member]

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

[seshatalpasai_madala]

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

[Former Member]

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')