SAP Query (SQ02) - Repeated Data

[Former Member]

Hi Gurus,

I'm using the SAP Query tools to build a report.

I have to compare four table but I have a problem: Data comes repeated.

In the outbound delivery, I need to check for one position and material number the stock that I have in two differente storage type in the WM module.

When I execute the query, the item line of the delivery as well as its quantity is repeated as much as storage bin found for this material:

Oubound Delivery Number Item Material Delivery Quantity Storage bin Storage bin quantity

80000000230--

---

1

---

XXXXXXXX

---

1

---

AD1--

---

60

80000000230--

---

1

---

XXXXXXXX

---

1

---

AD2--

---

40

80000000230--

---

1

---

XXXXXXXX

---

1

---

AD3--

---

35

80000000230--

---

1

---

XXXXXXXX

---

1

---

AD4--

---

60

I would like the result to appear as follows, but i don't any programming knoledge. I know there is an option to put some coding in the query. Could anyone guide me or give me a piece of the code that I would have to put ?

80000000230--

---

1

---

XXXXXXXX

---

1

---

AD1--

---

60

-

---

AD2----

---

40

-

---

AD3----

---

35

-

---

AD4----

---

60

Best regards,

Remi

[Former Member]

Assuming that you are outputting your query as an ALV list, use the sorting functionality to get the display to look exactly as you have depicted. In the ALV display, select the first two columns and click on the sort button.