topic SAP Query (SQ02) - Repeated Data in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-sq02-repeated-data/m-p/3988414#M952823 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P></P><P>I'm using the SAP Query tools to build a report.</P><P></P><P>I have to compare four table but I have a problem: Data comes repeated.</P><P></P><P>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.</P><P></P><P>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:</P><P></P><P><STRONG>Oubound Delivery Number</STRONG> <STRONG>Item</STRONG> <STRONG>Material</STRONG> <STRONG>Delivery Quantity</STRONG> <STRONG>Storage bin</STRONG> <STRONG>Storage bin quantity</STRONG></P><P></P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD1</DEL>--<P></P><HR originaltext="--------------------" /><P>60</P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD2</DEL>--<P></P><HR originaltext="--------------------" /><P>40</P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD3</DEL>--<P></P><HR originaltext="--------------------" /><P>35</P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD4</DEL>--<P></P><HR originaltext="--------------------" /><P>60</P><P></P><P>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 ?</P><P></P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD1</DEL>--<P></P><HR originaltext="--------------------" /><P>60</P><P>-</P><HR originaltext="------------------------------------------------------------------------------------------------------------" /><P>AD2----</P><HR originaltext="--------------------" /><P>40</P><P>-</P><HR originaltext="------------------------------------------------------------------------------------------------------------" /><P>AD3----</P><HR originaltext="--------------------" /><P>35</P><P>-</P><HR originaltext="------------------------------------------------------------------------------------------------------------" /><P>AD4----</P><HR originaltext="--------------------" /><P>60</P><P></P><P>Best regards,</P><P></P><P>Remi</P></BODY></HTML> Sat, 21 Jun 2008 13:10:47 GMT Former Member 2008-06-21T13:10:47Z SAP Query (SQ02) - Repeated Data https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-sq02-repeated-data/m-p/3988414#M952823 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P></P><P>I'm using the SAP Query tools to build a report.</P><P></P><P>I have to compare four table but I have a problem: Data comes repeated.</P><P></P><P>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.</P><P></P><P>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:</P><P></P><P><STRONG>Oubound Delivery Number</STRONG> <STRONG>Item</STRONG> <STRONG>Material</STRONG> <STRONG>Delivery Quantity</STRONG> <STRONG>Storage bin</STRONG> <STRONG>Storage bin quantity</STRONG></P><P></P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD1</DEL>--<P></P><HR originaltext="--------------------" /><P>60</P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD2</DEL>--<P></P><HR originaltext="--------------------" /><P>40</P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD3</DEL>--<P></P><HR originaltext="--------------------" /><P>35</P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD4</DEL>--<P></P><HR originaltext="--------------------" /><P>60</P><P></P><P>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 ?</P><P></P><P>80000000230--<DEL></DEL></P><HR originaltext="--------------------" />1<DEL><HR originaltext="---" />XXXXXXXX</DEL><DEL><HR originaltext="-----------" />1</DEL><DEL><HR originaltext="------------------" />AD1</DEL>--<P></P><HR originaltext="--------------------" /><P>60</P><P>-</P><HR originaltext="------------------------------------------------------------------------------------------------------------" /><P>AD2----</P><HR originaltext="--------------------" /><P>40</P><P>-</P><HR originaltext="------------------------------------------------------------------------------------------------------------" /><P>AD3----</P><HR originaltext="--------------------" /><P>35</P><P>-</P><HR originaltext="------------------------------------------------------------------------------------------------------------" /><P>AD4----</P><HR originaltext="--------------------" /><P>60</P><P></P><P>Best regards,</P><P></P><P>Remi</P></BODY></HTML> Sat, 21 Jun 2008 13:10:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-sq02-repeated-data/m-p/3988414#M952823 Former Member 2008-06-21T13:10:47Z Re: SAP Query (SQ02) - Repeated Data https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-sq02-repeated-data/m-p/3988415#M952824 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sat, 21 Jun 2008 14:39:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-sq02-repeated-data/m-p/3988415#M952824 Former Member 2008-06-21T14:39:39Z