Skip to Content
Former Member
Oct 10, 2008 at 04:33 AM

Select Problem


Hi all,

I have a prob in selecting the fields from the table MARDH. I want to select the fields like meintion below,

Matnr werks lgort lfgja lfmon labst

111 aaa bbb 2007 11 100

111 aaa ccc 2007 11 50

I used the select stat. but it is giving me 2 records bcoz threr r 2 diff. sto. locns. but the thing is that im not selecting LGORT in the select statement still it is showing me 2 records i want the O/P in the following way with addition of labst.

Matnr werks lfgja lfmon labst

111 aaa 2007 11 150

i have an instructions, not to use GROUP by and SELECT SUM so is thr any other option available plzz help me out in brief...