SQVI output problem

[Former Member]

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]

Hi

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

[Former Member]

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]

created z program and delete duplicates