topic Re: Please help in Application Development and Automation Discussions

Please help

Former Member — Sun, 04 Feb 2007 04:21:37 GMT

I'm using LINV table in my select stat. I'd like to satisfy this condition that ( if matnr, batch and storage bin are same then it should pick only one latest record). Please help.

for example,

storage bin matnr batch date

10009 10000121 31.03.2003 10009 10000121 01.04.2003

10010 10000121 01.04.2003

so the result should be

storage bin matnr batch date

10009 10000121 01.04.2003

10010 10000121 01.04.2003

Re: Please help

rahulkavuri — Sun, 04 Feb 2007 05:27:43 GMT

For doing this first u need to sort ur internal table records by first 3 fields...

SORT ITAB BY MATNR STORAGEBIN BATCH .

this will bring all your fields in descending order with batchdate also sorted.

Next...

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING MATNR STORAGEBIN.

This will delete all ur records which are having same MATNR STORAGEBIN.

This will have your highest date record at the top

please award points if this solves your problem

Re: Please help

Former Member — Sun, 04 Feb 2007 05:39:49 GMT

batch date u have to sort by descending

SORT ITAB BY MATNR STORAGEBIN BATCH <b> descending.</b>