topic Re: problm in selecting max value in Application Development and Automation Discussions

problm in selecting max value

Former Member — Sat, 30 May 2009 10:31:00 GMT

i have written below code

wn i execute im getting error as 'You cannot use an internal table as a work area.'

how to solve this?

SELECT  a~aufnr
          a~plnbez
          a~gstrp
          a~gltrp
          a~gstri
          a~gltri
          a~gstrs
          a~gltrs
*         a~getri
          a~FTRMI
          b~ktext
          b~objnr
          c~charg
          c~dwerk
     INTO TABLE it_final
     FROM afko AS a
     INNER JOIN aufk AS b ON a~aufnr = b~aufnr
     INNER JOIN afpo AS c ON a~aufnr = c~aufnr
     WHERE  (cond_syntax)
     AND c~dwerk = p_werk
     AND a~fevor IN s_fevor
     AND a~dispo IN s_dispo .

*get actual Finish Date
IF NOT IT_FINAL[] IS INITIAL.
SELECT MAX( BUDAT ) aufnr
     FROM AFRU
    INTO IT_AFRU
*    FOR ALL ENTRIES IN IT_FINAL
    WHERE AUFNR = IT_FINAL-AUFNR
    AND WERKS = P_WERKS.
ENDSELECT.
ENDIF.

Regard

Smitha

Re: problm in selecting max value

Former Member — Sat, 30 May 2009 10:45:41 GMT

HI,

SELECT  a~aufnr
          a~plnbez
          a~gstrp
          a~gltrp
          a~gstri
          a~gltri
          a~gstrs
          a~gltrs
*         a~getri
          a~FTRMI
          b~ktext
          b~objnr
          c~charg
          c~dwerk
     INTO TABLE it_final
     FROM afko AS a
     INNER JOIN aufk AS b ON a~aufnr = b~aufnr
     INNER JOIN afpo AS c ON a~aufnr = c~aufnr
     WHERE  (cond_syntax)
     AND c~dwerk = p_werk
     AND a~fevor IN s_fevor
     AND a~dispo IN s_dispo .
 
*get actual Finish Date
IF NOT IT_FINAL[] IS INITIAL.
SELECT MAX( BUDAT ) aufnr
     FROM AFRU
    INTO TABLE IT_AFRU                    " Add Table declaration
*    FOR ALL ENTRIES IN IT_FINAL
    WHERE AUFNR = IT_FINAL-AUFNR
    AND WERKS = P_WERKS.
* ENDSELECT.                                   "  Comment Endselect
ENDIF.

Re: problm in selecting max value

Former Member — Sat, 30 May 2009 12:48:46 GMT

Hi Smitha,

For all the tables with header line a simple TABLE prefix should be added thats the solution to your problem,

add TABLE infront of internal table in the select query.

For further details

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb36a1358411d1829f0000e829fbfe/content.htm

Thanks

Ram