Skip to Content
0
Former Member
Dec 01, 2009 at 03:53 PM

HELP FOR ABAP SELECT STATEMENT

108 Views

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