topic Re: Select max from internal table in Application Development and Automation Discussions

Select max from internal table

Former Member — Mon, 26 May 2008 19:32:28 GMT

Hi,

i have the following internal table :

Matnr werks lgort year period

|000000000007000007|3010 |100 |2008 | 04

|000000000007000007|3010 |100 |2008 | 05

|000000000007000007|3010 |500 |2008 | 05

|000000000007000008|3010 |100 |2008 | 05

|000000000007000008|3010 |500 |2006 | 05

|000000000007000008|3010 |500 |2008 | 05

i need the following result :

000000000007000007|3010 |100 |2008 | 05

000000000007000007|3010 |500 |2008 | 05

000000000007000008|3010 |100 |2008 | 05

000000000007000008|3010 |500 |2008 | 05

it means that i need the max "period" for each matnr werks lgort year.

i can sort the table by matnr werks lgort year period DESCENDING.

An then, what is the step ?

thanks a lot, full points if helpul,

Mário.

Re: Select max from internal table

Former Member — Mon, 26 May 2008 19:55:19 GMT

Hi,

The best way would be in selection with MAX and GROUP BY.

You wrote right, using sort, after using loop with comparing the fields changes.

Hope it helps.

Re: Select max from internal table

Former Member — Mon, 26 May 2008 19:59:03 GMT

thanks for your answer !!

but can i put the code to check the changes ? i tryed but with no success !!

thanks in advance,

Mário.

Re: Select max from internal table

Former Member — Mon, 26 May 2008 20:35:07 GMT

After your sort use:


DELETE ADJACENT DUPLICATES FROM itab COMPARING matnr werks lgort year.

and you will have the result you want.

Greetings,

Gert

Re: Select max from internal table

former_member491305 — Mon, 26 May 2008 21:24:04 GMT

Hi Mario,

Here it is...

1.First you have to sort itab by all the 5 field with period alone as descending.

2.While Deleting adjacent duplicates remove "period" field.

sample code:

Sort itab by matnr werks lgort year period descending.*

Delete Adjacent duplicates from itab comparing matnr werks lgort year.

Regards,

Vigneswaran S