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...