topic Re: User Exit For Extract Structure in Application Development and Automation Discussions

User Exit For Extract Structure

Former Member — Tue, 20 Mar 2007 03:54:42 GMT

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.

Re: User Exit For Extract Structure

Former Member — Tue, 20 Mar 2007 04:27:16 GMT

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.

Re: User Exit For Extract Structure

Former Member — Tue, 20 Mar 2007 15:46:39 GMT

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.