Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question