topic Re: ABAP CODE TO GET VALUE in Application Development and Automation Discussions

ABAP CODE TO GET VALUE

Former Member — Fri, 12 Feb 2016 13:25:09 GMT

Hello All.

We have requirements to get max value.

EG.:

Days	ABC1	ABC2	ABC3	ABC4	ABC5	ABC6
Black	12	52	5	45	30	27
Blue
Mismatch

Here,I give some output.

I am Using Module-Pool-Table Wizard..

I fill data manually in abc1, abc2, abc3, abc4, abc5 and abc6. when i enter at abc6 value then automatically insert maximum 3 value in winner1, winner2, winner3 fields of current raw.

Please Advise and Needful.

Thanx in Advance.

Re: ABAP CODE TO GET VALUE

retired_member — Fri, 12 Feb 2016 13:43:26 GMT

There's a built-in function nmax. But since you need three values, put them into an array (internal table), sort it descending and get the first three elements.

Horst

Re: ABAP CODE TO GET VALUE

Former Member — Fri, 12 Feb 2016 14:24:49 GMT

Hi Chintan,

You should take a look at DEMO_DYNPRO_TABLE_CONTROL_1.

That demo program will show you how to read a input line and then just write a loop that compares the itab structure to find the max value for each line that was changed and set the winner field to what ever value you want.

Hope this helps,

Geoffery

Re: ABAP CODE TO GET VALUE

retired_member — Fri, 12 Feb 2016 15:13:44 GMT

That's my program

Re: ABAP CODE TO GET VALUE

Former Member — Sat, 13 Feb 2016 10:54:30 GMT

Problem Resolved.

Its really helpful for me.

Thank you so much.

Re: ABAP CODE TO GET VALUE

Former Member — Sun, 14 Feb 2016 10:07:57 GMT

Hi,

Sorting an internal table for a simple max query sound like an overkill to me.

Re: ABAP CODE TO GET VALUE

former_member184158 — Sun, 14 Feb 2016 10:19:56 GMT

Hi Horst,

how it is you program and it is created by SAP?

it was created in 1998.

Tahnk you

Regards

Ebrahim

Re: ABAP CODE TO GET VALUE

paul_bakker2 — Sun, 14 Feb 2016 10:49:04 GMT

Hi,

It seems that SAP programs are actually created by real people, like Horst.

He is a famous SAP employee

cheers

Paul

Re: ABAP CODE TO GET VALUE

former_member184158 — Sun, 14 Feb 2016 10:56:49 GMT

Hi Paul,

thank you for this Info.

I did not know that, it is really interesting

Respect Dr Horst

Regards

Ebrahim

Re: ABAP CODE TO GET VALUE

retired_member — Sun, 14 Feb 2016 13:53:59 GMT

Its part of my package SABAPDEMOS that contains the executable examples of the ABAP documentation's example library.

Re: ABAP CODE TO GET VALUE

retired_member — Mon, 15 Feb 2016 06:32:35 GMT

How would you do it?

Chintan needs the first three max values.

And itabs are fast and simple. I use them for such tasks very often.

Re: ABAP CODE TO GET VALUE

Former Member — Mon, 15 Feb 2016 11:51:29 GMT

My fault

I missed the three max values thing.

Using itab would be a good option then.

Re: ABAP CODE TO GET VALUE

Former Member — Mon, 15 Feb 2016 16:48:21 GMT

Ever read 'Abap Objects' ???

Re: ABAP CODE TO GET VALUE

former_member184158 — Wed, 17 Feb 2016 08:21:55 GMT

Hi Horst.,

I have just read about it, The examples in SABAPDEMOS are very useful and interesting.

Thank you.

Regards

Ebrahim

Re: ABAP CODE TO GET VALUE

former_member184158 — Wed, 17 Feb 2016 08:25:34 GMT

Hi Richard,

when I was started to learn ABAP, I have started with BC400, BC401 ( ABAP Object) BC430 etc.

I have done this to get the certificate.

Re: ABAP CODE TO GET VALUE

Former Member — Wed, 17 Feb 2016 08:52:46 GMT

Hi Ebrahim,

I was not doubting your education, I was (in an English way) pointing out Horst Keller's background.

I think we can put this one down to 'Lost In Translation'....

Rich

Re: ABAP CODE TO GET VALUE

former_member184158 — Wed, 17 Feb 2016 09:48:44 GMT

Hi Richard,

you are right, Lost In Translation

Ibo

Re: ABAP CODE TO GET VALUE

Former Member — Wed, 17 Feb 2016 12:23:26 GMT

Yes. You are right Mr. Horst. max value is imp to tk it.

Got max 3 value with sorting.

thanx for d suggestions. its very halpful for me.

thank you so much.