topic Re: Sort in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276714#M783484 <HTML><HEAD></HEAD><BODY><P>Hi Kiran,</P><P></P><P>Check it.</P><P></P><P>SORT it_itab BY matnr.</P><P></P><P>DELETE ADJACENT DUPLICATES FROM it_itab COMPARING matnr</P></BODY></HTML> Mon, 21 Jan 2008 04:42:59 GMT Former Member 2008-01-21T04:42:59Z Sort https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276712#M783482 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>-</P><HR originaltext="--------------------------------------------------" /><TABLE><TBODY><TR><TD><P>Material</P></TD><TD><P>Posting Date</P></TD><TD><P>Vendor</P></TD><TD><P>Mat.Doc.No</P></TD><TD><P>Bal.Qty</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="--------------------------------------------------" /><TABLE><TBODY><TR><TD><P>ID0169164</P></TD><TD><P>07.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>412783</P></TD><TD><P>4.000</P></TD></TR><TR><TD><P>ID0169164</P></TD><TD><P>07.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>412784</P></TD><TD><P>8.000</P></TD></TR><TR><TD><P>ID0169164</P></TD><TD><P>16.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413064</P></TD><TD><P>14.000</P></TD></TR><TR><TD><P>ID0169164</P></TD><TD><P>16.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413065</P></TD><TD><P>34.000</P></TD></TR><TR><TD><P>ID0169164</P></TD><TD><P>19.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413162</P></TD><TD><P>14.000</P></TD></TR><TR><TD><P>ID0169164</P></TD><TD><P>20.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413171</P></TD><TD><P>24.000</P></TD></TR><TR><TD><P>ID0169164</P></TD><TD><P>20.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413172</P></TD><TD><P>34.000</P></TD></TR><TR><TD><P>ID0169164</P></TD><TD><P>08.11.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413761</P></TD><TD><P>80.000</P></TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD><P>ID0169167</P></TD><TD><P>16.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413064</P></TD><TD><P>20.000</P></TD></TR><TR><TD><P>ID0169167</P></TD><TD><P>16.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413065</P></TD><TD><P>60.000</P></TD></TR><TR><TD><P>ID0169167</P></TD><TD><P>19.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413162</P></TD><TD><P>20.000</P></TD></TR><TR><TD><P>ID0169167</P></TD><TD><P>20.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413171</P></TD><TD><P>40.000</P></TD></TR><TR><TD><P>ID0169167</P></TD><TD><P>20.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413172</P></TD><TD><P>60.000</P></TD></TR></TBODY></TABLE><P></P><P></P><P>I want to sort the above one in such a way that when I delete the adjacent duplicates after sorting the internal table should contain only</P><TABLE><TBODY><TR><TD><P>ID0169164</P></TD><TD><P>08.11.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413761</P></TD><TD><P>80.000</P></TD></TR><TR><TD><P>ID0169167</P></TD><TD><P>20.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413172</P></TD><TD><P>60.000</P></TD></TR></TBODY></TABLE><P></P><P>ie.Material with the latest budat and mblnr and its corresponing bal quantity.</P><P></P><P><EM>sort itab by matnr budat ascending.</EM></P><P><EM>delete adjacent duplicates from itab comparing lifnr matnr.</EM></P><P>is not giving me the result.Can anyone here please let me where I am going wrong.</P><P></P><P>Thanks,</P><P>K.Kiran.</P><P></P><P>Edited by: Kiran K on Jan 21, 2008 5:39 AM</P></BODY></HTML> Mon, 21 Jan 2008 04:25:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276712#M783482 kiran_k8 2008-01-21T04:25:29Z Re: Sort https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276713#M783483 <HTML><HEAD></HEAD><BODY><P>Hi kiran,</P><P></P><P>first sort the internal table as per</P><P></P><P>sort itab by matnr ascending budat descending.</P><P></P><P>then u delete the records as .</P><P></P><P>delete adjacent duplicates from itab comparing matnr.</P><P></P><P></P><P>regards,</P><P>Santosh thorat</P></BODY></HTML> Mon, 21 Jan 2008 04:42:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276713#M783483 Former Member 2008-01-21T04:42:21Z Re: Sort https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276714#M783484 <HTML><HEAD></HEAD><BODY><P>Hi Kiran,</P><P></P><P>Check it.</P><P></P><P>SORT it_itab BY matnr.</P><P></P><P>DELETE ADJACENT DUPLICATES FROM it_itab COMPARING matnr</P></BODY></HTML> Mon, 21 Jan 2008 04:42:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276714#M783484 Former Member 2008-01-21T04:42:59Z Re: Sort https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276715#M783485 <HTML><HEAD></HEAD><BODY><P>Santhosh,</P><P></P><P>Thanks,but it won't give me the latest balance quantity if there are two mblnrs on the same posting date.</P><P></P><P>As per yours it will result in this.</P><TABLE><TBODY><TR><TD><P>ID0169164</P></TD><TD><P>08.11.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413761</P></TD><TD><P>80.000</P></TD></TR><TR><TD><P>ID0169167</P></TD><TD><P>20.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413171</P></TD><TD><P>40.000</P></TD></TR></TBODY></TABLE><P></P><P>but what needed is this.</P><TABLE><TBODY><TR><TD><P>ID0169164</P></TD><TD><P>08.11.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413761</P></TD><TD><P>80.000</P></TD></TR><TR><TD><P>ID0169167</P></TD><TD><P>20.08.2004</P></TD><TD><P>IC-KIT</P></TD><TD><P>413172</P></TD><TD><P>60.000</P></TD></TR></TBODY></TABLE><P></P><P>When there are two MBLNRS on the latest posting date then I should consider the latest MBLNR and its balance quantity.</P><P></P><P>Thanks,</P><P>K.Kiran.</P></BODY></HTML> Mon, 21 Jan 2008 04:51:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276715#M783485 kiran_k8 2008-01-21T04:51:48Z Re: Sort https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276716#M783486 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>sort itab by matnr ascending budat descending XBLNR DESCENDING.</P><P></P><P>then u delete the records as .</P><P></P><P>delete adjacent duplicates from itab comparing matnr.</P><P></P><P></P><P>Regards,</P><P>Santosh Thorat</P></BODY></HTML> Mon, 21 Jan 2008 04:56:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sort/m-p/3276716#M783486 Former Member 2008-01-21T04:56:29Z