select count(distinct mblnr) from mkpf inner join mseg on mkpf~mblnr=mseg~mblnr and mkpf~mjahr=mseg~mjahr inner join ekko on mseg~ebeln=ekko~ebeln where mkpf~vgart='WE' and mseg~ebeln in (select ebeln from rseg inner join rbkp on rseg~belnr=rbkp~belnr and rseg~gjahr=rbkp~gjahr where rbkp~tcode<>'MR1M');
and does not run. It is running only if you give count(*)
Has anyone how can i write the sql in order to have the distinct results of the field mblnr