topic Re: SQVI output problem in Application Development and Automation Discussions

SQVI output problem

Former Member — Thu, 29 Oct 2009 01:57:06 GMT

Hi Experts,

Got a problem in SQVI output. data was repeated twice.

I combine bsis and mseg and selected the following fields:

bsis-budat

bsis-blart

bsis-belnr

bsis-dmbtr

mseg-bwart

mseg-weks

mseg-matnr

link is bsis-belnr and mseg mblnr.

i dont know whats going wrong.

any help will be greatly appreciated.

many thanks.

Former Member — Thu, 29 Oct 2009 05:05:22 GMT

Copy this program to z program then check and correct the duplicate value.

Former Member — Thu, 29 Oct 2009 05:09:36 GMT

Hi ,

U follow like this ........

Select budat

blart

belnr

dmbtr

from BSIS into table t_bsis

now select the data from MSEG

select bwart

weks

matnr

from MSEG into t_mseg

for all entries in t_bsis

where mblnr = t_bsis-belnr

delete adjacent duplicate from t_mseg comparing all fields.

Try with this code , it help

thanks

shambhu

Former Member — Thu, 10 Jun 2010 03:52:11 GMT

created z program and delete duplicates