User Exit For Extract Structure

[Former Member]

Hi,

I need help for select statement to retreive only selected data from R/3 to BW. Like I have IHPA table and field called PARVW and I need only particular values they are ZO,ZV,PA,PP.

Please give me select statement to get only this values.

Thanks

Dave.

[Former Member]

hi,

select * from IHPA where ( parvw = 'ZO' or parvw = 'ZV' or parvw = 'PA' or

parvw = 'PP' ).

xxxxxxxxxxxxxx

endselect.

i think this will help u.

regards,

bharat.

[Former Member]

Hi Bharat,

Sorry for late reply, here I have to check the condition with OBJNR(object number) between the tables. Please give me how to include this condtion in select statement.

Thanks

Dave.