I am writing below query and getting below current result which is four rows. i would like to have result mentioned below in expected result which is single row.. any idea how can i do that? It can be easily done in sql-plus using decode or union clause. but please suggest how to do it in abap.
select distinct
qmsm~qmnum
qmel~qmtxt
qmsm~mncod
qmsm~pster
qmsm~peter
ihpa~parvw
ihpa~parnr
from qmsm
inner join qmma
on qmsmqmnum = qmmaqmnum
inner join qmel
on qmmaqmnum = qmelqmnum
inner join ihpa
on qmelobjnr = ihpaobjnr
into table ztstnotifications
where
qmel~qmnum = '000100000166'
and qmma~material = wa_material
and qmsm~mncod in ('2','4')
and ihpa~parvw in ('1A','ZY')
order by qmsm~qmnum
qmel~qmtxt
qmsm~mncod
qmsm~pster
qmsm~peter.
current result
100000166 will it work 2 22.10.2009 31.10.2009 SP 1000688
100000166 will it work 2 22.10.2009 31.10.2009 ZY AE001
100000166 will it work 4 01.01.2010 15.01.2010 SP 1000688
100000166 will it work 4 01.01.2010 15.01.2010 ZY AE001
expected result
100000166 will it work 2 22.10.2009 31.10.2009 4 01.01.2010 15.01.2010 SP 1000688 ZY AE001
Thanks