topic Re: simple abap query doubt in Application Development and Automation Discussions

simple abap query doubt

Former Member — Wed, 10 Sep 2008 07:01:47 GMT

Hello all,

i have one simple doubt plz help.

data:begin of itab1 occurs 0,

psnfh like plfh-psnfh,

end of itab1.

select psnfh into table itab1

from plfh

where plnty = 'N'

AND plnNR = group_number

AND plnfl = W_PRT_ASSIGN-SEQUENCE_NO

and loekz ne 'X'

and plnkn = t_plnkn.

this query is working fine.

now i have 3 psnfh entires(0010 0020 0030) ..my requirement is that i have choose maximum of these that is 0030 and wanna add 0010 to it everytime.....and may be it will be better if i can save it in a variable.......

plz help in this syntax......i know we can use MAX function but it will be better if u can give that exact 2-3 lines of code.

Re: simple abap query doubt

Former Member — Wed, 10 Sep 2008 07:07:04 GMT

Hi,

do it in this way.

in a loop first compare the values and assign max value to a variable.

then again in a loop increase the value as per your requirment.

hope it will help you.

Thanks

Rajesh Kumar

Re: simple abap query doubt

Former Member — Wed, 10 Sep 2008 07:09:53 GMT

Hi Abhijeet.

Let all the entries come into your internal table first. After you got all the entries :

sort itab by psnfh descending.

read table itab from wa index 1.

if sy-subrc eq 0.
   add 10 to wa_psnfh.
endif.

and delete rest of the records if unnecessary.

Regards,

Swapna.

Re: simple abap query doubt

Former Member — Wed, 10 Sep 2008 07:11:25 GMT

Hi,

Sort the internal table entries in descending order.

And delete all the remaining entries except the first entry,

Re: simple abap query doubt

Former Member — Wed, 10 Sep 2008 07:11:38 GMT

Hi Abhijeet,

Do you always want to add "0010" to the maximum value from that internal table?

If yes, then you can follow the steps mentioned below.

1. Declare temporary internal table and transfer al values from your main internal table to the temporary.

ITAB_TEMP[] = ITAB[].

2. Now Sort the temp table as follows.

SORT ITAB_TEMP BY fieldname DESCENDING.

3. Now if you READ this temp table with INDEX 1, you wil get the maximum value to which you can add the value.

READ TABLE ITAB_TEMP INTO W_ITAB INDEX 1.

IF SY-SUBRC EQ 0.

V_MAX = W_ITAB-field + 0010.

ENDIF.

Best Regards,

Ram.

Re: simple abap query doubt

Former Member — Tue, 10 Feb 2009 10:28:17 GMT

thnks