topic Re: can we use function MAX MIN on internal table in Application Development and Automation Discussions

can we use function MAX MIN on internal table

Former Member — Sat, 21 Jun 2008 09:14:54 GMT

can i use MAX, MIN function on internal table , i can use while selecting data from database table but can i use the same from internal table, if no then is there any thing from which i can calculate the max , min and avg value

there are approx 40 fields in a table .

Thanks.

Re: can we use function MAX MIN on internal table

Former Member — Sat, 21 Jun 2008 09:30:57 GMT

There is one way you can get the Max, MIn & avg values from internal table.

SORT (the internal table) BY (Key).
          READ TABLE it_table  INTO wa_table INDEX 1.
          IF sy-subrc EQ 0.
         "This forms the Min value
          ENDIF.
          DESCRIBE TABLE it_table LINES v_line.
          READ TABLE it_table INTO wa_table INDEX v_line.
          IF sy-subrc EQ 0.
            "This forms the Max value
          ENDIF.
        ENDIF.

Calculate the average from this.

Regards

Kannaiah

Re: can we use function MAX MIN on internal table

Former Member — Sat, 21 Jun 2008 09:45:39 GMT

hi check this.....

http://help.sap.com/saphelp_nw04s/helpdata/en/0f/486fae2f9611d3a98100a0c9449261/frameset.htm

Re: can we use function MAX MIN on internal table

Former Member — Sat, 21 Jun 2008 10:43:23 GMT

thanks